Re: Changing the admin/postgres user password
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 "Authentication Problems" though it seems like discussion of (typical) default peer dynamics is missing. In particular, if you connect via local socket (also a default) the order of entries in (typical default) pg_hba.conf says you must login using peer, not password. David J.
Re: Changing the admin/postgres user password
> 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 complaining about peer authentication, you are most likely not logged in as the "postgres" Linux user. If you want other Linux users to be able to log in as the "postgres" PostgreSQL user, you'll need to edit your pg_hba.conf file to allow it; it's off by default.
