Re: RHEL4 RPM packages

the PGDG .rpm's for RHEL4 have a bit of an annoyance...

RHEL4 ships with postgres 7.4.x, and various RHEL4 RPMs have a
dependency on libpq.so.3 ...

# rpm -Uvh postgresql-8.2.3-1PGDG.i686.rpm \
> postgresql-libs-8.2.3-1PGDG.i686.rpm \
> postgresql-server-8.2.3-1PGDG.i686.rpm \
> postgresql-contrib-8.2.3-1PGDG.i686.rpm \
> compat-postgresql-libs-4-2PGDG.rhel4.i686.rpm
warning: /var/tmp/rpm-xfer.N9M9NQ: V3 DSA signature: NOKEY, key ID 20579f11
error: Failed dependencies:
libpq.so.3 is needed by (installed) dovecot-0.99.11-4.EL4.i386

compat-postgresql-libs-4-2PGDG.rhel4.rpm supplies libpq.so.4 and .4.1,
but it does NOT include .so.3. I think it should provide a .so.3 which
can coexist with the rest of the 8.2.3 stack (or, there should be a
compat-postgresql-libs-3 ?)

John R Pierce wrote:
> RHEL4 ships with postgres 7.4.x, and various RHEL4 RPMs have a
> dependency on libpq.so.3 ...

Using the CentOS 4 base repository, I've identified these RPMs as
depending on libpq.so.3, which is obsoleted and removed by the
postgresql-libs-8.2.3-1PGDG RPM ...

cyrus-sasl-sql-0:2.1.19-5.EL4.i386
dovecot-0:0.99.11-4.EL4.i386
freeradius-postgresql-0:1.0.1-3.RHEL4.3.i386
libdbi-dbd-pgsql-0:0.6.5-10.RHEL4.1.i386
mod_auth_pgsql-0:2.0.1-7.1.i386
perl-DBD-Pg-0:1.31-6.i386
php-pgsql-0:4.3.9-3.22.3.i386
qt-PostgreSQL-1:3.3.3-10.RHEL4.i386

I could see this being a real pain, for instance, if I wanted to do PHP
or Perl work with PostgreSQL, I'd have to replace the RHEL4 version of
PHP with something custom built.

John,

On 3/2/07, John R Pierce <pierce(at)hogranch(dot)com> wrote:
> compat-postgresql-libs-4-2PGDG.rhel4.rpm supplies libpq.so.4 and .4.1,
> but it does NOT include .so.3. I think it should provide a .so.3 which
> can coexist with the rest of the 8.2.3 stack (or, there should be a
> compat-postgresql-libs-3 ?)

Just use this package:
http://developer.postgresql.org/~devrim/rpms/compat/ (and especially
http://developer.postgresql.org/~devrim/rpms/compat/compat-postgresql-libs-3-3PGDG.i686.rpm
as you don't seem to use 64 bits packages)
which includes libpq.so.3. It works well on RHEL4.

FYI, Devrim is the PGDG RPM maintainer.

--
Guillaume

Hi,

On Thu, 2007-03-01 at 18:23 -0800, John R Pierce wrote:
> (or, there should be a compat-postgresql-libs-3 ?)

Hmm.

Ok, I'll upload compat-postgresql-libs-3 to our ftp server this weekend,
to rhel-4 directories; so that people can find that package easily.

Regards,
--
Devrim GÜNDÜZ
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
Managed Services, Shared and Dedicated Hosting
Co-Authors: plPHP, ODBCng - http://www.commandprompt.com/

Devrim GÜNDÜZ wrote:
> Hi,
>
> On Thu, 2007-03-01 at 18:23 -0800, John R Pierce wrote:
>
>> (or, there should be a compat-postgresql-libs-3 ?)
>>
>
> Hmm.
>
> Ok, I'll upload compat-postgresql-libs-3 to our ftp server this weekend,
> to rhel-4 directories; so that people can find that package easily.
>

ah! I think thats a good thing. I did not know where to look for this.

