From the postgresql site:
- Fedora Core 5, Fedora Core 6, Red Hat Enterprise Linux 4 and Red Hat Enterprise Linux 5 ship with libpq.so.4. Any apps that are built against libpq need this, like php-pgsql, However, since PostgreSQL 8.2 ships with libpq.so.5, users will need old libs in order not to break apps.
However this rpm seems to be missing from the official mirrors so I built an rpm from the source RPM. Then I could do:
# yum localinstall postgresql-8.2.4-1PGDG.i686.rpm \ postgresql-devel-8.2.4-1PGDG.i686.rpm \ postgresql-libs-8.2.4-1PGDG.i686.rpm \ postgresql-server-8.2.4-1PGDG.i686.rpm \ compat-postgresql-libs-4-2PGDG.fc6.i386.rpm