Michael A. Peters wrote:
> I already maintain my own php RPMs because RHEL php is too old (I need
> the DOMDocument stuff) so maybe I need to add Postgresql to that.
>
Note that you don't even have to build them yourself; the set at
https://public.commandprompt.com/projects/pgcore/wiki/ are a
straightforward drop-in replacement for the ones that RedHat provides.
Subscribe to that yum repo just for the postgresql* packages and you can
easily run 8.3 or 8.4 instead of the system 8.1. You might need to
recompile your custom PHP against that afterwards, but you shouldn't
have to build the database itself completely from source. And you'll
still get security updates and bug fix point upgrades from that yum
repo, continuing after the ones for 8.1 slow down.
I've already started playing with the beta for RHEL6 just to avoid this
whole stale package mess for a number of things. Will be nice when that
ships, and the cycle of enterprise releases from them starts over with
up to date packages again.
--
Greg Smith 2ndQuadrant US Baltimore, MD
PostgreSQL Training, Services and Support
greg@2ndQuadrant.com www.2ndQuadrant.us