Re: No connection to a PG 8.0 Beta 1 win32 server

From: Secrétariat <ets(at)rolland-fr(dot)com>
To: "Richard Huxton" <dev(at)archonet(dot)com>
Cc: <pgsql-general(at)postgresql(dot)org>
Subject: Re: No connection to a PG 8.0 Beta 1 win32 server
Date: 2004-08-24 14:12:54
Message-ID: 007a01c489e4$73fdfaf0$0a00a8c0@lrp43008
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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).

Luc

Secrétariat wrote:
> Hello !
>
> I've corrected my win32 pg_hba.conf, it contains :
> host all all 127.0.0.1 255.255.255.255 md5
> host all all 192.168.0.0 255.255.255.0 md5
> but I can't connect from my W2k client at IP 192.168.0.11 !

Open a command-prompt on the client and try to telnet to your server,
port 5432.
Type "aa" and hit return - you should get an error message complaining
about a bad "startup packet".

Do the same from the server to the external IP address and then 127.0.0.1

If none of these work, then PG probably isn't listening. If 127.0.0.1
works but one or more of the others don't then check your firewall.

--
Richard Huxton
Archonet Ltd

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Josué Maldonado 2004-08-24 14:26:32 Re: pg_dump/psql fails on win32 beta 8.0
Previous Message Secrétariat 2004-08-24 14:06:22 Re: pg_dump/psql fails on win32 beta 8.0