Groups > comp.databases.postgresql > #761

Map linux user to postgresql user

X-Received	by 10.129.129.71 with SMTP id r68mr19934236ywf.50.1493907691647; Thu, 04 May 2017 07:21:31 -0700 (PDT)
X-Received	by 10.157.13.170 with SMTP id 39mr883464ots.18.1493907691609; Thu, 04 May 2017 07:21:31 -0700 (PDT)
Path	csiph.com!weretis.net!feeder6.news.weretis.net!feeder.usenetexpress.com!feeder1.iad1.usenetexpress.com!216.166.98.84.MISMATCH!Gin.tags.giganews.com!border1.nntp.dca1.giganews.com!nntp.giganews.com!g27no112207qte.1!news-out.google.com!v18ni1902ita.0!nntp.google.com!c26no484438itd.0!postnews.google.com!glegroupsg2000goo.googlegroups.com!not-for-mail
Newsgroups	comp.databases.postgresql
Date	Thu, 4 May 2017 07:21:31 -0700 (PDT)
Complaints-To	groups-abuse@google.com
Injection-Info	glegroupsg2000goo.googlegroups.com; posting-host=117.203.72.49; posting-account=tLQIawoAAACO-aREnpncd7WTXgbW5XXf
NNTP-Posting-Host	117.203.72.49
User-Agent	G2/1.0
MIME-Version	1.0
Message-ID	<e33b3d4a-e384-4bdf-9e28-e90349cbadc8@googlegroups.com> (permalink)
Subject	Map linux user to postgresql user
From	Bhuvanesh R <bhuvanesh.rathinasamy@gmail.com>
Injection-Date	Thu, 04 May 2017 14:21:31 +0000
Content-Type	text/plain; charset=UTF-8
Lines	23
Xref	csiph.com comp.databases.postgresql:761

Show key headers only | 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