| From: | Andrew McMillan <andrew(at)catalyst(dot)net(dot)nz> |
|---|---|
| To: | Joel Lopez <badassmexican(at)attbi(dot)com> |
| Cc: | pgsql-novice(at)postgresql(dot)org |
| Subject: | Re: psql: FATAL 1: IDENT authentication failed for user |
| Date: | 2003-02-13 10:11:35 |
| Message-ID: | 1045131095.14217.258.camel@kant.mcmillan.net.nz |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
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/
---------------------------------------------------------------------
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Oliver Elphick | 2003-02-13 11:28:42 | Re: view users |
| Previous Message | Susan Hoddinott | 2003-02-13 04:15:58 | Executing SQL commands in script files |