The following bug has been logged online:

Bug reference: 1176
Logged by: thoyyib

Email address: thoyyib (AT) rediffmail (DOT) com

PostgreSQL version: 7.4

Operating system: linux

Description: PHP connection

Details:

The error report is :
FATEL: IDENT authentication failed for user "postgres"
I am a new user. pls help me....


---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

On Tue, 2004-06-22 at 10:29, PostgreSQL Bugs List wrote:
....
You must ensure that the authentication options are set correctly in
$PGDATA/pg_hba.conf. This file is described in chapter 19 of the manual
(Client Authentication).

Presumably PHP is running from a webserver. In that case, you cannot
use "ident sameuser" authentication to give access to any user but the
one under whose identity the webserver itself is running. If you want
to have different users connecting through the webserver, you will have
to use some kind of password authentication instead.

--
Oliver Elphick olly (AT) lfix (DOT) co.uk
Isle of Wight http://www.lfix.co.uk/oliver
GPG: 1024D/A54310EA 92C8 39E7 280E 3631 3F0E 1EC0 5664 7A2F A543 10EA
========================================
"Therefore being justified by faith, we have peace with
God through our Lord Jesus Christ." Romans 5:1


---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

PostgreSQL Bugs List wrote:
You should update the access permissions in you pg_hba.conf file.
Details are in the manuals.

I recommend you subscribe to the novice mailing list (details at
http://www.postgresql.org/lists.html) - lots of good help there.

HTH
--
Richard Huxton
Archonet Ltd

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

On Tue, Jun 22, 2004 at 06:29:29 -0300,
PostgreSQL Bugs List <pgsql-bugs (AT) postgresql (DOT) org> wrote:
This isn't really a bug; you should have posted you question to pgsql-novice.
(Followups set to there and to you.)

The simplest solution is probably to su to root and then su to postgres
and then do whatever you were trying to do.

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend