Re: Connecting with PostgreSQL 9.1 using the Ubuntu machine user and peer authentication method

On 08/07/2014 01:39 AM, Jorge Arevalo wrote:

>
> What OS are you on?
>
> Per:
> http://www.postgresql.org/__docs/9.1/interactive/auth-__methods.html#AUTH-PEER
> <http://www.postgresql.org/docs/9.1/interactive/auth-methods.html#AUTH-PEER>
>
> "Peer authentication is only available on operating systems
> providing the getpeereid() function, the SO_PEERCRED socket
> parameter, or similar mechanisms. Currently that includes Linux,
> most flavors of BSD including Mac OS X, and Solaris."
>
>
>
> Linux system (Ubuntu 12.04). Also tested in Mac OS 10.8.
>
> Forgot to mention: in pg_hba.conf there is a previous line:
>
> local postgres peer

That would be the issue, assuming you are doing something along lines of
psql -d some_db -U postgres per:

http://www.postgresql.org/docs/9.1/interactive/auth-pg-hba-conf.html

" The first record with a matching connection type, client address,
requested database, and user name is used to perform authentication.
There is no "fall-through" or "backup": if one record is chosen and the
authentication fails, subsequent records are not considered."

If you are not connecting as above, you will need to show us your
connection string.

>
> No map specified for that line.
>
>
>
> --
> Jorge Arevalo
>

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com