Skip site navigation (1) Skip section navigation (2)

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

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 (view raw or flat)
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


In response to

pgsql-general by date

Next:From: mikeDate: 2004-08-24 14:42:53
Subject: Invalid input for integer on VIEW
Previous:From: Richard HuxtonDate: 2004-08-24 14:37:56
Subject: Re: No connection to a PG 8.0 Beta 1 win32 server

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group