Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.databases.postgresql > #761

Map linux user to postgresql user

Show all headers | View raw

I want to map Linux's root user to Postgres user, like if I enter psql in root user it should go the PostgreSQL cli without asking any authentication.


I tried to add an entry in pg_ident.conf and make the necessary changes in pg_hba.conf, but it didn't work.

psql: FATAL:  role "root" does not exist
Postgresql Version 9.6

pg_ident.conf
# MAPNAME       SYSTEM-USERNAME PG-USERNAME
root                 root            postgres

pg_hba.conf
# TYPE  DATABASE USER   ADDRESS         METHOD
local   all     all                     peer map=root 
host    all     all     127.0.0.1/32    ident map=root 
Any suggestions to achieve this?

I need to map multiple Linux users. The above one is for who all are using root user.


The same question posted in Stackoverflow.

https://dba.stackexchange.com/questions/172573/postgresql-map-a-linux-user-to-login

Back to comp.databases.postgresql | Previous | Next | Find similar

Thread

Map linux user to postgresql user Bhuvanesh R <bhuvanesh.rathinasamy@gmail.com> - 2017-05-04 07:21 -0700

csiph-web