Dan Joo wrote:
> Hi everyone,
> 
>  
> 
> 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"*

Sure there isn't a line like this:

local   all         postgres                          ident sameuser

uncommented?

$ cat /path/to/pg_hba.conf | grep -v '^#'

Normally the 'postgres' user is 'ident' only unless you remove (or
comment out) that particular line, then restart postgres.

-- 
Postgresql & php tutorials
http://www.designmagick.com/

-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Reply via email to