Postgres password authentication issue
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?
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
in your pg_hba.conf, modify
local all postgres md5
local all postgres trust
then you'll be able to login without password