Re: psql: FATAL 1: IDENT authentication failed for user

On Thu, 2003-02-13 at 07:06, Joel Lopez wrote:
> Hi,
>
> These are the commands I entered:
>
>     su postgres
>     createuser phpuser
>         allowed to create DB: y
>         allowed to create users: y
>             (saw CREATE USER)
>     createdb phpdb
>             (saw CREATE DATABASE)
>
>     psql phpdb -U phpuser
>             (saw psql: FATAL 1: IDENT authentication failed for user "phpuser")
>
> Is there a step I'm missing or am I entering the commands wrong?

You need to "trust" local users in pg_hba.conf.

Cheers,
                    Andrew.
--
---------------------------------------------------------------------
Andrew @ Catalyst .Net.NZ Ltd, PO Box 11-053, Manners St,  Wellington
WEB: http://catalyst.net.nz/         PHYS: Level 2, 150-154 Willis St
DDI: +64(4)916-7201     MOB: +64(21)635-694    OFFICE: +64(4)499-2267
           Survey for nothing with http://survey.net.nz/
---------------------------------------------------------------------