problems connecting to php via pg_connect and PGCLUSTER
От | Dave Potts |
---|---|
Тема | problems connecting to php via pg_connect and PGCLUSTER |
Дата | |
Msg-id | f2577f4f1e1919d27358c4c45ee4d5ab.squirrel@dp2642.force9.co.uk обсуждение исходный текст |
Ответы |
Re: problems connecting to php via pg_connect and PGCLUSTER
Re: problems connecting to php via pg_connect and PGCLUSTER |
Список | pgsql-general |
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); When I attempt to connect to postgres, I get the error [Mon Feb 06 22:37:40 2012] [error] [client 127.0.0.1] PHP Warning: pg_connect(): Unable to connect to PostgreSQL server: FATAL: unrecognised configuration parameter "cluster" in /var/www/re/php/pgrouting.php on line 33, referer: http://127.0.0.1/re/routing-final.html Any suggestions as to the correct way of connecting to postgres? Dave. --
В списке pgsql-general по дате отправления: