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 CAFrxt0iqby3sdn1uU56LUtK+9BaJPiX+OS7zij4CuNP+zMdPPg@mail.gmail.com
Whole thread Raw
In response to Re: Incremental backup with RSYNC or something?  (Phoenix Kiula <phoenix.kiula@gmail.com>)
List pgsql-general


On Fri, Nov 18, 2011 at 6:08 AM, Phoenix Kiula <phoenix.kiula@gmail.com> wrote:
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.
It does not depend on number of hosts.

Thanks
VB 

pgsql-general by date:

Previous
From: Scott Marlowe
Date:
Subject: Re: Incremental backup with RSYNC or something?
Next
From:
Date:
Subject: pg_dump error