Postgres Pro
Downloads
Home   >   mailing lists

Thread: pg_hba.conf Help

pg_hba.conf Help

From
"Brian C. Doyle"
Date:
Hello all,

How do i set up the pg_hba.conf to allow another domain to access a 
database.  This other domain is not hosted locally either?


Brian C. Doyle
Coach Team Force
Earthlink Mindspring Technical Support
support@mindspring.com

Re: pg_hba.conf Help

From
"Nikolay Mijaylov"
Date:
Here is my pg_hba

local        all                                         trust
host         all         127.0.0.1      255.255.255.255  trust
host         all         172.16.134.0   255.255.255.0    password
pg_passwd
host         all         123.123.123.0   255.255.255.0    password
pg_passwd
host         all         0.0.0.0        0.0.0.0          reject

This allow local (trusted) connections, and connections from 172.16.134.*
and 123.123.123.* networks (with passwords).
all othe is rejected

Local trusted connection is not good idea if you have many local users...   niki

----- Original Message -----
From: Brian C. Doyle <doyleb@corp.earthlink.net>
To: <pgsql-sql@postgresql.org>
Sent: Tuesday, May 23, 2000 6:51 PM
Subject: [SQL] pg_hba.conf Help


> Hello all,
>
> How do i set up the pg_hba.conf to allow another domain to access a
> database.  This other domain is not hosted locally either?
>
>
> Brian C. Doyle
> Coach Team Force
> Earthlink Mindspring Technical Support
> support@mindspring.com

Re: pg_hba.conf Help

From
"Poul L. Christiansen"
Date:
Open your /var/lib/pgsql/pg_hba.conf (or where ever it is)

Add this line to the bottom of the file:
host    all    IP    netmask    trust

example:
host    all    194.182.235.2    255.255.255.255 trust

This allows only access from the specified IP.

"Brian C. Doyle" wrote:

> Hello all,
>
> How do i set up the pg_hba.conf to allow another domain to access a
> database.  This other domain is not hosted locally either?
>
> Brian C. Doyle
> Coach Team Force
> Earthlink Mindspring Technical Support
> support@mindspring.com

Re: pg_hba.conf Help

From
"Brian C. Doyle"
Date:
Thanks to You all.

I found that for the netmask I had too many 5's.....

At 11:51 AM 5/23/00 -0400, Brian C. Doyle wrote:
>Hello all,
>
>How do i set up the pg_hba.conf to allow another domain to access a 
>database.  This other domain is not hosted locally either?
>
>
>Brian C. Doyle
>Coach Team Force
>Earthlink Mindspring Technical Support
>support@mindspring.com