Re: Changing the admin/postgres user password - Mailing list pgsql-general

> On Sep 5, 2022, at 19:40, Jeffrey Walton <noloader@gmail.com> 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
wantother Linux users to be able to log in as the "postgres" PostgreSQL user, you'll need to edit your pg_hba.conf file
toallow it; it's off by default.