[postgis-users] [OT] Allowing network client connections

[Obe, Regina DND\MIS]

I think the default location where postmaster looks for the pg_hba.conf file
is in the same folder as your data cluster.

With that said, your pg_hba.conf should be put in your
/usr/local/pgsql/data

Which it doesn't appear you have it.  


-----Original Message-----
From: Robert Aldridge [mailto:bamarob55 at yahoo.com] 
Sent: Thursday, April 07, 2005 10:10 PM
To: robe.dnd at cityofboston.gov; postgis-users at postgis.refractions.net
Subject: RE: [postgis-users] [OT] Allowing network client connections


Thanks again for the replies.  I think Regina Obe is
getting to the bottom of my problem.  When I run:

select * from pg_settings where name= 'hba_file'

I get no records returned.

Now, I have 'pg_hba.conf' in /etc/postgresql/ and a
symbolic link to this file in /var/lib/postgres/data/
(this is my $PGDATA directory).   I'm starting the
postmaster with:

'/usr/local/pgsql/bin/postmaster -i -D
/usr/local/pgsql/data >logfile 2>&1 &'

So, why isn't it reading pg_hba.conf?

Thanks,

Robert Aldridge


		
__________________________________ 
Do you Yahoo!? 
Read only the mail you want - Yahoo! Mail SpamGuard. 
http://promotions.yahoo.com/new_mail