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?

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

Answers


in your pg_hba.conf, modify

local   all             postgres                                md5

to

local   all             postgres                                trust

then you'll be able to login without password


Need Your Help

How to connect with database in talend

database ms-access talend

I am facing a problem while connecting to my Access Database. I have selected the Database but when I checked the connection, an error message appear. The error message is

Fitting elements for Splash Page on mobile in BootStrap

html css twitter-bootstrap responsive-design

I'm trying to create a responsive splash page, but it's not responding, no matter how much I try to manipulate it. What I'm mostly trying to do is fit the image with no margin or padding. I want it