[SQL] IDENT authentication problem

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

Re: [SQL] IDENT authentication problem

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