Postgres Pro
Downloads
Home   >   mailing lists

Thread: pg_hba.conf

pg_hba.conf

From
"ShaneMRyan"
Date:
I am trying to use this tool called Zeos Database explorer.  Everytime I try to connect to my postgresql RedHat 6.2 box, it tells me that there is no entry in my pg_hba.conf file so that the program has permissions to talk with the database.  There are some samples in that file, but they aren't working for me.  Would someone that has this working email me a sample entry that would allow everyone from any IP address to connect to the database?  Thanks!
 
 
 
 
 

Re: pg_hba.conf

From
"Adam Lang"
Date:
I mean:

#host         all        0.0.0.0       0.0.0.0             trust

It was an example in the pg_hba.conf file.

Adam Lang
Systems Engineer
Rutgers Casualty Insurance Company
----- Original Message -----
From: "ShaneMRyan" <ShaneMRyan@hotmail.com>
To: <pgsql-general@hub.org>
Sent: Wednesday, September 27, 2000 9:45 AM
Subject: [GENERAL] pg_hba.conf


I am trying to use this tool called Zeos Database explorer.  Everytime I try
to connect to my postgresql RedHat 6.2 box, it tells me that there is no
entry in my pg_hba.conf file so that the program has permissions to talk
with the database.  There are some samples in that file, but they aren't
working for me.  Would someone that has this working email me a sample entry
that would allow everyone from any IP address to connect to the database?
Thanks!





Shane M Ryan
ShaneMRyan@hotmail.com
www.JaguarFutureSolutions.Com

Re: pg_hba.conf

From
"ShaneMRyan"
Date:
host         all         0.0.0.0       0.0.0.0                   trust
host         all         64.0.0.0      255.0.0.0                 trust
local        all
trust
host         all
trust
host         all         127.0.0.1     255.255.255.255    trust


This is what mine looks like.







----- Original Message -----
From: "Adam Lang" <aalang@rutgersinsurance.com>
To: "ShaneMRyan" <ShaneMRyan@hotmail.com>
Cc: "PGSQL General" <pgsql-general@postgresql.org>
Sent: Wednesday, September 27, 2000 10:17 AM
Subject: Re: [GENERAL] pg_hba.conf


> I mean:
>
> #host         all        0.0.0.0       0.0.0.0             trust
>
> It was an example in the pg_hba.conf file.
>
> Adam Lang
> Systems Engineer
> Rutgers Casualty Insurance Company
> ----- Original Message -----
> From: "ShaneMRyan" <ShaneMRyan@hotmail.com>
> To: <pgsql-general@hub.org>
> Sent: Wednesday, September 27, 2000 9:45 AM
> Subject: [GENERAL] pg_hba.conf
>
>
> I am trying to use this tool called Zeos Database explorer.  Everytime I
try
> to connect to my postgresql RedHat 6.2 box, it tells me that there is no
> entry in my pg_hba.conf file so that the program has permissions to talk
> with the database.  There are some samples in that file, but they aren't
> working for me.  Would someone that has this working email me a sample
entry
> that would allow everyone from any IP address to connect to the database?
> Thanks!
>
>
>
>
>
> Shane M Ryan
> ShaneMRyan@hotmail.com
> www.JaguarFutureSolutions.Com
>
>
>
>

Re: pg_hba.conf

From
Richard Poole
Date:
On Wed, Sep 27, 2000 at 08:45:04AM -0500, ShaneMRyan wrote:
> I am trying to use this tool called Zeos Database explorer.  Everytime I
> try to connect to my postgresql RedHat 6.2 box, it tells me that there is
> no entry in my pg_hba.conf file so that the program has permissions to
> talk with the database.  There are some samples in that file, but they
> aren't working for me.  Would someone that has this working email me a
> sample entry that would allow everyone from any IP address to connect to
> the database?  Thanks!

You want something like:

host        all        0.0.0.0            0.0.0.0            trust

although this of course insecure because it allows literally anyone
from anywhere. If you know you'll be coming from somewhere on your
own network you're safer with something like:

host        all        192.168.1.0        255.255.255.0    trust

where 192.168.1/24 is your network. Be aware that the first matching
line in pg_hba.conf will be used, so if you have a "reject" line
above your "trust" line you may get rejected and not be able to see
why. There's a useful section about all of this in Chapter 8 of the
Administrator's Guide:

http://www.postgresql.org/users-lounge/docs/7.0/admin/security.htm

or if you're using 6.5.3:

http://www.postgresql.org/users-lounge/docs/6.5/admin/security.htm
and "man 5 pg_hba.conf".

Richard

Re: pg_hba.conf

From
Travis Bauer
Date:
It should take two lines:

local     all                                 trust
host      all  0.0.0.0    0.0.0.0             trust

This will allow anyone anywhere on the network (including the internet,
when you are connected to it) to connect to and add/tamper with data in
your database.

----------------------------------------------------------------
Travis Bauer | CS Grad Student | IU |www.cs.indiana.edu/~trbauer
----------------------------------------------------------------

On Wed, 27 Sep 2000, ShaneMRyan wrote:

> I am trying to use this tool called Zeos Database explorer.  Everytime I try to connect to my postgresql RedHat 6.2
box,it tells me that there is no entry in my pg_hba.conf file so that the program has permissions to talk with the
database. There are some samples in that file, but they aren't working for me.  Would someone that has this working
emailme a sample entry that would allow everyone from any IP address to connect to the database?  Thanks! 
>
>
>
>
>
> Shane M Ryan
> ShaneMRyan@hotmail.com
> www.JaguarFutureSolutions.Com
>
>