On Mon, Nov 14, 2011 at 1:45 PM, Venkat Balaji <venkat.balaji@verse.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.
Slony needs more than one physical server, right?
Not necessarily, you can replicate with-in the same host as well. It all depends on which tables you want to replicate.