16 October 2010

postgresql on OpenSuse default login error (solved)

On terminal test : psql -h 127.0.0.1 -p 5432 postgres postgres

If you receive error:
psql: FATAL: Ident authentication failed for user "postgres"

Edit /var/lib/pgsql/data/pg_hba.conf, and write

trust

instead of "ident"

then reload PostgreSQL

As root: service postgresql reload
or as postgres user: pg_ctl reload

Ownership of pg_hba.conf has nothing to do with the authentication.

No comments: