From: | Dave Cramer <pg(at)fastcrypt(dot)com> |
---|---|
To: | Secrétariat <ets(at)rolland-fr(dot)com> |
Cc: | Richard Huxton <dev(at)archonet(dot)com>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: No connection to a PG 8.0 Beta 1 win32 server |
Date: | 2004-08-24 14:39:22 |
Message-ID: | 1093358362.1211.230.camel@localhost.localdomain |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Luc,
Your best bet is to look in the log files, to see why postgresql doesn't
start up. Now I have no clue where you would find them on windows, but..
that's where I would look.
Dave
On Tue, 2004-08-24 at 10:12, 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).
>
> 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.
--
Dave Cramer
519 939 0336
ICQ # 14675561
www.postgresintl.com
From | Date | Subject | |
---|---|---|---|
Next Message | mike | 2004-08-24 14:42:53 | Invalid input for integer on VIEW |
Previous Message | Richard Huxton | 2004-08-24 14:37:56 | Re: No connection to a PG 8.0 Beta 1 win32 server |