pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Devrim GUNDUZ <devrim@commandprompt.com>
To: Bradley Kieser <brad@kieser.net>
Cc: Dominik Składanowski <dskladanowski@gmail.com>
Cc: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
Subject: Re: Postgresql 8.0 or 8.1 vs. latest Red Hat RPM
Date: Fri, 10 Feb 2006 12:47:56 +0200
Message-ID: <1139568476.23116.13.camel@evim.gunduz.org> (raw)
In-Reply-To: <43EC686A.8030509@kieser.net>
References: <b499671a0602091458x272e46b0v@mail.gmail.com>
	<1139526417.16736.6.camel@evim.gunduz.org>
	<43EC686A.8030509@kieser.net>

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/




view thread (12+ messages)

Message-ID: <1139568476.23116.13.camel@evim.gunduz.org>
Permalink:  ../1139568476.23116.13.camel@evim.gunduz.org/
Also on:    postgresql.org/message-id/1139568476.23116.13.camel@evim.gunduz.org

 · 

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-admin@postgresql.org
  Cc: devrim@commandprompt.com, brad@kieser.net, dskladanowski@gmail.com
  Subject: Re: Postgresql 8.0 or 8.1 vs. latest Red Hat RPM
  In-Reply-To: <1139568476.23116.13.camel@evim.gunduz.org>
  References: <b499671a0602091458x272e46b0v@mail.gmail.com> <1139526417.16736.6.camel@evim.gunduz.org> <43EC686A.8030509@kieser.net> <1139568476.23116.13.camel@evim.gunduz.org>

* 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