Обсуждение: 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