Skip site navigation (1) Skip section navigation (2)

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

From: "Alan Deane" <alan(at)anitltd(dot)co(dot)uk>
To: "'Scott Mead'" <scott(dot)lists(at)enterprisedb(dot)com>
Cc: "'Chris'" <dmagick(at)gmail(dot)com>,<pgsql-general(at)postgresql(dot)org>
Subject: Re: V8.3 fails to start after unremming hba_file = 'ConfigDir/pg_hba.conf'
Date: 2009-07-30 02:01:50
Message-ID: C71B013D095444B9A6D354100A87AB18@tinhare (view raw or flat)
Thread:
Lists: pgsql-general
Hi Scott, 

 

Yep, already have that set.

 

Thanks anyway.

Alan

 

  _____  

From: pgsql-general-owner(at)postgresql(dot)org
[mailto:pgsql-general-owner(at)postgresql(dot)org] On Behalf Of Scott Mead
Sent: 30 July 2009 02:45
To: alan(at)anitltd(dot)co(dot)uk
Cc: Chris; pgsql-general(at)postgresql(dot)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(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

 



In response to

pgsql-general by date

Next:From: Alan DeaneDate: 2009-07-30 02:14:46
Subject: Re: V8.3 fails to start after unremming hba_file = 'ConfigDir/pg_hba.conf'
Previous:From: Alan DeaneDate: 2009-07-30 02:00:11
Subject: Re: V8.3 fails to start after unremming hba_file = 'ConfigDir/pg_hba.conf'

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group