From: pgsql-general-owner@postgresql.org [mailto:pgsql-general-owner@postgresql.org] On Behalf Of Scott Mead Sent: 30 July 2009 02:45 To: alan@anitltd.co.uk Cc: Chris; pgsql-general@postgresql.org Subject: Re: [GENERAL] V8.3 fails to start after unremming hba_file = 'ConfigDir/pg_hba.conf'
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.
That should do the trick.
--Scott
As you say, the config looks OK. Very frustrating.
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 numericlinkwarning 127.0.0.1/32 md5 > host all all numericlinkwarning 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?
