Обсуждение: connection refused 274D/10061

Поиск
Список
Период
Сортировка

connection refused 274D/10061

От
platonovvp@agrisovgaz.ru
Дата:
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




Re: connection refused 274D/10061

От
andy@andycc.net
Дата:
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!
>
>
>

Re: connection refused 274D/10061

От
Andy Shellam
Дата:
"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