Re: Peer authentication failed ??? - Mailing list pgsql-general

From David G. Johnston
Subject Re: Peer authentication failed ???
Date
Msg-id CAKFQuwYF4A0wffDFPN-L6yFc3JPH9+AbgVKDGcr376y0yXOi8g@mail.gmail.com
Whole thread Raw
In response to Peer authentication failed ???  (Amn Ojee Uw <amnojeeuw@gmail.com>)
List pgsql-general
On Tuesday, October 3, 2023, Amn Ojee Uw <amnojeeuw@gmail.com> wrote:

Using the 'sudo -u postgres psql' command

psql -U my_group_worker -d my_group_db

psql: error: connection to server on socket "/var/run/postgresql/.s.PGSQL.5432" failed: FATAL:  Peer authentication failed for user "my_group_worker"

*** What am I doing wrong?


postgres != my_group_worker and you haven’t setup an ident mapping to associate the two

David J.

pgsql-general by date:

Previous
From: MATSUO Takatoshi
Date:
Subject: Re: Operating of synchronous master when no standby is available
Next
From: Sergey Cherukhin
Date:
Subject: Re: Operating of synchronous master when no standby is available