From: | Rafael Martinez <r(dot)m(dot)guerrero(at)usit(dot)uio(dot)no> |
---|---|
To: | PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
Subject: | ident changes between 8.3 and 8.4 |
Date: | 2009-11-05 13:49:30 |
Message-ID: | 4AF2D7EA.3010206@usit.uio.no |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Hello
We have been using for years and without problems local ident
autentification in the database for our user postgres.
These are the values that we have been using until version 8.3:
pg_hba.conf:
- ------------
local all postgres ident sameuser
pg_ident.conf:
- --------------
sameuser postgres postgres
With 8.4, we get this error if we use a map named 'sameuser'.
- -----------------------------------------------------------
FATAL: Ident authentication failed for user "postgres"
LOG: no match in usermap for user "postgres" authenticated as "postgres"
CONTEXT: usermap "sameuser"
- -----------------------------------------------------------
These are the values used with 8.4:
pg_hba.conf:
- ------------
local all postgres ident map=sameuser
pg_ident.conf:
- --------------
sameuser postgres postgres
After some investigation, we have found out that everything works
without problems if we change the mapname used by ident to something
different than 'sameuser'.
Is this a bug or have we decided this behavior? I can not find any
documentation explaining that 'sameuser' is not a valid mapname.
regards,
- --
Rafael Martinez, <r(dot)m(dot)guerrero(at)usit(dot)uio(dot)no>
Center for Information Technology Services
University of Oslo, Norway
PGP Public Key: http://folk.uio.no/rafael/
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.7 (GNU/Linux)
iD8DBQFK8tesBhuKQurGihQRAlYJAKCj079582JocEUoIZfCLbqmsFeo0gCeMdYs
AifiS+Giu8M0r8SJLUYoEyM=
=e+Vz
-----END PGP SIGNATURE-----
From | Date | Subject | |
---|---|---|---|
Next Message | Peter Eisentraut | 2009-11-05 14:01:46 | Re: operator exclusion constraints |
Previous Message | Itagaki Takahiro | 2009-11-05 11:43:36 | Re: Syntax for partitioning |