pg.ddx.io  pgsql-php@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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




view thread (4+ messages)  latest in thread

Message-ID: <Pine.SOL.3.96.1020909104101.14218A-100000@shell.gis.net>
Permalink:  ../Pine.SOL.3.96.1020909104101.14218A-100000@shell.gis.net/
Also on:    postgresql.org/message-id/Pine.SOL.3.96.1020909104101.14218A-100000@shell.gis.net

 · 

reply

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