pg_hba.conf change in 7.4

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 |
+--------------------------------------------------------+

Responses

Browse pgsql-general by date

  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