Lucky Leavell wrote:
v8.0.3
OS: SuSE 10.0 Pro
I am new to PostgreSQL but fairly familiar with other RDBMS' such as
Ingres, Informix and MySQL.
I am attempting to switch from using MySQL to PostgreSQL with postfix. I
have created the postfix user using createuser with a password but denying
the ability to create databases or other users. However when I attempt to
login even using psql:
psql -W -U postfix
it prompts me for the password and I enter the one that user was created
with. The resulting error is:
psql: FATAL: Ident authentication failed for user 'postfix'
I know I must be missing something simple but I cannot find it in the docs
or FAQs. Please point me in the right direction.
Thank you,
Lucky
By default, PostgreSQL won't let you connect unless your system user
account matches the user account in postgres... You can either 'su' to
the 'postfix' user or edit your 'pg_hba.conf' file to have the line:
local all all trust
Usually there will already be the line:
local all all ident sameuser
Be aware though that this essentially opens postgres access to anyone
with shell access. There are a few other ways to deal with them but the
PostgreSQL docs do a better job at explaining it than I can.
HTH!
Madison
--
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Madison Kelly (Digimer)
TLE-BU; The Linux Experience, Back Up
Main Project Page: http://tle-bu.org
Community Forum: http://forum.tle-bu.org
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
