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.klaver@aklaver.com