From: | "Dave Potts" <dave(dot)potts(at)pinan(dot)co(dot)uk> |
---|---|
To: | "Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com>, adrian(dot)klaver(at)gmail(dot)com |
Cc: | dave(dot)potts(at)pinan(dot)co(dot)uk, pgsql-general(at)postgresql(dot)org |
Subject: | [FIXED] Re: problems connecting to php via pg_connect and PGCLUSTER |
Date: | 2012-02-08 06:30:01 |
Message-ID: | cff5770aab8da6bccd8f36c80fa520dd.squirrel@dp2642.force9.co.uk |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Thanks guys its sorted.
Both your suggestions worked :-)
Scott Marlowe wrote:
> 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.
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>
--
From | Date | Subject | |
---|---|---|---|
Next Message | Pat Heuvel | 2012-02-08 09:48:39 | Re: vacuumlo fails pgsql ver 8.3 |
Previous Message | Pavel Stehule | 2012-02-08 06:07:16 | Re: Hi,are there any other open source parallel query engine like pgpool? |