Re: No connection to a PG 8.0 Beta 1 win32 server - Mailing list pgsql-general

From Richard Huxton
Subject Re: No connection to a PG 8.0 Beta 1 win32 server
Date
Msg-id 412B52C4.3040402@archonet.com
Whole thread Raw
In response to Re: No connection to a PG 8.0 Beta 1 win32 server  (Secrétariat <ets@rolland-fr.com>)
Responses Re: No connection to a PG 8.0 Beta 1 win32 server  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Secrétariat wrote:
> I already receive 8 times this message, not responding to my question !
> The question is :
> Why when I enable "tcpip_socket = true" in the postgresql.conf it becomes
> impossible to restart the service ?! (so hosts conections are impossible).

If PostgreSQL won't start with tcpip_socket=true, but can otherwise then
that suggests it can't open the socket.

That might be because something else is using it, or it might be because
a firewall won't let you.

If something else is using the socket then by telnet-ing to port 5432 we
can see what is there.

If you get different results trying to connect from different places
then that would suggest a firewall is involved.

I'm assuming you have:
  1. Tried stopping and starting manually
  2. checked the logs and there is nothing there
  3. have run netstat and it doesn't show anything useful.

Given that you have done those, we need to start from outside and work in.

--
   Richard Huxton
   Archonet Ltd

pgsql-general by date:

Previous
From: Dave Cramer
Date:
Subject: Re: No connection to a PG 8.0 Beta 1 win32 server
Next
From: mike
Date:
Subject: Invalid input for integer on VIEW