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

On 08/06/2014 03:43 PM, Jorge Arevalo wrote:

Hello,

I want to connect to my local installation of PostgreSQL 9.1 using my
machine user (who is vagrant). So, after reading PostgreSQL
documentation, I thought I just needed to:

1. Add username map in pg_ident.conf:

# MAPNAME       SYSTEM-USERNAME         PG-USERNAME

vp                       vagrant                                postgres


2. Using the map in pg_hba.conf

# TYPE  DATABASE        USER            ADDRESS                 METHOD

local       all                      all
                   peer map=vp

But I'm getting the error

sql: FATAL:  Peer authentication failed for user "vagrant"

If I try to connect to my server using psql.

I guess I'm misunderstanding the PostgreSQL manual. But, how could I get
what I need? (locally connect with the user vagrant like if it was the
postgres user)

What OS are you on?

Per:
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."

--
Jorge Arevalo

http://about.me/jorgeas80

--
Adrian Klaver
adrian.klaver@aklaver.com