pg.ddx.io  pgsql-php@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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






view thread (6+ messages)  latest in thread

Message-ID: <20070209113129.he36qgs4vthc0o4c@imp3.uta.fi>
Permalink:  ../20070209113129.he36qgs4vthc0o4c@imp3.uta.fi/
Also on:    postgresql.org/message-id/20070209113129.he36qgs4vthc0o4c@imp3.uta.fi

 · 

reply

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