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 > Windows
Firewall.This is the same on Windows Server 2003(dot)Andyplatonovvp(at)agrisovgaz(dot)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(at)agrisovgaz(dot)ru> > > > >
---------------------------(end of broadcast)--------------------------->
TIP 2: Don't 'kill -9' the postmaster> >
!DSPAM:14,4453a5db33697833445445!> > >
__________________________________________________________
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