Re: pg_connect fails, pgsql works

On 10/03/2008 17:37, John Cartwright wrote:

> $con = pg_connect("host='postgres1.ngdc.noaa.gov' port=5432
> sslmode='allow' user='test' password='mypassword' dbname='test'")

I don't think you need to quote the host, uid, etc - try it without the
single quotes, e.g.

"host=postgres1.ngdc.noaa.gov port=5432 sslmode=allow user=test [....]"

HTH,

Ray.

---------------------------------------------------------------
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
rod(at)iol(dot)ie
---------------------------------------------------------------