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 412B2182.9060503@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>)
List pgsql-general
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

pgsql-general by date:

Previous
From: Daniel Martini
Date:
Subject: Re: pg_dump in stand alone backend
Next
From: Secrétariat
Date:
Subject: Re: No connection to a PG 8.0 Beta 1 win32 server