Received: from localhost (maia-2.hub.org [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id 23CD49FB535 for ; Fri, 9 Feb 2007 07:43:45 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-new, port 10024) with ESMTP id 76928-02 for ; Fri, 9 Feb 2007 07:43:14 -0400 (AST) X-Greylist: delayed 00:31:54.911661 by SQLgrey-1.7.4 Received: from rehuapila.uta.fi (rehuapila.uta.fi [153.1.1.45]) by postgresql.org (Postfix) with ESMTP id 5270E9FA6B5 for ; Fri, 9 Feb 2007 06:03:30 -0400 (AST) Received: from neliapila.uta.fi (neliapila.uta.fi [153.1.1.43]) by rehuapila.uta.fi (8.13.8/8.13.8) with ESMTP id l199VXS9020040 for ; Fri, 9 Feb 2007 11:31:33 +0200 (EET) Received: from apila.uta.fi (localhost.localdomain [127.0.0.1]) by neliapila.uta.fi (8.13.8/8.13.8) with ESMTP id l199VU9C019717 for ; Fri, 9 Feb 2007 11:31:30 +0200 Received: from pippuri.uta.fi (pippuri.uta.fi [153.1.6.42]) by apila.uta.fi (8.13.8/8.13.8) with ESMTP id l199VTUG023636 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=NOT) for ; Fri, 9 Feb 2007 11:31:29 +0200 (EET) Received: from pippuri.uta.fi (localhost.localdomain [127.0.0.1]) by pippuri.uta.fi (8.13.4/8.13.4/Debian-3sarge3) with ESMTP id l199VT5c032138 for ; Fri, 9 Feb 2007 11:31:29 +0200 Received: (from wwwroot@localhost) by pippuri.uta.fi (8.13.4/8.13.4/Submit) id l199VTJt032137 for pgsql-php@postgresql.org; Fri, 9 Feb 2007 11:31:29 +0200 Received: from mustikka.uta.fi (mustikka.uta.fi [153.1.33.43]) by imp3.uta.fi (Horde MIME library) with HTTP; Fri, 09 Feb 2007 11:31:29 +0200 Message-ID: <20070209113129.he36qgs4vthc0o4c@imp3.uta.fi> Date: Fri, 09 Feb 2007 11:31:29 +0200 From: Mihail Mihailov To: pgsql-php@postgresql.org Subject: phpinfo(): postgresql versions' mismatch MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8; DelSp="Yes"; format="flowed" Content-Disposition: inline Content-Transfer-Encoding: quoted-printable User-Agent: Internet Messaging Program (IMP) H3 (4.1.4-cvs) X-Greylist: Sender IP whitelisted, not delayed by milter-greylist-3.0 (apila.uta.fi [153.1.1.41]); Fri, 09 Feb 2007 11:31:29 +0200 (EET) X-Scanned-By: MIMEDefang 2.58 on 153.1.1.43 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200702/16 X-Sequence-Number: 3699 Dear all, I have recently found out that PHP libpq Version reported by =20 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 =20 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 =20 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 =097.4.7 I believe I have both libpq3 and libpq4 I've checked /etc/php5/apache2/conf.d/pgsql.ini and =20 /etc/php5/apache2/conf.d/pdo_pgsql.ini /etc/php5/apache2/conf.d/pgsql.ini: extension=3Dpgsql.so /etc/php5/apache2/conf.d/pdo_pgsql.ini: extension=3Dpdo_pgsql.so Thanks in advence for any advice, Mihail