From: Mihail Mihailov <Mihail.Mihailov@uta.fi>
To: pgsql-php@postgresql.org
Subject: phpinfo(): postgresql versions' mismatch
Date: Fri, 09 Feb 2007 11:31:29 +0200
Message-ID: <20070209113129.he36qgs4vthc0o4c@imp3.uta.fi> (raw)
Dear all,
I have recently found out that PHP libpq Version reported by
phpinfo() doesn't match the Actual PGSQL Version on the server.
I suspect this is the reason why some of postgresql queries do not run
via web interface and run without any problem via psql.
I have checked the web for an answer but found so far only this thread:
http://svr5.postgresql.org/pgsql-novice/2006-03/msg00208.php
They say that it is not critical if php uses the old libpq, still it
is better if the versions match.
The question is how what shall I do to make them match.
I'm using
Debian Sarge 3.1 (stable)
PostgreSql 8.1.4 (installed via Debian backports)
php version 5.2.0-8 (also installed from backports)
phpinfo() reports that:
PostgreSQL(libpq) Version 7.4.7
I believe I have both libpq3 and libpq4
I've checked /etc/php5/apache2/conf.d/pgsql.ini and
/etc/php5/apache2/conf.d/pdo_pgsql.ini
/etc/php5/apache2/conf.d/pgsql.ini:
extension=pgsql.so
/etc/php5/apache2/conf.d/pdo_pgsql.ini:
extension=pdo_pgsql.so
Thanks in advence for any advice,
Mihail
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-php@postgresql.org
Cc: Mihail.Mihailov@uta.fi
Subject: Re: phpinfo(): postgresql versions' mismatch
In-Reply-To: <20070209113129.he36qgs4vthc0o4c@imp3.uta.fi>
References: <20070209113129.he36qgs4vthc0o4c@imp3.uta.fi>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox