Re: Connecting PHP-based Application to Postgres-9.0.3

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

In response to Rich Shepard <rshepard@xxxxxxxxxxxxxxx>:

> 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

[Index of Archives]     [Postgresql General]     [Postgresql Admin]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Yosemite Backpacking]     [Postgresql Jobs]

  Powered by Linux