pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedRe: 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