RPMs for RedHat ES3.0

Hi,

On Mon, 3 Oct 2005, Philip Yarra wrote:

Devrim, I had some problems installing on RedHat ES3.0 with the RPMs. This
issue turned out to be that I needed the compat libs to provide the old libs
before I could install the new libs.

I found a link to
http://developer.PostgreSQL.org/~devrim/compat-postgresql-libs-3-3PGDG.i686.rpm
in an archived post from -hackers. It wasn't all that obvious what was
required though, so is it possible that this RPM could actually be put with
the downloads for the main RPMs? I'm not sure anyone's installation would
succeed without that RPM on RedHat ES3.0. Please let me know if I'm missing
something.

We haven't discussed it before, but I think we can't put the RPM among
PGDG RPMs. The main reason is that this is not a piece of software that's
included within that release of PostgreSQL. Also, this compat RPM is not
needed if you don't have a software that needs that RPM.

As an aside: is it possible to actually to just include the contents of
compat-libs in postgresql-libs, since they actually seem to be required? It'd
save me some hassles for future installations. Probably other folks too.

As I wrote above, it does not seem possible.

Also remember that this will be probably 'solved' in RHEL 5 (and FC 5), so
merging compat with main libs package is not a good idea.

Regards,
--
Devrim GUNDUZ
Kivi Bili�im Teknolojileri - http://www.kivi.com.tr
devrim~gunduz.org, devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr
http://www.gunduz.org

From pgsql-hackers-owner@postgresql.org Mon Oct 3 15:20:40 2005

X-Original-To: pgsql-hackers-postgresql.org@localhost.postgresql.org
Received: from localhost (av.hub.org [200.46.204.144])
by svr1.postgresql.org (Postfix) with ESMTP id 6F71CD9E86
for <pgsql-hackers-postgresql.org@localhost.postgresql.org>; Mon, 3 Oct 2005 15:20:38 -0300 (ADT)
Received: from svr1.postgresql.org ([200.46.204.71])
by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024)
with ESMTP id 90702-06
for <pgsql-hackers-postgresql.org@localhost.postgresql.org>;
Mon, 3 Oct 2005 18:20:33 +0000 (GMT)
Received: from rodrick.geeknet.com.au (ns1.geeknet.com.au [220.244.63.182])
by svr1.postgresql.org (Postfix) with ESMTP id 6C9D3D9EA9
for <pgsql-hackers@postgresql.org>; Mon, 3 Oct 2005 15:20:26 -0300 (ADT)
Subject: Re: PG Killed by OOM Condition
MIME-Version: 1.0
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
Date: Tue, 4 Oct 2005 04:20:25 +1000
Content-class: urn:content-classes:message
X-MimeOLE: Produced By Microsoft Exchange V6.5.6944.0
Message-ID: <5066E5A966339E42AA04BA10BA706AE50A939D@rodrick.geeknet.com.au>
X-MS-Has-Attach:
X-MS-TNEF-Correlator:
Thread-Topic: [HACKERS] PG Killed by OOM Condition
Thread-Index: AcXIJQLbLdava9XhTOCyTO9M9lzjjgAIGulQ
From: "John Hansen" <john@geeknet.com.au>
To: "Tom Lane" <tgl@sss.pgh.pa.us>
Cc: <pgsql-hackers@postgresql.org>
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, hits=0.016 required=5 tests=[AWL=0.016]
X-Spam-Level:
X-Archive-Number: 200510/106
X-Sequence-Number: 73965

Tom Lane Wrote:

(a) wouldn't that require root privilege? (b) how would we=20
determine whether we are on a system to which this applies? =20
(c) is it actually documented in a way that makes you think=20
it'll be a permanently supported feature (ie, somewhere=20
outside the source code)?

