On Wed, Jul 29, 2009 at 9:14 PM, Alan Deane <a...@anitltd.co.uk> wrote:
> Sorry, yes the error, Doh!. > > Standard Server doesn't Listen (sounds like my ex :)) > > Here it is in full. > > Server doesn't listen > > could not connect to server; Connection timed out (0x0000274C/10060) Is the > server running on host 192.168.2.99 and accepting TCP/IP connection on port > 5432? In postgresql.conf, set: listen_addresses='*' Then restart the server. Then (in windows, right?) do a: netstat -a Look for port 5432. --Scott > > > As you say, the config looks OK. Very frustrating. > > Cheers, > Alan. > > -----Original Message----- > From: pgsql-general-ow...@postgresql.org > [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Chris > Sent: 30 July 2009 01:23 > To: a...@anitltd.co.uk > Cc: pgsql-general@postgresql.org > Subject: Re: [GENERAL] V8.3 fails to start after unremming hba_file = > 'ConfigDir/pg_hba.conf' > > Alan Deane wrote: > > Hi Chris, > > > > Thanks for your reply. > > > > Maybe I should have reworded it slightly better or fuller. I assumed that > > having ConfigDir/pg_hba.conf line in postgresql.conf would look for the > hba > > file in the directory relative to where postgres is installed. I.e. the > data > > directory and given that the service when it starts uses > > > > g:/Program Files/PostgreSQL/8.3/bin/pg_ctl.exe runservice -N > > "postgresql-8.3" -D "G:/Program Files/PostgreSQL/8.3/data" -w > > Must be based off where the service name is, I'm not sure. > > > and from what I've read the -D switch is basically telling postgres where > to > > find the conf files and setting the relative path for ConfigDir, so I was > > surprised that it looked for the hba conf in the system32 directory. > > Yeh, I would have thought it would pick up from the data dir not > somewhere else. > > > As for the networking side of things. I have opened port 5432 on my > firewall > > and I also disabled the firewall (Kaspersky btw not Windows it is > disabled > > permanently). > > > > My pg_hba.conf file reads. > > > > # IPv4 local connections: > > host all all 127.0.0.1/32 md5 > > host all all 192.168.2.0/16 trust > > > > I have only set it to trust for testing purposes as soon as I get a > connect > > it will be going back to md5. > > and the error when you try to connect is? > > Did you restart postgres after changing the pg_hba.conf file? > > Seems like it should work. > > -- > Postgresql & php tutorials > http://www.designmagick.com/ > > > -- > Sent via pgsql-general mailing list (pgsql-general@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general > > > > > -- > Sent via pgsql-general mailing list (pgsql-general@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general >
