[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'
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'
'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
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?
Date: Thu, 7 Apr 2005 16:51:03 +0200
From: "TECHER Jean David" <davidtecher at yahoo.fr>
Subject: Re: [postgis-users] [OT] Allowing network
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"
host all 192.168.0.0 255.255.255.0 trust
host all 192.168.0.0 255.255.0.0 trust
U did a error in SubNet: 255.255.255.0 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
To: 'PostGIS Users Discussion' <postgis-users at postgis.refractions.net>
<B318FD8D29DCD411BD0500D0B7A91C6704103DDB at jupiter>
host all 192.168.1.0/24 trust
host mydatabase 192.168.1.0/24
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