Re: Incremental backup with RSYNC or something?

From: Venkat Balaji <venkat(dot)balaji(at)verse(dot)in>
To: Phoenix Kiula <phoenix(dot)kiula(at)gmail(dot)com>
Cc: PG-General Mailing List <pgsql-general(at)postgresql(dot)org>
Subject: Re: Incremental backup with RSYNC or something?
Date: 2011-11-14 05:45:07
Message-ID: CAFrxt0ggzFF1m7WAhCX46VKPaFc_-12trZS6B67-Diy2MLLk1w@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Thanks
VB

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message David Johnston 2011-11-14 06:05:21 Re: partitioning a dataset + employing hysteresis condition
Previous Message Amit Dor-Shifer 2011-11-14 05:35:37 Re: partitioning a dataset + employing hysteresis condition