I'm using compat-postgresql-libs-4-1PGDG.rhel5.x86_64.rpm on CentOS 5 in 64bit mode.
The package did not create a libpq.so.4 link in /usr/lib64/, which caused Apache to fail.
Regards,Kevin Murphy