I'm using PGAdmin 4 v6.4 on my mac. I have a master password set and a number of passwords saved for databases so I can log in without needing to type the individual passwords each time. How can I view these saved passwords? In previous versions, it seems they were simply stored in a plaintext file somewhere, but that no longer seems to be the case
pgAdmin4 stores all the saved server information in a SQLite3 file called pgadmin4.db
On Windows, we always store data in %APPDATA%\pgAdmin. On other platforms, if we're in server mode we use /var/lib/pgadmin, otherwise ~/.pgadmin
All saved server credentials can be found in the server table.
The passwords are encrypted using AES CFB8. You can decrypt them with your master password by referring to this file
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With