hi...
i am workin on PHP with postgreSQl for the past 2 months...
both r completely new for me....
there is an install script of our application that will check for certain things and then it will create the DB and tables..
when i am executin it...Its givin an error..

psql: FATAL: IDENT authentication failed for user "manashi"
psql: FATAL: IDENT authentication failed for user "manashi"

the install script will check for followin things b4 creatin the DB :-

1.Check to see if web server is up and running
2.Check to see if Python is installed on not
3.Get the web root
4.Get the host access
5.Check to see if postgreSQL has been installed
6.Check to see if PostgreSQL support for PHP has been installed

every thing is fine till this point...

after that it will ask 4 :-
1.DB name
2.DB user name
3.DB password
4.chart server location name

then it will create the DB ....here its showin the error...

the code is as follows :-

if test -n "$DB_PASSWORD"
then
SQL_SUFFIX="identified by '$DB_PASSWORD'"
fi
psql -U $DB_LOGIN template1
createdb $DB_NAME;
\q
EOF
#cat >samp<../db/thinkdb-schema.sql
psql -U $DB_LOGIN $DB_NAME<../db/thinkdb-schema.sql

I am tryin to debug the error for the past 1 week bt was not able to do that

waitin for the reply ....

Please try spelling out your verbs: working, executing, etc.

As far as your problem:
1. Log in manually to verify that the correct PostgreSQL username/password is actually being set in the database.

... then, and ONLY then ...

2. Use "set -x" in your script to verify whether or not the shell variables are being set correctly

At that point, everything should work fine.

'Hope that helps .. PSM

What is the content of your pg_hba.conf ?


Cheers,
Tink