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

Popular posts from this blog

php - regexp cyrillic filename not matches -

c# - OpenXML hanging while writing elements -

sql - Select Query has unexpected multiple records (MS Access) -