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: Subject: Map linux user to postgresql user From: Bhuvanesh R 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 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