Re: pg_dump, shemas, backup strategy - Mailing list pgsql-general

From Greg Smith
Subject Re: pg_dump, shemas, backup strategy
Date
Msg-id 4C4B6441.7070506@2ndquadrant.com
Whole thread Raw
In response to Re: pg_dump, shemas, backup strategy  ("Michael A. Peters" <mpeters@shastaherps.org>)
Responses Re: pg_dump, shemas, backup strategy  ("Michael A. Peters" <mpeters@shastaherps.org>)
List pgsql-general
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


pgsql-general by date:

Previous
From: "Michael A. Peters"
Date:
Subject: Re: pg_dump, shemas, backup strategy
Next
From: Tom Lane
Date:
Subject: Re: pg_dump, shemas, backup strategy