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

Obe, Regina DND\MIS robe.dnd at cityofboston.gov
Thu Apr 7 13:50:13 PDT 2005

You can check which pg_hba file your pg server is using at runtime by
running the following statement

select * from pg_settings where name= 'hba_file'

-----Original Message-----
From: Robert Aldridge [mailto:bamarob55 at yahoo.com] 
Sent: Thursday, April 07, 2005 3:43 PM
To: postgis-users at postgis.refractions.net
Subject: Re: [postgis-users] [OT] Allowing network client connections

Thanks for the replies.  But, my problem must be
deeper.  Changing the pg_hba.conf file doesn't seem to
make any difference.  Even if I have either

'host all trust'


'host all trust'

I still get:

'no pg_hba.conf entry for host "", user "postgres", database

when trying to connect from a network client.  It's as
if the pg_hba.conf file that I'm editing isn't even
the one it's using.

I thought it may be my firewall/proxy, but the request
seems to be reaching the postgres server because the
logfile on the postgres server shows:

'FATAL: no pg_hba.conf entry for host "",
user "postgres", database "mydatabase"'

Thanks for your suggestions.  Any others?


Date: Thu, 7 Apr 2005 16:51:03 +0200
From: "TECHER Jean David" <davidtecher at yahoo.fr>
Subject: Re: [postgis-users] [OT] Allowing network
client connections
To: "PostGIS Users Discussion" <postgis-users at postgis.refractions.net>
Message-ID: <004601c53b81$38afc330$117fa8c0 at jenna>
Content-Type: text/plain;	charset="iso-8859-1"

Hi Robert


host all trust


host all trust

U did a error in SubNet: and not

Date: Thu, 7 Apr 2005 11:20:44 -0400 
From: "Obe, Regina     DND\\MIS"
<robe.dnd at cityofboston.gov>
Subject: RE: [postgis-users] [OT] Allowing network
client connections
To: 'PostGIS Users Discussion' <postgis-users at postgis.refractions.net>
<B318FD8D29DCD411BD0500D0B7A91C6704103DDB at jupiter>
Content-Type: text/plain


host all  trust

Looks right.  

host mydatabase

I would get rid of as it doesn't even designate the
method of trust.  
not sure what happens in that case or put trust at the
end of it.

What does your "Reject all other connections look
like?" Not sure why 
would need such a line unless you are rejecting a
subset of your 

Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
postgis-users mailing list postgis-users at postgis.refractions.net

More information about the postgis-users mailing list