Re: Postgresql 8.0 or 8.1 vs. latest Red Hat RPM

Hi,

On Fri, 2006-02-10 at 10:18 +0000, Bradley Kieser wrote:

> For the sake of people like me, can you please explain a little further
> why you say that you need these RPMs?
> Just out of interest and to increase the resident knowledge pool as I
> for one am not aware of any problems so at least one person will learn
> from your posting!

RHEL 3 and RHEL 4 PHP RPMs are compiled with libpq.so.3 . However,
beginning from 8.0.2, libpq was bumped to version 4. So this broke
compatibility between the packages from PostgreSQL.org and RHEL PHP.

In order to solve that problem, we built a compatibility RPM which
installs libpq.so.3 and other libs to your system:

# rpm -ql compat-postgresql-libs
/usr/lib64/libecpg.so.4
/usr/lib64/libecpg.so.4.1
/usr/lib64/libecpg_compat.so.1
/usr/lib64/libecpg_compat.so.1.2
/usr/lib64/libpgtypes.so.1
/usr/lib64/libpgtypes.so.1.2
/usr/lib64/libpq.so.3
/usr/lib64/libpq.so.3.1

If you use Red Hat's RPMs, you don't have this problem because they
provide PostgreSQL 7.4, which satisfies PHP dependency.

Here is a sample output from my RHEL 4 (x86_64) home box:

# rpm -e compat-postgresql-libs
error: Failed dependencies:
libpq.so.3()(64bit) is needed by (installed)
dovecot-0.99.11-2.EL4.1.x86_64
libpq.so.3()(64bit) is needed by (installed) perl-DBD-
Pg-1.31-6.x86_64
libpq.so.3()(64bit) is needed by (installed) php-
pgsql-4.3.9-3.9.x86_64

We could not document that well except questions in mailing lists and my
PostgreSQL blog, that's my mistake I believe.

Regards,
--
The PostgreSQL Company - Command Prompt, Inc. 1.503.667.4564
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
Managed Services, Shared and Dedicated Hosting
Co-Authors: PL/php, plPerlNG - http://www.commandprompt.com/