CODEWITHSUNDEEP
postgresqlpgadmin
Michael Durrant
Michael Durrant

Reputation: 96454

Why can't pgadmin connect to the server but I can get in using the command line?

When I try to use pgadmin I keep getting authentication errors. I am using my own account and my login password.

The following does work:

$  sudo -u postgres createuser -s $USER
$ createdb md3
$ psql -d md3

psql (9.1.3)
Type "help" for help.

md3=#

However I then get this error in the pgadmin GUI:

enter image description here

Perhaps I should be using root or the postgres user?

Upvotes: 1

Views: 2282

Answers (1)

Thomas
Thomas

Reputation: 1066

login in pgadmin as postgres user and check if the user "durrantm" exist and if he can login (there should be a checkbox in the privilege tab)

Upvotes: 1

Related Questions