Re: "Optional ident" authentication - Mailing list pgsql-hackers

From Florian G. Pflug
Subject Re: "Optional ident" authentication
Date
Msg-id 456AE3B1.5010902@phlo.org
Whole thread Raw
In response to Re: "Optional ident" authentication  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: "Optional ident" authentication  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Tom Lane wrote:
>>> My personal itch is that I'd like to have an "ident sameuser"
>>> authentication that falls back on, say, PAM authentication when system
>>> user A wants to log into postgres under a different username B.
> 
> You can accomplish that with
> 
>     local    sameuser    all    ident sameuser
>     local    all        all    pam

You put "sameuser" in the database column instead of the "user" column -
was the intentional? I've just tried this with "sameuser" in the user 
column, and it didn't work for me. I've also searched the docs, and I
only found three references to "sameuser". One described "ident 
sameuser", while the other two were in the changelog, and told me that
"sameuser" support in the _database_ column was introduced in 6.4, and
that quoting removes the special meaning of sameuser since 8.0.

Should sameuser work instead of all in the user column?

greetings, Florian Pflug


pgsql-hackers by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: Configuring BLCKSZ and XLOGSEGSZ (in 8.3)
Next
From: "Florian G. Pflug"
Date:
Subject: Re: Shared pg_xlog directory/partition and warm standby