Re: [GENERAL] problems connecting to php via pg_connect and PGCLUSTER

2012-02-07 Thread Chris
On 07/02/12 17:08, Dave Potts wrote: Hi Chris Thanks for the suggestion, I tried a making the changes are you suggest, I still getting an error from Postgres ie define(PG_OPTIONS , --cluster=9.1/main); define(PG_DB , tripe); define(PG_HOST, localhost); define(PG_USER, dp42);

Re: [GENERAL] problems connecting to php via pg_connect and PGCLUSTER

2012-02-07 Thread Scott Marlowe
On Mon, Feb 6, 2012 at 4:03 PM, Dave Potts dave.po...@pinan.co.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

[FIXED] Re: [GENERAL] problems connecting to php via pg_connect and PGCLUSTER

2012-02-07 Thread Dave Potts
Thanks guys its sorted. Both your suggestions worked :-) Scott Marlowe wrote: On Mon, Feb 6, 2012 at 4:03 PM, Dave Potts dave.po...@pinan.co.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

[GENERAL] problems connecting to php via pg_connect and PGCLUSTER

2012-02-06 Thread Dave Potts
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

Re: [GENERAL] problems connecting to php via pg_connect and PGCLUSTER

2012-02-06 Thread Chris
On 07/02/12 10:03, Dave Potts 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 ,

Re: [GENERAL] problems connecting to php via pg_connect and PGCLUSTER

2012-02-06 Thread Dave Potts
Hi Chris Thanks for the suggestion, I tried a making the changes are you suggest, I still getting an error from Postgres ie define(PG_OPTIONS , --cluster=9.1/main); define(PG_DB , tripe); define(PG_HOST, localhost); define(PG_USER, dp42); define(PG_PORT, 5432); define(TABLE,