Changing the admin/postgres user password

Поиск
Список
Период
Сортировка
От Jeffrey Walton
Тема Changing the admin/postgres user password
Дата
Msg-id CAH8yC8mXpDRAwn4b4k1wkCqU7WEJJDWv0=DvCVXgM4-nckzBDA@mail.gmail.com
обсуждение исходный текст
Ответы Re: Changing the admin/postgres user password
Re: Changing the admin/postgres user password
Список pgsql-general
Hi Everyone,

I'm struggling to set the admin/postgres user password and use it on
Fedora 36. This is a fresh install on a new VM. The admin's name is
postgres. We created the user, and used the passwd utility to set the
Linux password 'hi...HS'. The ellipses are over 28 characters, so it
is a 32-character password.

Next, move onto Postgres auth. I followed
https://www.postgresql.org/docs/current/install-short.html . We used
'su - postgres' and logged on with Linux password. I changed the
postgres password with 'alter user postgres with password hi...HS'.
The change appeared to be successful.

Next, restart the service:

    sudo systemctl restart postgresql.service

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"

It appears the password is not working. I screwed something up somewhere. Ugh...

Does anyone know what I did wrong in this process?

Or maybe better, what part of the manual discusses auth failures so I
can read about them?

Thanks in advance.

Jeff



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

Предыдущее
От: Maxim Boguk
Дата:
Сообщение: Re: Missing query plan for auto_explain.
Следующее
От: Christophe Pettus
Дата:
Сообщение: Re: Changing the admin/postgres user password