Re: problems connecting to php via pg_connect and PGCLUSTER

From: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
To: dave(dot)potts(at)pinan(dot)co(dot)uk
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: problems connecting to php via pg_connect and PGCLUSTER
Date: 2012-02-07 22:43:26
Message-ID: CAOR=d=2DgJr2bDM+WdhfUdwckM4RO1FL9MybDr2V+z5uM4tYdQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Mon, Feb 6, 2012 at 4:03 PM, Dave Potts <dave(dot)potts(at)pinan(dot)co(dot)uk> wrote:
>
> I have two versions of postgres installed, 8.4 and 9.1 installed on the
> same machine
>
> To connect to my 9.1 database, I defined the envromental variable
>
> PGCLUSTER=9.1/main
>
> and use psql to connect via php pg_connect
> I have try saying
>
> define("PG_OPTIONS"  , "--cluster=9.1/main");
>
> and using the phrase
>
>  $con = pg_connect("dbname=".PG_DB." host=".PG_HOST." user=".PG_USER."
> options=".PG_OPTIONS);

Get rid of the options and just put in the port of the cluster you
want to connect to.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message sunpeng 2012-02-08 04:19:33 Hi, are there any other open source parallel query engine like pgpool?
Previous Message Chris 2012-02-07 22:35:44 Re: problems connecting to php via pg_connect and PGCLUSTER