(a) No, /proc/{pid}/* is owned by the process
(b) /proc/{pid}/oom_adj exists ?
(c) No, from the source: (not docbooked, we don't want this one
cluttering up the manual)

... John

Hi Devrim, thanks for the quick response.

We haven't discussed it before, but I think we can't put the RPM among
PGDG RPMs. The main reason is that this is not a piece of software that's
included within that release of PostgreSQL. Also, this compat RPM is not
needed if you don't have a software that needs that RPM.

Have a look at my original post: I was unable to install any of the PGDG RPMs
as they have a dependency on the contents of the compat RPM. E.g.:

[root@dev2 8.x]# rpm -i postgresql-libs-8.0.3-1PGDG.i686.rpm
error: Failed dependencies:
libecpg.so.4 is needed by postgresql-libs-8.0.3-1PGDG
libpgtypes.so.1 is needed by postgresql-libs-8.0.3-1PGDG
libpq.so.3 is needed by postgresql-libs-8.0.3-1PGDG

Once I installed the compat RPM, I could then install
postgresql-libs-8.0.3-1PGDG. So the software that needs the compat RPM is the
PGDG RPMs.

Please tell me if I have missed something here, I'm not claiming any great
insight, just what rpm seems to be telling me, and what worked to get me
through the installation.

Also remember that this will be probably 'solved' in RHEL 5 (and FC 5), so
merging compat with main libs package is not a good idea.

Our clients are still on ES3.0, then they *might* migrate to 4.0 one day.
RHEL5 is a long way off for us, I assure you :-) so I'm happy to lend any
help I can to resolve this issue for ES3.0.

I don't quite understand how the compat libs can be counted as "not part of
this release" if the release packages require it. Is it maybe just an issue
with rpm creating automatic dependiencies for those .so files? (sorry, this
is me at my vaguest, rpm is something of an unknown to me, but I suspect I'm
about to learn).

Regards, Philip.

-----------------
Utiba Pty Ltd
This message has been scanned for viruses and
dangerous content by Utiba mail server and is
believed to be clean.

Philip Yarra <philip@utiba.com> writes:

Have a look at my original post: I was unable to install any of the PGDG RPMs
as they have a dependency on the contents of the compat RPM. E.g.:

[root@dev2 8.x]# rpm -i postgresql-libs-8.0.3-1PGDG.i686.rpm
error: Failed dependencies:
libecpg.so.4 is needed by postgresql-libs-8.0.3-1PGDG
libpgtypes.so.1 is needed by postgresql-libs-8.0.3-1PGDG
libpq.so.3 is needed by postgresql-libs-8.0.3-1PGDG

I think there's no question that this represents an RPM-building error.
We haven't entirely figured out what's causing it though.

regards, tom lane

Hi Tom,

On Tue, 4 Oct 2005 11:36 am, Tom Lane wrote:

I think there's no question that this represents an RPM-building error.
We haven't entirely figured out what's causing it though.

Right, gotcha. I think this may be the issue:
[root@dev2 8.x]# rpm -ql postgresql-libs-8.0.3-1PGDG
[snip]
/usr/lib/libecpg_compat.so.2
[snip]

[root@dev2 8.x]# ldd /usr/lib/libecpg_compat.so.2
libecpg.so.4 => /usr/lib/libecpg.so.4 (0x007ba000)
libpgtypes.so.1 => /usr/lib/libpgtypes.so.1 (0x00e0e000)
libpq.so.3 => /usr/lib/libpq.so.3 (0x00efa000)

[root@dev2 8.x]# rpm -q --whatprovides /usr/lib/libpq.so.3
compat-postgresql-libs-3-3PGDG

Including /usr/lib/libecpg_compat.so.2 in postgresql-libs-8.0.3-1PGDG causes
automatic dependency
(http://www.rpm.org/max-rpm/s1-rpm-depend-auto-depend.html) on those .so
files which are only included in compat RPM.

Regards, Philip.

-----------------
Utiba Pty Ltd
This message has been scanned for viruses and
dangerous content by Utiba mail server and is
believed to be clean.