pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
connection refused 274D/10061
3+ messages / 3 participants
[nested] [flat]

* connection refused 274D/10061
@ 2006-04-28 06:16 platonovvp@agrisovgaz.ru
  2006-04-29 18:28 ` Re: connection refused 274D/10061 andy@andycc.net
  0 siblings, 1 reply; 3+ messages in thread

From: platonovvp@agrisovgaz.ru @ 2006-04-28 06:16 UTC (permalink / raw)
  To: 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@agrisovgaz.ru






^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: connection refused 274D/10061
  2006-04-28 06:16 connection refused 274D/10061 platonovvp@agrisovgaz.ru
@ 2006-04-29 18:28 ` andy@andycc.net
  2006-05-03 13:08   ` Re: connection refused 274D/10061 Andy Shellam <andy@andycc.net>
  0 siblings, 1 reply; 3+ messages in thread

From: andy@andycc.net @ 2006-04-29 18:28 UTC (permalink / raw)
  To: platonovvp@agrisovgaz.ru; +Cc: 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.Andyplatonovvp@agrisovgaz.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@agrisovgaz.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@mailnetwork.co.uk

^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: connection refused 274D/10061
  2006-04-28 06:16 connection refused 274D/10061 platonovvp@agrisovgaz.ru
  2006-04-29 18:28 ` Re: connection refused 274D/10061 andy@andycc.net
@ 2006-05-03 13:08   ` Andy Shellam <andy@andycc.net>
  0 siblings, 0 replies; 3+ messages in thread

From: Andy Shellam @ 2006-05-03 13:08 UTC (permalink / raw)
  To: platonovvp@agrisovgaz.ru; +Cc: 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




^ permalink  raw  reply  [nested|flat] 3+ messages in thread


end of thread, other threads:[~2006-05-03 13:08 UTC | newest]

Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2006-04-28 06:16 connection refused 274D/10061 platonovvp@agrisovgaz.ru
2006-04-29 18:28 ` andy@andycc.net
2006-05-03 13:08   ` Andy Shellam <andy@andycc.net>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox