I have freshly installed postgresql 9.4 on my ubuntu 14.10 box and I have run \password
as the postgres
user and given it the password postgres
:
$> sudo -u postgres psql
=# \password
Enter new password: postgres
Enter it again: postgres
=# \q
$>
I have also updated the /etc/postgresql/9.4/main/postgresql.conf
with listen_addresses='localhost'
and restarted postgresql.
ISSUE
When I run psql -U postgres -h localhost
I am still prompted for a password.
QUESTION
What else should I try in order to prevent being prompted for a password while executing psql
commands locally?