Обсуждение: connection refused 274D/10061
Help me ,please.
What difference between installation PGSQL on win-2000 and
win-2000-server or on WIN-XP ?
When i try to connect to installed PGSQL on win-xp or win-200-server
from other host of local net, i get the message :
Connection refused (0x0000274D/10061)
Is the server running on host "192.168.1.21" and accepting
TCP/IP connections on port 5432?
When i installing PGSQL on Win-2000 (not server) i have no this
problem.
All changes in pg_hba.conf and in postgresql.conf have done.Maybe i must to open
some extra parameters in postgresql.conf file or do something else ?
Os name : Microsoft Windows 2000 Server
Version : 5.0.2195 Service Pack4 Build 2195.
Version of PGSQL : 8.0
Excuse me for my poor English,please.
---------------
Best regards Платонов Владимир (Platonov Vladimir from Russia). mailto:platonovvp@agrisovgaz.ru
If you're running Windows XP Service Pack 2 - you'll need to either turn off the Windows Firewall completely (not recommended) or tell it to create an exception for port 5432.
You can do this through Control Panel > Windows Firewall.
This is the same on Windows Server 2003.
Andy
platonovvp@agrisovgaz.ru wrote:
> Help me ,please.
>
> What difference between installation PGSQL on win-2000 and
> win-2000-server or on WIN-XP ?
>
> When i try to connect to installed PGSQL on win-xp or win-200-server
> from other host of local net, i get the message :
>
> Connection refused (0x0000274D/10061)
> Is the server running on host "192.168.1.21" and accepting
> TCP/IP connections on port 5432?
>
> When i installing PGSQL on Win-2000 (not server) i have no this
> problem.
>
> All changes in pg_hba.conf and in postgresql.conf have done.Maybe i must to
> open
> some extra parameters in postgresql.conf file or do something else ?
>
> Os name : Microsoft Windows 2000 Server
> Version : 5.0.2195 Service Pack4 Build 2195.
>
> Version of PGSQL : 8.0
> Excuse me for my poor English,please.
> ---------------
> Best regards Ïëàòîíîâ Âëàäèìèð (Platonov Vladimir from Russia).
> mailto:platonovvp@agrisovgaz.ru
>
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: Don't 'kill -9' the postmaster
>
> !DSPAM:14,4453a5db33697833445445!
>
>
>
You can do this through Control Panel > Windows Firewall.
This is the same on Windows Server 2003.
Andy
platonovvp@agrisovgaz.ru wrote:
> Help me ,please.
>
> What difference between installation PGSQL on win-2000 and
> win-2000-server or on WIN-XP ?
>
> When i try to connect to installed PGSQL on win-xp or win-200-server
> from other host of local net, i get the message :
>
> Connection refused (0x0000274D/10061)
> Is the server running on host "192.168.1.21" and accepting
> TCP/IP connections on port 5432?
>
> When i installing PGSQL on Win-2000 (not server) i have no this
> problem.
>
> All changes in pg_hba.conf and in postgresql.conf have done.Maybe i must to
> open
> some extra parameters in postgresql.conf file or do something else ?
>
> Os name : Microsoft Windows 2000 Server
> Version : 5.0.2195 Service Pack4 Build 2195.
>
> Version of PGSQL : 8.0
> Excuse me for my poor English,please.
> ---------------
> Best regards Ïëàòîíîâ Âëàäèìèð (Platonov Vladimir from Russia).
> mailto:platonovvp@agrisovgaz.ru
>
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: Don't 'kill -9' the postmaster
>
> !DSPAM:14,4453a5db33697833445445!
>
>
>
"There are no visible restrictions for ports in Windows-2000-server, but they exists (as we seen)." This is true. In that case, check your postgresql.conf config file for the listen_interfaces parameter, and check it is set to * (i.e. listen_interfaces = *). Then restart the PostgreSQL service if you've had to change it. Also check your pg_hba.conf, for the "ipv4" lines. Andy