Search code examples
postgresqlpsqlpgadmin

psql connects, but pgadmin3 fails

I'm connecting to a remote database using psql which works fine.

psql "host=dbhost user=dbuser pass=dbpass"

But supplying the same settings to pgadmin3 fails with "access to database denied" with a "no pg_hba.conf entry for host" message. How is psql working when pgadmin3 fails?

I do not have a .psqlrc file.

Solution

  • The reason for this turned out to be that psql and pgadmin have different default databases. Changing the default in pgadmin fixed the issue. Thanks to Laurenz Albe for helping answer this.