[SQL] IDENT authentication problem

[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 created for the database *before* I
wiped out everything and reinstalled the RPMs. It is already gone from
my /etc/password. (since I was using IDENT)

What could have gone wrong? I must have left the trace of user foobar
somewhere in my system but I couldn't find it.

Thanks


-- 
Wei Weng
Network Software Engineer
KenCast Inc.



---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Re: [SQL] IDENT authentication problem

[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)---
TIP 2: you can get off all lists at once with the unregister command
(send unregister YourEmailAddressHere to [EMAIL PROTECTED])