In /var/lib/pgsql/9.1/data/pg_hba.conf
, I have the following:
# TYPE DATABASE USER ADDRESS METHOD
host all all 127.0.0.1/32 trust
But when I execute
su -c "psql -d postgres" - postgres
it asks me for a password. My expectation is that users should not be prompted for a password.
-h
/--host
thenpsql
will (try to) connect through Unix-domain socket. Which is typelocal
in thepg_hba.conf
.