From: | Chadwick Rolfs <cmr(at)shell(dot)gis(dot)net> |
---|---|
To: | arun kv <arun(at)library(dot)iisc(dot)ernet(dot)in> |
Cc: | PGSQL <pgsql-php(at)postgresql(dot)org> |
Subject: | Re: Error"Unable to connect to PostgresSQL server: connectDBStart()" |
Date: | 2002-09-09 14:46:46 |
Message-ID: | Pine.SOL.3.96.1020909104101.14218A-100000@shell.gis.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-php |
How about checking that localhost is defined in /etc/hosts here's mine:
127.0.0.1 ssbeagle localhost
it also may be that pg_hba.conf doesn't have a localhost entry. Could you
post the pertinent lines of /var/www/html/phpfile/other/orthersbrowse.php?
If it's not too big, post it all. Then maybe you could let us know what
pg_hba.conf accepts for local connections see:
http://postgresql.crimelabs.net/users-lounge/docs/7.1/postgres/client-authentication.html
Another option, if this is all local (it looks like it is) is to take out
the hostname part of the pg_connect("") string. Username database, and
maybe even password (if you set it up) may be all you need anyway.
Hope this helps!
On Mon, 9 Sep 2002, arun kv wrote:
> hello,
> I am using PHP to connect to postgresql server. Till now it was
> working fine and PHP was connecting sql server without any problems.
> Suddenly today i am getting an error or warning which says
> 'Warning:
> Unable to connect to PostgresSQL server: connectDBStart() -- unknown
> hostname: localhost in /var/www/html/phpfiles/others/othersbrowse.php on
> line 20
> Warning: Supplied argument is not a valid PostgreSQL link
> resource in /var/www/html/phpfiles/others/othersbrowse.php on line 25
> ERROR IN
> EXECUTION'
>
>
> I am not getting what the problem was. Beform some times it used to come
> but when i restarted the system it used to work fine.
> Pls anybody tell me what the problem is and any suggestions pls since the
> server has to run all the 24 hours and 365 days.
> thanks in advance
> Arun
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly
>
-Chadwick
From | Date | Subject | |
---|---|---|---|
Next Message | David C. Brown | 2002-09-09 15:46:12 | Re: Error"Unable to connect to PostgresSQL server: connectDBStart()" |
Previous Message | arun kv | 2002-09-09 11:37:38 | Error"Unable to connect to PostgresSQL server: connectDBStart()" |