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: 585
postgresql
|pgadmin
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"
© Server Fault or respective owner