Dan, Always cc the mailing list so others can provide other suggestions where necessary. Dan Joo wrote: > Thanks, Chris, but yes, I am sure that there is no such line. (see below) > > [root@RH-Dev data]# cat pg_hba.conf | grep -v '^#' > > > > > > local all all trust > host all all 127.0.0.1/32 trust > host all all ::1/128 trust > > Dan Did you HUP postmaster? The docs say you can just pg_ctl reload to do this. > -----Original Message----- > From: Chris [mailto:dmagick@xxxxxxxxx] > Sent: Monday, May 19, 2008 6:22 PM > To: Dan Joo > Cc: pgsql-general@xxxxxxxxxxxxxx > Subject: Re: [GENERAL] psql: FATAL: Ident authentication failed for user "postgres" > > 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/
