Re: pg_pconnect() question
| From: | Varsha Agarwal | Date: | Fri, 26 Jul 2002 19:49:47 +0000 |
| Subject: | Re: pg_pconnect() question | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-109864@lists.php.net to get a copy of this message | ||
I changed the user name in pg_pconnect(), also i
checked the pg_hba.conf for authentication. The
authentication type is trust. But still I am getting
the same warning while connecting to the database. Can
anyone figure what might be the problem?
--- "Lejanson C. Go" <lejanson@ntsp.nec.co.jp> wrote:
> Varsha,
>
> try creating a new user for postgreSQl and do not
> use
> the "postgres"
>
> try this at command line:
>
> [guest@localhost]$ su
> [root@localhost]$ su - postgres
> [postgres@localhost]$ create user username
>
>
> in ur pg_connect
>
> specify the username.dont use postgres.
>
>
> Varsha Agarwal wrote:
>
> > I am trying to connect to postgre_sql database
> using
> > pg_pconnect(). When I try to run it i get the
> > following error
> > Warning: Unable to connect to PostgreSQL server:
> FATAL
> > 1: IDENT authentication failed for user "postgres"
> in
> > /var/www/html/test.php on line 3
> > connection failed
> >
> > Please tell me what might be the reason.
> > -Varsha
> >
> > __________________________________________________
> > Do You Yahoo!?
> > Yahoo! Health - Feel better, live better
> > http://health.yahoo.com
> >
> >
>
>
>
> --
> Lejanson C. Go, SDE I
>
__________________________________________________
Do You Yahoo!?
Yahoo! Health - Feel better, live better
http://health.yahoo.com