From: | Bill Moran <wmoran(at)potentialtech(dot)com> |
---|---|
To: | Rich Shepard <rshepard(at)appl-ecosys(dot)com> |
Cc: | pgsql-php(at)postgresql(dot)org |
Subject: | Re: Connecting PHP-based Application to Postgres-9.0.3 |
Date: | 2011-04-07 16:56:35 |
Message-ID: | 20110407125635.1ae13751.wmoran@potentialtech.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-php |
In response to Rich Shepard <rshepard(at)appl-ecosys(dot)com>:
> On Thu, 7 Apr 2011, Alan Hodgson wrote:
>
> > Can you connect to the database with psql using the same credentials? PHP
> > will use the same underlying postgresql library to connect.
>
> Alan,
>
> If you mean can I as a user connect to that same database, the answer is
> yes:
>
> [rshepard(at)salmo ~]$ psql cms
> psql (9.0.3)
> Type "help" for help.
This is incorrect.
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.
See if
psql -h localhost cms
works.
--
Bill Moran
http://www.potentialtech.com
http://people.collaborativefusion.com/~wmoran/
From | Date | Subject | |
---|---|---|---|
Next Message | Rich Shepard | 2011-04-07 17:13:31 | Re: Connecting PHP-based Application to Postgres-9.0.3 |
Previous Message | Alan Hodgson | 2011-04-07 16:51:35 | Re: Connecting PHP-based Application to Postgres-9.0.3 |