Re: php pg_connect fails, pgsql works

On Mon, Mar 10, 2008 at 1:14 PM, John Cartwright
<John.C.Cartwright@noaa.gov> 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

?