You should talk to Lamar Owen, who has done the RedHat RPMs for Postgres. At one time, he was talking about setting stuff up to run out of the box, so to speak, much as has been done for the Debian "Potato" release.
(for that matter, you might want to grab the Debian release - I think "Potato" is out now - and see how well it works, I'm sure the guy who did it would like feedback).
Another route would be for us to provide RPMs of versions of stuff we know works, including PG compiled for a 16KB blocksize and --with-tcl enabled, the AOLserver driver, etc, rather than depend upon RPMs released with RH (the Postgres RPM in particular).
