Thread

Re: pg_hba.conf Help

Poul L. Christiansen <plc@faroenet.fo> — 2000-05-23T15:34:03Z

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

pg_hba.conf Help

Brian C. Doyle <doyleb@corp.earthlink.net> — 2000-05-23T15:51:01Z

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

Nikolay Mijaylov <nmmm@nmmm.nu> — 2000-05-23T16:26:41Z

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