Обсуждение: problems connecting to php via pg_connect and PGCLUSTER

Поиск
Список
Период
Сортировка

problems connecting to php via pg_connect and PGCLUSTER

От
"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 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.


--

Re: problems connecting to php via pg_connect and PGCLUSTER

От
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"  , "--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/

Re: problems connecting to php via pg_connect and PGCLUSTER

От
"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",   "route_table");
$con = pg_connect("dbname='".PG_DB."' host='".PG_HOST."'
user='".PG_USER."' options='".PG_OPTIONS."'");

Error message
04:41 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 34, referer:
http://127.0.0.1/re/routing-final.html

The problem is with the database server it has issues with the string
--cluster=9.1/main"

The system is happy enough if I set PGCLUSTER as follows

export PGCLUSTER=9.1/main
psql -d tripe

I am justing trying to the same with pg_connect


 wrote:
> 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@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>


--

Re: problems connecting to php via pg_connect and PGCLUSTER

От
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");
>   define("PG_PORT", "5432");
>   define("TABLE",   "route_table");
> $con = pg_connect("dbname='".PG_DB."' host='".PG_HOST."'
> user='".PG_USER."' options='".PG_OPTIONS."'");
>
> Error message
> 04:41 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 34, referer:
> http://127.0.0.1/re/routing-final.html
>
> The problem is with the database server it has issues with the string
> --cluster=9.1/main"
>
> The system is happy enough if I set PGCLUSTER as follows
>
> export PGCLUSTER=9.1/main
> psql -d tripe

psql knows what 'PGCLUSTER' is.

pg_connect() doesn't (unrecognised parameter "cluster"), so you can't do
it that way.

You could try

define('PG_OPTIONS', 'PGCLUSTER=9.1/main');

If that doesn't work you'll have to do it the other way I mentioned.

--
Postgresql & php tutorials
http://www.designmagick.com/

Re: problems connecting to php via pg_connect and PGCLUSTER

От
Scott Marlowe
Дата:
On Mon, Feb 6, 2012 at 4:03 PM, Dave Potts <dave.potts@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 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.

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

От
"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.potts@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 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@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>


--