Re: ident changes between 8.3 and 8.4

On Thu, Nov 5, 2009 at 14:49, Rafael Martinez <r(dot)m(dot)guerrero(at)usit(dot)uio(dot)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.

--
Magnus Hagander
Me: http://www.hagander.net/
Work: http://www.redpill-linpro.com/