Re:
От | Adrian Klaver |
---|---|
Тема | Re: |
Дата | |
Msg-id | 4d50b590-e44e-1f28-34ab-526c52904e53@aklaver.com обсуждение исходный текст |
Ответ на | (Нурдаулет Лесбек <lokiodinson72@gmail.com>) |
Список | pgsql-www |
On 10/28/22 03:00, Нурдаулет Лесбек wrote: > Hi! > I'm forget the administrator's (root) password from PostgreSQL server. > How can I restore it? > Please, help me! 1) The appropriate list for this sort of question is pgsql-general: https://www.postgresql.org/list/pgsql-general/ 2) In addition to Christophe's suggestion: Check your pg_hba.conf file for a uncommented line like: local all postgres trust If it is there then you can on the server machine do: psql -d database -U postgres to make a local connection via socket without a password. If it is not there then add it and reload the server settings. > > Kind regards -- Adrian Klaver adrian.klaver@aklaver.com
В списке pgsql-www по дате отправления: