Cannot login to Postgrest database despite setting password for user 'postgres'

Posted by Serg on Server Fault See other posts from Server Fault or by Serg
Published on 2012-11-28T02:07:14Z Indexed on 2012/11/28 5:06 UTC
Read the original article Hit count: 589

Filed under:
|

I'm trying to use pgAdmin III to manage my Postgres database.

Here are the commands I've run on my machine:

sudo apt-get install postgresql

Then I installed the pgAdmin III application:

sudo apt-get install pgadmin3

Next I focused on setting my username and password in order to login:

sudo -u postgres psql postgres

Here I set my password
\password postgres

Finally I just created my database:

sudo -u postgres createdb repairsdatabase

When I try to login using pgAdmin III, I get the error:

An error has occurred:

Error connecting to the server: FATAL: Peer authentication failed for user "postgres"

enter image description here

© Server Fault or respective owner

Related posts about postgresql

Related posts about pgadmin