Обсуждение: 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@hogranch.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=C3=9CND=C3=9CZ wrote: > Hi, > > On Thu, 2007-03-01 at 18:23 -0800, John R Pierce wrote: >=20=20=20 >> (or, there should be a compat-postgresql-libs-3 ?)=20 >>=20=20=20=20=20 > > Hmm.=20 > > 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. >=20=20=20 ah! I think thats a good thing. I did not know where to look for this. thanks, all!
Devrim G=C3=9CND=C3=9CZ wrote:
> Hi,
>
> On Thu, 2007-03-01 at 18:23 -0800, John R Pierce wrote:
>=20=20=20
>> (or, there should be a compat-postgresql-libs-3 ?)=20
>>=20=20=20=20=20
>
> Hmm.=20
>
> 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,
>=20=20=20
hmmmm.
Preparing... ###########################################=20
[100%]
package compat-postgresql-libs-4-2PGDG.rhel4 (which is newer=20
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=20
05:05:19 AM PST
Install Date: Thu 01 Mar 2007 06:14:38 PM PST Build Host:=20
web.sanalotogar.com
Group : Applications/Databases Source RPM:=20
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 >=3D 8.0.2 and PostgreSQL <=3D8.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:=20
NOKEY, key ID 748f7d0e
Name : compat-postgresql-libs Relocations: (not relocatable)
Version : 3 Vendor: (none)
Release : 3PGDG Build Date: Tue 31 May 2005=20
05:33:59 AM PDT
Install Date: (not installed) Build Host: tdm.com.tr
Group : Applications/Databases/Interfaces Source RPM:=20
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=20
b65f3a3f748f7d0e
Packager : Devrim GUNDUZ <devrim@PostgreSQL.org>
URL : http://www.postgresql.org/
Summary : PostgreSQL client programs and libraries.
Description :
This package provides compatibility libraries for PostgreSQL >=3D 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=DCND=DCZ <devrim@commandprompt.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
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/
On 4/11/07, John R Pierce <pierce@hogranch.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...
Devrim G=C3=9CND=C3=9CZ wrote: > Hi, > > On Wed, 2007-04-11 at 01:10 -0700, John R Pierce wrote: > >=20=20=20 >> 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 >>=20=20=20=20=20 > > Uh? So installing only compat-3 and PostgreSQL 8.2.3 doesn't work? >=20=20=20 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=20 repositories, just compat-4... this was about a month ago. devrim=20 indicated he was going to upload compat-3, and showed me where to find=20 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=20 linked with libpq.so.4, it seems to me there should just be one=20 compat-postgresql-libs RPM which provides both 3 and 4 and coexists with=20 current 8.2.3 rpms.
Guillaume Smet wrote: > On 4/11/07, Devrim G=DCND=DCZ <devrim@commandprompt.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=20 that also has, say, RH's build of Apache + PHP + PG access, as thats=20 linked to the -3 libraries you get into rpm hell very fast going down that path.