Re: connection refused 274D/10061

Lists: pgsql-admin
From: platonovvp(at)agrisovgaz(dot)ru
To: pgsql <pgsql-admin(at)postgresql(dot)org>
Subject: connection refused 274D/10061
Date: 2006-04-28 06:16:01
Message-ID: 544720888.20060428101601@agrisovgaz.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-admin

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(at)agrisovgaz(dot)ru


From: andy(at)andycc(dot)net
To: platonovvp(at)agrisovgaz(dot)ru
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: connection refused 274D/10061
Date: 2006-04-29 18:28:41
Message-ID: iyhxzt.2of7gv@webmail.mailnetwork.co.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-admin

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 &gt; Windows
Firewall.This is the same on Windows Server 2003(dot)Andyplatonovvp(at)agrisovgaz(dot)ru
wrote:&gt; Help me ,please.&gt; &gt; What difference between installation
PGSQL on win-2000 and&gt; win-2000-server or on WIN-XP ?&gt; &gt; When i try
to connect to installed PGSQL on win-xp or win-200-server&gt; from other host
of local net, i get the message :&gt; &gt; Connection refused
(0x0000274D/10061)&gt; Is the server running on host &quot;192.168.1.21&quot;
and accepting&gt; TCP/IP connections on port 5432?&gt; &gt; When i installing
PGSQL on Win-2000 (not server) i have no this&gt; problem.&gt; &gt; All
changes in pg_hba.conf and in postgresql.conf have done.Maybe i must to &gt;
open&gt; some extra parameters in postgresql.conf file or do something else
?&gt; &gt; Os name : Microsoft Windows 2000 Server&gt; Version : 5.0.2195
Service Pack4 Build 2195.&gt; &gt; Version of PGSQL : 8.0&gt; Excuse me for my
poor English,please.&gt; ---------------&gt; Best regards
&Iuml;&euml;&agrave;&ograve;&icirc;&iacute;&icirc;&acirc;
&Acirc;&euml;&agrave;&auml;&egrave;&igrave;&egrave;&eth; (Platonov Vladimir
from Russia). &gt; mailto:platonovvp(at)agrisovgaz(dot)ru&gt; &gt; &gt; &gt; &gt;
---------------------------(end of broadcast)---------------------------&gt;
TIP 2: Don't 'kill -9' the postmaster&gt; &gt;
!DSPAM:14,4453a5db33697833445445!&gt; &gt; &gt;
__________________________________________________________
The mail network cannot accept liability for the content
of this e-mail. It is recommended you scan it for viruses
immediately upon receipt.

Is this e-mail spam? Report it to abuse(at)mailnetwork(dot)co(dot)uk


From: Andy Shellam <andy(at)andycc(dot)net>
To: platonovvp(at)agrisovgaz(dot)ru
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: connection refused 274D/10061
Date: 2006-05-03 13:08:54
Message-ID: 4458AB66.4010309@andycc.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-admin

"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