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

From: "Joel Lopez" <badassmexican(at)attbi(dot)com>
To: <pgsql-novice(at)postgresql(dot)org>
Subject: Re: psql: FATAL 1: IDENT authentication failed for user "phpuser"
Date: 2003-02-12 18:22:14
Message-ID: EMEKKBIPODLHPHIIILBJOELIDEAA.badassmexican@attbi.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

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(at)postgresql(dot)org
[mailto:pgsql-novice-owner(at)postgresql(dot)org]On Behalf Of Joel Lopez
Sent: Wednesday, February 12, 2003 10:06 AM
To: pgsql-novice(at)postgresql(dot)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(at)postgresql(dot)org)

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Sumaira Ali 2003-02-12 23:08:34 session level locks
Previous Message Joel Lopez 2003-02-12 18:06:29 psql: FATAL 1: IDENT authentication failed for user "phpuser"