From: | Seum-Lim Gan <slgan(at)lucent(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | pg_hba.conf change in 7.4 |
Date: | 2003-11-20 16:07:03 |
Message-ID: | p05100300bbe295614d7e@[135.185.171.70] |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi,
In 7.4, I noticed there is this ::1 and ffff: (x8 of them)
for IPv6.
I looked at the documentation and there is nothing that says
what the ::1 is for.
Commenting out that line will prevent access to PostgreSQL
from psql unless I put trust for that line.
This is what I had in 7.3.4:
host all all 127.0.0.1 255.255.255.255
ident pspmap
local all all password
host all all 0.0.0.0 0.0.0.0 reject
But in 7.4, it does not work anymore. It seems to want ::1 to be somewhere.
If I change the line with ::1 from trust to ident pspmap, it complains that
the user cannot be found. But it is in the pspmap. Message fromm psql:
psql: FATAL: IDENT authentication failed for user "postgres"
Right now, I have it set to trust to work around.
Any idea what to do about this ?
host all all 127.0.0.1 255.255.255.255
ident pspmap
local all all password
host all all 0.0.0.0 0.0.0.0 reject
# IPv4-style local connections:
#host all all 127.0.0.1 255.255.255.255 trust
# IPv6-style local connections:
host all all ::1
ffff:ffff:ffff:ffff:ffff:ffff:ffff:ffff trust
Thanks.
Gan
--
+--------------------------------------------------------+
| Seum-Lim GAN email : slgan(at)lucent(dot)com |
| Lucent Technologies |
| 2000 N. Naperville Road, 6B-403F tel : (630)-713-6665 |
| Naperville, IL 60566, USA. fax : (630)-713-7272 |
| web : http://inuweb.ih.lucent.com/~slgan |
+--------------------------------------------------------+
From | Date | Subject | |
---|---|---|---|
Next Message | Durai | 2003-11-20 16:11:23 | Re: error durring compilation |
Previous Message | Durai | 2003-11-20 16:03:48 | Multiuser testing -- PostgreSQL 7.3.4 |