[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 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

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 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 sayi

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", "dp

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(

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" , "

[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 ph