thanks, all!

Devrim GÜNDÜZ wrote:
> Hi,
>
> On Thu, 2007-03-01 at 18:23 -0800, John R Pierce wrote:
>
>> (or, there should be a compat-postgresql-libs-3 ?)
>>
>
> Hmm.
>
> Ok, I'll upload compat-postgresql-libs-3 to our ftp server this weekend,
> to rhel-4 directories; so that people can find that package easily.
>
> Regards,
>

hmmmm.

Preparing... ###########################################
[100%]
package compat-postgresql-libs-4-2PGDG.rhel4 (which is newer
than compat-postgresql-libs-3-3PGDG) is already installed

looks like the RPMs for libpq.so.4 and libpq.so.3 can't coexist.

# rpm -qil compat-postgresql-libs
Name : compat-postgresql-libs Relocations: (not relocatable)
Version : 4 Vendor: (none)
Release : 2PGDG.rhel4 Build Date: Wed 06 Dec 2006
05:05:19 AM PST
Install Date: Thu 01 Mar 2007 06:14:38 PM PST Build Host:
web.sanalotogar.com
Group : Applications/Databases Source RPM:
compat-postgresql-libs-4-2PGDG.rhel4.src.rpm
Size : 844192 License: BSD
Signature : (none)
URL : http://www.postgresql.org/
Summary : PostgreSQL client programs and libraries
Description :
This package provides compatibility libraries
for PostgreSQL >= 8.0.2 and PostgreSQL <=8.1.X
/usr/lib/libpq.so.4
/usr/lib/libpq.so.4.1

# rpm -qilp compat-postgresql-libs-3-3PGDG.i686.rpm
warning: compat-postgresql-libs-3-3PGDG.i686.rpm: V3 DSA signature:
NOKEY, key ID 748f7d0e
Name : compat-postgresql-libs Relocations: (not relocatable)
Version : 3 Vendor: (none)
Release : 3PGDG Build Date: Tue 31 May 2005
05:33:59 AM PDT
Install Date: (not installed) Build Host: tdm.com.tr
Group : Applications/Databases/Interfaces Source RPM:
compat-postgresql-libs-3-3PGDG.src.rpm
Size : 1217072 License: BSD
Signature : DSA/SHA1, Tue 31 May 2005 05:40:12 AM PDT, Key ID
b65f3a3f748f7d0e
Packager : Devrim GUNDUZ <devrim(at)PostgreSQL(dot)org>
URL : http://www.postgresql.org/
Summary : PostgreSQL client programs and libraries.
Description :
This package provides compatibility libraries for PostgreSQL >= 8.0.2.
/usr/lib/libecpg.so.4
/usr/lib/libecpg.so.4.1
/usr/lib/libecpg_compat.so.1
/usr/lib/libecpg_compat.so.1.2
/usr/lib/libpgtypes.so.1
/usr/lib/libpgtypes.so.1.2
/usr/lib/libpq.so.3
/usr/lib/libpq.so.3.1

Hi,

On Fri, 2007-03-02 at 09:17 -0800, John R Pierce wrote:
> looks like the RPMs for libpq.so.4 and libpq.so.3 can't coexist.

Ok, I got lots of complaints about this. I will work on this today and
announce new sets.

Regards,
--
Devrim GÜNDÜZ
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
Managed Services, Shared and Dedicated Hosting
Co-Authors: plPHP, ODBCng - http://www.commandprompt.com/

On 4/11/07, Devrim GÜNDÜZ <devrim(at)commandprompt(dot)com> wrote:
> On Fri, 2007-03-02 at 09:17 -0800, John R Pierce wrote:
> > looks like the RPMs for libpq.so.4 and libpq.so.3 can't coexist.
>
> Ok, I got lots of complaints about this. I will work on this today and
> announce new sets.

It's not a real problem IMHO. AFAIR the compat RPMs were designed to
provide a compatibility layer between newer versions of PostgreSQL and
the distribution standard packages and you won't have both libpq
versions used by the distro.

