Magnus Hagander wrote:
> On Thu, Nov 5, 2009 at 14:49, Rafael Martinez <r.m.guerrero@usit.uio.no> wrote:
>
>> 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.
>>
>
> To make 8.4 behave like the previous "ident sameuser" way, just put
> "ident". No map is needed.
>
And it is documented in the release notes:
<http://www.postgresql.org/docs/current/static/release-8-4.html>, which
the OP should have read when upgrading.
cheers
andrew