Postgres Pro
Downloads
Home   >   mailing lists

Thread: psql: FATAL 1: IDENT authentication failed for user "phpuser"

psql: FATAL 1: IDENT authentication failed for user "phpuser"

From
"Joel Lopez"
Date:
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?

thanks

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

From
"Joel Lopez"
Date:
I also don't know if my system is configuered correctly.  I ultimatly want
to be able to use PHP and PostgreSQL.  I did a full install of Red Hat 8
with PHP and PostgreSQL included.

I've been reading a lot of lists and web sites and 3 different places tell
me to modify these files:

    pg_hba.conf
    postmaster.opts
    postgresql.conf

Should these be modified?

thanks

-----Original Message-----
From: pgsql-novice-owner@postgresql.org
[mailto:pgsql-novice-owner@postgresql.org]On Behalf Of Joel Lopez
Sent: Wednesday, February 12, 2003 10:06 AM
To: pgsql-novice@postgresql.org
Subject: [NOVICE] psql: FATAL 1: IDENT authentication failed for user
"phpuser"


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?

thanks

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
    (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)

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

From
Andrew McMillan
Date:
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/
---------------------------------------------------------------------

User Problem In PostgreSQL On Mac OS X

From
Robert Prather
Date:
This will likely sound stupid, but I installed PostgreSQL on my Mac a
few weeks ago and got diverted.  I tried to return to it and discovered
that I had created a user called "postgre", which is the primary user.
The user appears in the user list in the System Requirements panel but
can't be edited, at least not by me.

Now for the stupid part: I forgot the password for that user.  I
installed it using FINK and everything went well as I recall.  Do I
need to uninstall the software?  If so, is there an easy way to do
this?  Or can I somehow retrieve the password for user postgre?

Any help would be appreciated.

Robert Prather