Re: Connecting PHP-based Application to Postgres-9.0.3

In response to Rich Shepard <[email protected]>:

> On Thu, 7 Apr 2011, Bill Moran wrote:
> 
> > The ADODB error message indicates that you are connecting to localhost via
> > TCP/IP. The default for psql when you don't specify a host is to connect
> > via unix domain socket. You're not testing the same thing.
> 
> Bill
> 
>    Oh.
> 
> > See if
> > psql -h localhost cms
> > works.
> 
>    Yes, it does:
> 
> [rshepard@salmo ~]$ psql -h localhost cms
> psql (9.0.3)
> Type "help" for help.
> 
> cms=#

Well, that blows my first theory out of the water ;)

Check the PG server logs, and consider increasing some logging levels
on the server.  PG does some pretty good logging of failed connections
if you have the settings right.

-- 
Bill Moran
http://www.potentialtech.com
http://people.collaborativefusion.com/~wmoran/

-- 
Sent via pgsql-php mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-php