Skip site navigation (1) Skip section navigation (2)

phpinfo(): postgresql versions' mismatch

From: Mihail Mihailov <Mihail(dot)Mihailov(at)uta(dot)fi>
To: pgsql-php(at)postgresql(dot)org
Subject: phpinfo(): postgresql versions' mismatch
Date: 2007-02-09 09:31:29
Message-ID: 20070209113129.he36qgs4vthc0o4c@imp3.uta.fi (view raw or flat)
Thread:
Lists: pgsql-php
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




Responses

pgsql-php by date

Next:From: Michael FuhrDate: 2007-02-09 14:57:31
Subject: Re: phpinfo(): postgresql versions' mismatch
Previous:From: Marco ColomboDate: 2007-02-08 13:48:15
Subject: Re: pg_[un]escape_bytea, pgsql 8.2.1, php 5.1.6, Linux

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group