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 : [EMAIL PROTECTED] | | 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 | +--------------------------------------------------------+
---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])