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

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?

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/