Postgres password authentication issue
in your pg_hba.conf, modify
local all postgres md5
to
local all postgres trust
then you'll be able to login without password
Shadin
Updated on June 04, 2022Comments
-
Shadin almost 2 years
I've installed PostgreSQL 9.1 and pgadmin3 on Ubuntu Server 13.10.
I configured postgresql.conf with:
listen_addresses = '*'
also I configured ph_hba.conf by changed peer connections to
md5
Plus I reset the password of postgres by:
sudo password postgres
then restarted the service with
sudo /etc/init.d/postgresql restart
after that I tried to connect to the default PostgreSQL template database:
sudo -u postgres psql template1
but login failed with this error message:
psql: FATAL: password authentication failed for user "postgres"
then I tried to login from the pgadmin, which gave me the same error.
I've read here that it might be a password expiry dates bug PostgreSQL user can not connect to server after changing password
but I couldn't solve it coz I cannot login with psql. Does anyone now how to resolve this issue?
EDIT
ph_hba file:
local all postgres md5 local all all md5 local all all trust host all all 127.0.0.1/32 md5 hostssl all all 192.168.0.0/16 trust host all all 192.168.0.0/16 trust host all all ::1/128 md5
-
Craig Ringer over 10 yearsIf you do this, I hope you trust everyone able to access the server the PostgreSQL instance is running on, because you just gave them total access to the PostgreSQL server. I strongly recommend at least using
peer
authentication.