pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Re: pg_hba.conf Help
4+ messages / 4 participants
[nested] [flat]

* Re: pg_hba.conf Help
@ 2000-05-23 15:34  Poul L. Christiansen <plc@faroenet.fo>
  parent: Brian C. Doyle <doyleb@corp.earthlink.net>
  1 sibling, 0 replies; 4+ messages in thread

From: Poul L. Christiansen @ 2000-05-23 15:34 UTC (permalink / raw)
  To: Brian C. Doyle <doyleb@corp.earthlink.net>; +Cc: pgsql-sql

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




^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* pg_hba.conf Help
@ 2000-05-23 15:51  Brian C. Doyle <doyleb@corp.earthlink.net>
  0 siblings, 2 replies; 4+ messages in thread

From: Brian C. Doyle @ 2000-05-23 15:51 UTC (permalink / raw)
  To: pgsql-sql

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




^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: pg_hba.conf Help
@ 2000-05-23 16:26  Nikolay Mijaylov <nmmm@nmmm.nu>
  parent: Brian C. Doyle <doyleb@corp.earthlink.net>
  1 sibling, 0 replies; 4+ messages in thread

From: Nikolay Mijaylov @ 2000-05-23 16:26 UTC (permalink / raw)
  To: pgsql-sql; Brian C. Doyle <doyleb@corp.earthlink.net>

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




^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: pg_hba.conf Help
@ 2000-05-23 16:48  Brian C. Doyle <bcdoyle@mindspring.com>
  0 siblings, 0 replies; 4+ messages in thread

From: Brian C. Doyle @ 2000-05-23 16:48 UTC (permalink / raw)
  To: pgsql-sql

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




^ permalink  raw  reply  [nested|flat] 4+ messages in thread


end of thread, other threads:[~2000-05-23 16:48 UTC | newest]

Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2000-05-23 15:51 pg_hba.conf Help Brian C. Doyle <doyleb@corp.earthlink.net>
2000-05-23 15:34 ` Poul L. Christiansen <plc@faroenet.fo>
2000-05-23 16:26 ` Nikolay Mijaylov <nmmm@nmmm.nu>
2000-05-23 16:48 Re: pg_hba.conf Help Brian C. Doyle <bcdoyle@mindspring.com>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox