On Mon, 2 Jan 2006, Madison Kelly wrote:
> 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.
>
I tried your suggestion except substituting "password" for "trust" and
it seems to work without giving the farm away!
Many thanks,
Lucky