Re: postgres ident error
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
Reply to: