Postgres Pro
Downloads
Home   >   mailing lists

Thread: Recover postgresql password storein in pgadmin.db

Recover postgresql password storein in pgadmin.db

From
Marco Tosato
Date:
Hello!

My pgAdmin is correctly configure to connect to my server and is the tool of choise to manage the DB ....I'm so used to pgAdmin with stored password that I forgot the password of Postgresql.

Since the password is stored in the pgAdmin DB could someone tell me how to recover it from the SQLite DB? I found the ecrypted version of the password in the servers table.

Thanks a lot!

Re: Recover postgresql password storein in pgadmin.db

From
Murtuza Zabuawala
Date:
​You can reset the database password & update that new password in pgAdmin4 when you try to connect next time.
Ref: https://stackoverflow.com/questions/10845998/i-forgot-the-password-i-entered-during-postgres-installation


On Fri, Feb 16, 2018 at 4:04 PM, Marco Tosato <marco.jem@gmail.com> wrote:
Hello!

My pgAdmin is correctly configure to connect to my server and is the tool of choise to manage the DB ....I'm so used to pgAdmin with stored password that I forgot the password of Postgresql.

Since the password is stored in the pgAdmin DB could someone tell me how to recover it from the SQLite DB? I found the ecrypted version of the password in the servers table.

Thanks a lot!