Menu
Starting pgAdmin III on kubuntu with stored password asks for password every time connecting to database giving error "Error connecting to the server: fe_sendauth: no password supplied". It ignores checkbox in store password field.
650
pgAdmin can store encrypted PostgreSQL server passwords in a local SQLite database if the user chooses to do so. The master password serves as the encryption key for the stored passwords. Previously, pgAdmin used to encrypt/decrypt all saved passwords using a key which is stored in the same SQLite database.
By Default, the user is 'postgres' and the password is the one which you enter while installing the database. (Version 11,12 I have tested). and enter the password used while installing. Or create a user with login permissions using PgAdmin tool.
PostgreSQL database passwords are separate from operating system user passwords. The password for each database user is stored in the pg_authid system catalog. Passwords can be managed with the SQL commands CREATE ROLE and ALTER ROLE, e.g., CREATE ROLE foo WITH LOGIN PASSWORD 'secret' , or the psql command \password .
I found reason for this in Postgresql mailing lists. Problem is when file /home/user/.pgpass has permisions more than u=rw 0600 pgAdmin ignores the file. Changing permisions for file resolves problem.
156
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
