[SQL] IDENT authentication problem

2002-08-27 Thread Wei Weng
This is what I did: 1: I reinstalled postgresql RPMs from scratch (I removed all the logs, data files, backup files) 2: su root 3: su postgres 4: psql template1 And here I got the error message: psql: FATAL 1: IDENT authentication failed for user "foobar" User "foobar" was an old user I cr

Re: [SQL] IDENT authentication problem

2002-08-27 Thread Tom Lane
Wei Weng <[EMAIL PROTECTED]> writes: > What could have gone wrong? I must have left the trace of user foobar > somewhere in my system but I couldn't find it. PGUSER environment variable? regards, tom lane ---(end of broadcast)-