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 ?)