Re: php pg_connect fails, pgsql works

From: "Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com>
To: "John Cartwright" <John(dot)C(dot)Cartwright(at)noaa(dot)gov>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: php pg_connect fails, pgsql works
Date: 2008-03-10 22:46:42
Message-ID: dcc563d10803101546leaecdcbm9a4f303bf2f68f06@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Mon, Mar 10, 2008 at 1:14 PM, John Cartwright
<John(dot)C(dot)Cartwright(at)noaa(dot)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

?

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message John Cartwright 2008-03-10 23:15:27 Re: php pg_connect fails, pgsql works - RESOLVED
Previous Message mgainty 2008-03-10 22:40:49 Re: ISO something like "#if 0 ... #endif" for SQL code