Thread: help with - psql: FATAL: Password authentication failed for user "gforge"

help with - psql: FATAL: Password authentication failed for user "gforge"

From
Sukhdeep Johar
Date:
I followed these steps to create a new user :
1. createuser -P gforge
2. createdb -U gforge -E UNICODE gforge
3. createlang plpgsql gforge

this gave no errors.
But when I try to log in, I get the foll error
# psql -h localhost -U gforge gforge
psql: FATAL:  Password authentication failed for user "gforge"

Any comments, what may be going wrong ?
--
Neither success nor failure is ever final

Have you set up the file pg_hba.conf in the postgres data directory?
Maybe the new user is not allowed to connect because of an exclusion
there.
Boyd