We are in the process of upgrading our postgres database from 7.4 to 8.2 on Redhat ES4 server. Postgresql uses libpq.so.5.0, while libpq.so.3 was initially installed and is needed by php. I did the postgresql 8.2.10 installation without dependency:
rpm -Uvh --nodeps postgresql-*.rpm
Then I try to recompile PHP 4.3.9 rpm, hoping that it will point to the new postgres so. The compilation failed with the error:
Unable to load dynamic library '/usr/lib/php4/pgsql.so' - libpq.so.3: cannot open shared object file: No such file or directory in Unknown on line 0
Can PHP 4.3 work with postgresql 8.2, and how can I point PHP rpm to use libpq.so.5? Thanks.
Lawrence