Re: php5 and Pg 8.0.3 install from sources - problem

Hi,

On 5/18/05, michael(at)softasap(dot)net <michael(at)softasap(dot)net> wrote:
> Environment I am running is as follows:
> OS: Fedora Core 3
> php5.0.4
> Pg 8.0.3
>
> 3) compiled from source postgre (more recent version)
> 4) compiled from source php (more recent version)
> 5) installed zend optimizer
>
> During step 4, namely when I did make install of php I have got an error of
> libpq.so.4 was not found. I copied then it to /usr/lib and make worked. But
> when I tried to start apache it has failed to start complaining on libpq.so.4
> something like "can't open shared segment: Permission Denied.".

In PostgreSQL 8.0.3 release libpq major version number is changed and
this caused libpq dependent programs to break. (Further information:
http://pgfoundry.org/pipermail/pgsqlrpms-hackers/2005-April/000197.html)

If I'd return to your situation, it's not so feasible to just move the
libpq.so.4 shared file as a solution. AFAIC, you should re-compile PHP
using correct --with-pgsql directory.

Just pass the --prefix parameter of PostgreSQL ./configure script to
PHP's ./configure script. For instance:
postgresql-8.0.3# export PGSQL_PREFIX=/usr
postgresql-8.0.3# ./configure --prefix=$PGSQL_PREFIX ...
...
php-5.0.4# ./configure ... --with-pgsql=$PGSQL_PREFIX

Hope this helps.
Regards.