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" , "--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?
Try putting quotes around the options, eg:
pg_connect("host=localhost options='".PG_OPTIONS."'");
Alternatively, set the port and the path to the socket directory (not
the actual file), eg:
pg_connect('dbname=xxx host=/tmp user=xxx port=5433');
If the socket file is in /tmp/
--
Postgresql & php tutorials
http://www.designmagick.com/
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
