Re: Changing the admin/postgres user password

Поиск
Список
Период
Сортировка
От Christophe Pettus
Тема Re: Changing the admin/postgres user password
Дата
Msg-id F366FB8C-1DA3-4D81-835C-1EE2F8AC87E1@thebuild.com
обсуждение исходный текст
Ответ на Changing the admin/postgres user password  (Jeffrey Walton <noloader@gmail.com>)
Список 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. 


В списке pgsql-general по дате отправления:

Предыдущее
От: Jeffrey Walton
Дата:
Сообщение: Changing the admin/postgres user password
Следующее
От: "David G. Johnston"
Дата:
Сообщение: Re: Changing the admin/postgres user password