Error"Unable to connect to PostgresSQL server: connectDBStart()"

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@postgresql.org so that your
message can get through to the mailing list cleanly

Re: Error"Unable to connect to PostgresSQL server: connectDBStart()"

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/postgr es/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@postgresql.org so that your
> message can get through to the mailing list cleanly
>

-Chadwick


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

http://archives.postgresql.org