Re: Changing the admin/postgres user password

2022-09-05 Thread David G. Johnston
On Mon, Sep 5, 2022 at 7:40 PM Jeffrey Walton wrote: > > Or maybe better, what part of the manual discusses auth failures so I > can read about them? > The chapter named "Client Authentication ". https://www.postgresql.org/docs/current/client-authentication.html It even has a subchapter named

Re: Changing the admin/postgres user password

2022-09-05 Thread Christophe Pettus
> On Sep 5, 2022, at 19:40, Jeffrey Walton wrote: > And finally, try the new password: > >PGPASSWORD=hi...HS psql -U postgres >psql: error: connection to server on socket > "/var/run/postgresql/.s.PGSQL.5432" failed: >FATAL: Peer authentication failed for user "postgres" If it's