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
$> sudo -u postgres psql =# \password Enter new password: postgres Enter it again: postgres =# \q $>
I have also updated the
listen_addresses='localhost' and restarted postgresql.
When I run
psql -U postgres -h localhost I am still prompted for a password.
What else should I try in order to prevent being prompted for a password while executing
psql commands locally?