Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-novice by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group