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
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 |