Re: PostgreSQL backup idea - Mailing list pgsql-admin

From Scott Mead
Subject Re: PostgreSQL backup idea
Date
Msg-id d3ab2ec81001200353i7c59aa3bx2d05b49a1dd26baa@mail.gmail.com
Whole thread Raw
In response to Re: PostgreSQL backup idea  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
List pgsql-admin

On Wed, Jan 20, 2010 at 6:48 AM, Kevin Grittner <Kevin.Grittner@wicourts.gov> wrote:
Renato Oliveira  wrote:

> I can't implement PITR right now on our live systems, for
> commercial reasons.

What do you mean?  Most of your email seems to describe techniques
very much like PITR; why would that be OK but the existing, tested
PITR not be OK?  It's hard to know what to suggest without
understanding the answers to those questions.

 PITR is a one or two line update to the postgresql.conf + a base backup.  What you're talking about is trying to build your own version of this (significantly more complex).  What are the 'commercial' reasons that you have for not using PITR, ISTM that you'd really be wasting time not using it.

--Scott 

pgsql-admin by date:

Previous
From: "Kevin Grittner"
Date:
Subject: Re: PostgreSQL backup idea
Next
From: "David F. Skoll"
Date:
Subject: Warm standby problems: SOLVED