It's probably easy to fix it but I don't think it's so important. At
least it doesn't prevent anyone to have a working system.

--
Guillaume

Guillaume Smet wrote:
> On 4/11/07, Devrim GÜNDÜZ <devrim(at)commandprompt(dot)com> wrote:
>> On Fri, 2007-03-02 at 09:17 -0800, John R Pierce wrote:
>> > looks like the RPMs for libpq.so.4 and libpq.so.3 can't coexist.
>>
>> Ok, I got lots of complaints about this. I will work on this today and
>> announce new sets.
>
> It's not a real problem IMHO. AFAIR the compat RPMs were designed to
> provide a compatibility layer between newer versions of PostgreSQL and
> the distribution standard packages and you won't have both libpq
> versions used by the distro.
>
> It's probably easy to fix it but I don't think it's so important. At
> least it doesn't prevent anyone to have a working system.

well, it makes it VERY hard to install 8.2.3 on a RHEL4/CentOS4 system
that also has, say, RH's build of Apache + PHP + PG access, as thats
linked to the -3 libraries

you get into rpm hell very fast going down that path.

Hi,

On Wed, 2007-04-11 at 01:10 -0700, John R Pierce wrote:

> well, it makes it VERY hard to install 8.2.3 on a RHEL4/CentOS4 system
> that also has, say, RH's build of Apache + PHP + PG access, as thats
> linked to the -3 libraries

Uh? So installing only compat-3 and PostgreSQL 8.2.3 doesn't work?

Regards,
--
Devrim GÜNDÜZ
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
Managed Services, Shared and Dedicated Hosting
Co-Authors: plPHP, ODBCng - http://www.commandprompt.com/

Devrim GÜNDÜZ wrote:
> Hi,
>
> On Wed, 2007-04-11 at 01:10 -0700, John R Pierce wrote:
>
>
>> well, it makes it VERY hard to install 8.2.3 on a RHEL4/CentOS4 system
>> that also has, say, RH's build of Apache + PHP + PG access, as thats
>> linked to the -3 libraries
>>
>
> Uh? So installing only compat-3 and PostgreSQL 8.2.3 doesn't work?
>

I'll have to try that again on a clean box.

I think what -I- ran into was that there was no compat-3 in the public
repositories, just compat-4... this was about a month ago. devrim
indicated he was going to upload compat-3, and showed me where to find
it, but I'd already installed compat-4, so -3 refused to install.

on the grounds that there are undoutablly software out there which WAS
linked with libpq.so.4, it seems to me there should just be one
compat-postgresql-libs RPM which provides both 3 and 4 and coexists with
current 8.2.3 rpms.

On 4/11/07, John R Pierce <pierce(at)hogranch(dot)com> wrote:
> I think what -I- ran into was that there was no compat-3 in the public
> repositories, just compat-4... this was about a month ago. devrim
> indicated he was going to upload compat-3, and showed me where to find
> it, but I'd already installed compat-4, so -3 refused to install.
>
> on the grounds that there are undoutablly software out there which WAS
> linked with libpq.so.4, it seems to me there should just be one
> compat-postgresql-libs RPM which provides both 3 and 4 and coexists with
> current 8.2.3 rpms.

There's no software linked with libpq.so.4 on standard RHEL 4. They
are all built on libpq.so.3.
IMHO, your problem is that it seems to the RPM database that compat 4
is newer than compat. I think we should have 2 different packages with
different names compat-3 and compat-4.

But you only need the compat package with libpq.so.3 to install 8.1
and 8.2 on RHEL 4.

--
Guillaume

Guillaume Smet wrote:
>
> But you only need the compat package with libpq.so.3 to install 8.1
> and 8.2 on RHEL 4.

but, again, I only see the compat -4 here... no -3.
http://www.postgresql.org/ftp/binary/v8.2.3/linux/rpms/redhat/rhel-es-4/

the 8.2.1 equiv of that path has a comment thats flat wrong too, that
libpq.so.4 shipped with RHEL4...