[nycbug-talk] postgres incremental backups?

[Bob Ippolito]

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 [1]. 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?

[1] http://slony.info/

-bob