postgresql - Postgres password authentication issue -
i've installed postgresql 9.1 , pgadmin3 on ubuntu server 13.10.
i configured postgresql.conf with: listen_addresses = '*'
also configured ph_hba.conf changed peer connections md5
plus reset password of postgres by: sudo password postgres
then restarted service sudo /etc/init.d/postgresql restart
after tried connect default postgresql template database:
sudo -u postgres psql template1
but login failed error message:
psql: fatal: password authentication failed user "postgres"
then tried login pgadmin, gave me same error.
i've read here might password expiry dates bug postgresql user can not connect server after changing password
but couldn't solve coz cannot login psql. how resolve issue?
edit
ph_hba file:
local postgres md5 local md5 local trust host 127.0.0.1/32 md5 hostssl 192.168.0.0/16 trust host 192.168.0.0/16 trust host ::1/128 md5
in pg_hba.conf, modify
local postgres md5
to
local postgres trust
then you'll able login without password
Comments
Post a Comment