| From: | Christophe Pettus <xof(at)thebuild(dot)com> |
|---|---|
| To: | noloader(at)gmail(dot)com |
| Cc: | pgsql-general(at)lists(dot)postgresql(dot)org |
| Subject: | Re: Changing the admin/postgres user password |
| Date: | 2022-09-06 02:46:49 |
| Message-ID: | F366FB8C-1DA3-4D81-835C-1EE2F8AC87E1@thebuild.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
> On Sep 5, 2022, at 19:40, Jeffrey Walton <noloader(at)gmail(dot)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 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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David G. Johnston | 2022-09-06 03:04:29 | Re: Changing the admin/postgres user password |
| Previous Message | Jeffrey Walton | 2022-09-06 02:40:02 | Changing the admin/postgres user password |