PostgreSQL: Make root log in as postgres user

The goal is allowing root (or another user) to login as a certain other user without the need of entering a password.

PostgreSQL 9.3

pg_hba.conf:

# TYPE  DATABASE USER   ADDRESS         METHOD
local   all     all                     peer map=root_as_others
host    all     all     127.0.0.1/32    ident map=root_as_others

pg_ident.conf:

# MAPNAME       SYSTEM-USERNAME PG-USERNAME
root_as_others  root            postgres
root_as_others  root            gis

PostgreSQL 8.3

In /etc/postgresql/8.3/main/pg_hba.conf:

# TYPE          DATABASE        USER            CIDR-ADDRESS            METHOD
local           all             postgres                                ident rootaspg
local           all             all                                     ident sameuser
host            all             all             127.0.0.1/32            md5
host            all             all             ::1/128                 md5

In /etc/postgresql/8.3/main/pg_ident.conf:

# MAPNAME     IDENT-USERNAME    PG-USERNAME
rootaspg                root                            postgres
rootaspg                root                            drupal
rootaspg                postgres                        postgres

comments powered by Disqus