Re: Incremental backup with RSYNC or something?

From: Robert Treat <rob(at)xzilla(dot)net>
To: Venkat Balaji <venkat(dot)balaji(at)verse(dot)in>
Cc: Phoenix Kiula <phoenix(dot)kiula(at)gmail(dot)com>, PG-General Mailing List <pgsql-general(at)postgresql(dot)org>
Subject: Re: Incremental backup with RSYNC or something?
Date: 2011-11-21 01:37:32
Message-ID: CABV9wwPSTmVUrhqZrsY_mKzNxvUdYePqwt+0Paejc0on+JdFXg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Mon, Nov 14, 2011 at 12:45 AM, Venkat Balaji <venkat(dot)balaji(at)verse(dot)in> wrote:
>> Question: what can I do to rsync only the new additions in every table
>> starting 00:00:01 until 23:59:59 for each day?
>
> A table level replication (like Slony) should help here.
> Or
> A trigger based approach with dblink would be an-other (but, a bit complex)
> option.

If you don't actually care about the rows of data specifically, and
just want incremental data diff, you might look at what options your
filesystem gives you. We often use incremental snapshots on ZFS to
give use smaller copies that can be shipped off to the backup server
and used to reconstruct the server if needed.

Robert Treat
conjecture: xzilla.net
consulting: omniti.com

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tomas Vondra 2011-11-21 01:41:18 Re: Huge number of INSERTs
Previous Message Robert Treat 2011-11-21 01:28:38 Re: upgrading from 8.3 to 9.0