Re: V8.3 fails to start after unremming hba_file = 'ConfigDir/pg_hba.conf' - Mailing list pgsql-general

From Alan Deane
Subject Re: V8.3 fails to start after unremming hba_file = 'ConfigDir/pg_hba.conf'
Date
Msg-id C71B013D095444B9A6D354100A87AB18@tinhare
Whole thread Raw
In response to Re: V8.3 fails to start after unremming hba_file = 'ConfigDir/pg_hba.conf'  (Scott Mead <scott.lists@enterprisedb.com>)
List pgsql-general

Hi Scott,

 

Yep, already have that set.

 

Thanks anyway.

Alan

 


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'

 

 

On Wed, Jul 29, 2009 at 9:14 PM, Alan Deane <alan@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.

That should do the trick.

--Scott



As you say, the config looks OK. Very frustrating.

Cheers,
Alan.


-----Original Message-----
From: pgsql-general-owner@postgresql.org
[mailto:pgsql-general-owner@postgresql.org] On Behalf Of Chris
Sent: 30 July 2009 01:23
To: alan@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         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?

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

 

pgsql-general by date:

Previous
From: "Alan Deane"
Date:
Subject: Re: V8.3 fails to start after unremming hba_file = 'ConfigDir/pg_hba.conf'
Next
From: "Alan Deane"
Date:
Subject: Re: V8.3 fails to start after unremming hba_file = 'ConfigDir/pg_hba.conf'