I am having problems logging into psql as a non-'postgres' user.
/home/djoo[5:38pm]$ %psql kermit -U postgres
psql: FATAL: Ident authentication failed for user "postgres"
Below is a portion of the pg_hba.conf file, which I believe is
configured so that a password is not required.
# TYPE DATABASE USER CIDR-ADDRESS METHOD
# "local" is for Unix domain socket connections only
local all all trust
# IPv4 local connections:
host all all 127.0.0.1/32 trust
# IPv6 local connections:
host all all ::1/128 trust
Any suggestions would be greatly appreciated!
pgsql-general by date
|Next:||From: Nathan Thatcher||Date: 2008-05-20 00:23:17|
|Subject: Create database without entering password at command line|
|Previous:||From: Sam Mason||Date: 2008-05-20 00:04:30|
|Subject: Re: Join three fields into one on same table|