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