Search code examples
postgresqlpgadmin

Why can't pgAdmin III connect to Postgres?

I added a new user to posgresql (amanda) which is the same as my linux system user. At the console, I can open psql just fine -- I don't need a password because I'm already authenticated as amanda. When I try to set up pgAdmin III without a password, I get: 

An error has occurred:

01:18:47 PM: Error: Error connecting to the server: fe_sendauth: no password supplied

And if I provide my system password, I get a password error: 

An error has occurred:

01:15:30 PM: Error: Error connecting to the server: FATAL:  password authentication failed for user "amanda"
FATAL:  password authentication failed for user "amanda"

How do I get pgAdmin3 talking to postgres as amanda?

Solution

  • not a real solution but rather a workaround: connect as command line and update your password hence:

    ALTER USER amanda WITH PASSWORD 'your_new_password';