Wednesday, October 3, 2007

psql: FATAL: IDENT authentication failed

Tanya:

$ psql -U gue template1
psql: FATAL: IDENT authentication failed for user "gue"


Jawab:

Just modify pg_hba.conf like this (change to trust).

Eh lha pg_hba.conf ada di /var/lib/pgsql/data/

terus di ubah macem ni.....

local all trust
host all 127.0.0.1 255.255.255.255 trust


terus postgresnya di restart...

No comments:

Post a Comment