Yes, the command-line client works fine that way.
Turns out the problem was SELinux permissions that had to be
specifically enabled.
Thanks for the suggestions and the help.
-- john
Scott Marlowe wrote:
On Mon, Mar 10, 2008 at 1:14 PM, John Cartwright
<John.C.Cartwright@xxxxxxxx> wrote:
Hello All,
I'm using php 5.1.6 on a RHEL 5 system connecting to a postgresql server
version 8.2.3. I think that TCP connections are enabled correctly in
the server's pg_hba.conf and I can successfully connect from the client
using pgsql. However, trying to use pg_connect() w/ a call like:
$con = pg_connect("host='postgres1.ngdc.noaa.gov' port=5432
sslmode='allow' user='test' password='mypassword' dbname='test'")
if you do psql like so, can it connect?
psql -h postgres1.ndgc.noaa.gov -U test test
?
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
