Postgres Pro
Downloads
Home   >   mailing lists

Re: Incremental backup with RSYNC or something? - Mailing list pgsql-general

From Venkat Balaji
Subject Re: Incremental backup with RSYNC or something?
Date
Msg-id CAFrxt0ggzFF1m7WAhCX46VKPaFc_-12trZS6B67-Diy2MLLk1w@mail.gmail.com
Whole thread Raw
In response to Incremental backup with RSYNC or something?  (Phoenix Kiula <phoenix.kiula@gmail.com>)
Responses Re: Incremental backup with RSYNC or something?  (Phoenix Kiula <phoenix.kiula@gmail.com>)
Re: Incremental backup with RSYNC or something?  (Robert Treat <rob@xzilla.net>)
List pgsql-general
Tree view
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

pgsql-general by date:

Previous
From: Amit Dor-Shifer
Date:
Subject: Re: partitioning a dataset + employing hysteresis condition
Next
From: David Johnston
Date:
Subject: Re: partitioning a dataset + employing hysteresis condition