Re: Incremental backup with RSYNC or something?

From: Phoenix Kiula <phoenix(dot)kiula(at)gmail(dot)com>
To: Venkat Balaji <venkat(dot)balaji(at)verse(dot)in>
Cc: PG-General Mailing List <pgsql-general(at)postgresql(dot)org>
Subject: Re: Incremental backup with RSYNC or something?
Date: 2011-11-18 00:38:54
Message-ID: CAFWfU=s3Em2K=1EuB0d+pt5SWDzOUxQpOjALApMscBUGK4k6Gw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Mon, Nov 14, 2011 at 1:45 PM, 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.

Slony needs more than one physical server, right?

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Phoenix Kiula 2011-11-18 00:44:27 Huge number of INSERTs
Previous Message Adrian Klaver 2011-11-18 00:33:37 Re: Authentication configuration for local connections on Windows