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

[Obe, Regina DND\MIS]

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 192.168.0.0 255.255.255.0 trust'

or

'host all 192.168.1.0/24 trust'

I still get:

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

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 "192.168.1.101",
user "postgres", database "mydatabase"'

Thanks for your suggestions.  Any others?

Robert


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

it's

host all 192.168.0.0 255.255.255.0 trust

not

host all 192.168.0.0 255.255.0.0 trust

U did a error in SubNet: 255.255.255.0 and not
255.255.0.0

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>
Message-ID:
<B318FD8D29DCD411BD0500D0B7A91C6704103DDB at jupiter>
Content-Type: text/plain

Your

host all 192.168.1.0/24  trust

Looks right.  

Your 
host mydatabase 192.168.1.0/24

I would get rid of as it doesn't even designate the
method of trust.  
I'm
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 
you
would need such a line unless you are rejecting a
subset of your 
subnet. 

__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 
_______________________________________________
postgis-users mailing list postgis-users at postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users