[nycbug-talk] postgres incremental backups?
bob at redivi.com
Thu Aug 24 18:55:04 EDT 2006
On 8/24/06, Peter Wright <pete at nomadlogic.org> wrote:
> Hi All,
> I have a postgres 7.4.x database which we will be using for a data
> warehousing project. We project the initial database clusters will be in
> the ~200-300gig range (served from a NetApp volume). As I mentioned we
> are using release 7.4, as we have experienced stability problems with 8.x
> in some specific circumstances. Is there a good way to do incremental
> backups of pgsql db's that does not require taking the database down? I
> guess I am looking for something similar to PITR (point in time recovery)
> for 7.4.x. What are other folks out there using?
The only thing I can think of is Slony-I . It should cover all of
your needs and give you a safe online way to replicate your cluster to
some future 8.1.x or 8.2 when the time comes.
Out of curiosity, what kind of stability problems are you referring to?
More information about the talk