Home / server / Questions / 390689
Accepted
Steve
Asked: 2012-05-20 09:57:17 +0800 CST

psql asks for password despite configuring trust authentication from localhost

  • 772

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.

postgresql centos6 psql

2 Answers

  1. Best Answer

    There were other settings in there for local and IPv6 connections which were not trust. I made them all trust and it works now. So it looks like psql doesn't connect via IPv4.

    • 1

  2. The address of the record with the trust field in the pg_hba.conf file needs to be ::1/128, presumably because the PostgreSQL server running on your local machine is using an address in that range.

    • 0