On Sat, May 22, 2004 at 19:36:38 -0400, Tom Allison wrote: > I created a user in psql but now I can't log in as that user. > > I get an error > psql: FATAL: IDENT authentication failed for user "dbmail" > > This implies that I need to have all my users for pgsql listed in both > the /etc/passwd file and the postgres database.
No. It implies you haven't set PostgreSQL's client authentication settings to ones you like. > Or does postgres just us the /etc/passwd file for all of it's > authentications? PostgreSQL doesn't care about /etc/passwd. The default client authentication settings care about what user is connecting to the database server through a UNIX socket. The relevant documentation is the "Client Authentication" chapter of the PostgreSQL documentation: http://www.postgresql.org/docs/7.4/interactive/client-authentication.html HTH, Ray -- The "free" in "free software" refers to freedom, not price; specifically, that all computer users should have the freedom to study, change, and redistribute the software that they use. RMS in http://weblog.mercurycenter.com/ejournal/stories/storyReader$664 -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]