From: Chadwick Rolfs <cmr@shell.gis.net>
To: arun kv <arun@library.iisc.ernet.in>
Cc: PGSQL <pgsql-php@postgresql.org>
Subject: Re: Error"Unable to connect to PostgresSQL server: connectDBStart()"
Date: Mon, 9 Sep 2002 10:46:46 -0400 (EDT)
Message-ID: <Pine.SOL.3.96.1020909104101.14218A-100000@shell.gis.net> (raw)
In-Reply-To: <Pine.BSO.4.44.0209091647120.20618-100000@library.iisc.ernet.in>
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@postgresql.org so that your
> message can get through to the mailing list cleanly
>
-Chadwick
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-php@postgresql.org
Cc: cmr@shell.gis.net, arun@library.iisc.ernet.in
Subject: Re: Error"Unable to connect to PostgresSQL server: connectDBStart()"
In-Reply-To: <Pine.SOL.3.96.1020909104101.14218A-100000@shell.gis.net>
References: <Pine.BSO.4.44.0209091647120.20618-100000@library.iisc.ernet.in> <Pine.SOL.3.96.1020909104101.14218A-100000@shell.gis.net>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox