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

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

In response to

Browse pgsql-php by date

  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()"