| From: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> |
|---|---|
| To: | Amn Ojee Uw <amnojeeuw(at)gmail(dot)com> |
| Cc: | "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: Peer authentication failed ??? |
| Date: | 2023-10-03 12:35:09 |
| Message-ID: | CAKFQuwYF4A0wffDFPN-L6yFc3JPH9+AbgVKDGcr376y0yXOi8g@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Tuesday, October 3, 2023, Amn Ojee Uw <amnojeeuw(at)gmail(dot)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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Sergey Cherukhin | 2023-10-03 12:40:12 | Re: Operating of synchronous master when no standby is available |
| Previous Message | MATSUO Takatoshi | 2023-10-03 10:22:24 | Re: Operating of synchronous master when no standby is available |