Thread: libpq dependencies

I have been using PostgreSQL 8.2.3 under Redhat Enterprise Linux AS 4, but
when I tried to install the postgresql-plperl RPM I got a sequence of
dependency failures, and remedying them got me into an apparently infinite
loop of dependencies on libpq.so versions. I had versions 3 and 4 in
/usr/lib and version 5 in /usr/local/pgsql/lib, but posgresql-libs still
reported it needed version 3 and couldn't find it. So I installed
compat-postgresql-libs-3-3PGDG and tried again. Now postgresql-libs
complains it can't find version 4.

I haven't found any comprehensive guide to shared library problems
associated with PostgreSQL, and it's a shame, since everything else about
PostgreSQL seems excellently documented.

I've given up, and decided to return to Redhat's somewhat older version.
It installs itself from Red Hat Network without any errors, and I probably
won't get library incompatibilities when doing future updates.

> I have been using PostgreSQL 8.2.3 under Redhat Enterprise Linux AS 4, but
> when I tried to install the postgresql-plperl RPM I got a sequence of
> dependency failures, and remedying them got me into an apparently infinite
> loop of dependencies on libpq.so versions.

Try grabbing all the PostgreSQL RPMS for 8.2.3/RHEL AS4 from
http://www.postgresql.org/ftp/binary/v8.2.3/linux/rpms/redhat/rhel-as-4/
(there's also directories for Itanium 64 and x86 64, so know what
processor type you're using and adjust as needed).

Often RPM dependency confusions can be got around through
specifying more than one .rpm at once.

Also try upgrading with rpm -Uvh rather than rpm -i

So if you grab the RPMS you need from there and install them all at once,
you should be fine.

Good luck,
Stuart.