Re: V8.3 fails to start after unremming hba_file = 'ConfigDir/pg_hba.conf'

On Wed, Jul 29, 2009 at 9:14 PM, Alan Deane <alan(at)anitltd(dot)co(dot)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.

That should do the trick.

--Scott

>
>
> As you say, the config looks OK. Very frustrating.
>
> Cheers,
> Alan.
>
> -----Original Message-----
> From: pgsql-general-owner(at)postgresql(dot)org
> [mailto:pgsql-general-owner(at)postgresql(dot)org] On Behalf Of Chris
> Sent: 30 July 2009 01:23
> To: alan(at)anitltd(dot)co(dot)uk
> Cc: pgsql-general(at)postgresql(dot)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(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>
>
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>