Re: Syncing Databases Weekly - Mailing list pgsql-general

From Joshua D. Drake
Subject Re: Syncing Databases Weekly
Date
Msg-id 43E8F078.8090402@commandprompt.com
Whole thread Raw
In response to Re: Syncing Databases Weekly  (Brad Nicholson <bnichols@ca.afilias.info>)
List pgsql-general
Brad Nicholson wrote:

> Joshua D. Drake wrote:
>
>> Benjamin Arai wrote:
>>
>>> Hi,
>>>
>>> I am familiar with applications like slony for replications, I am
>>> looking for a technique for syncing a very large database every week
>>> for backup and redundancy purposes.  More specifically, I do all my
>>> writes to a main server once a week, at the end of the updates I
>>> would like to automatically copy all of the data to a second server
>>> as a live backup in case the main system ever goes down.
>>
>>
>>
>> You could use batch replication via Mammoth Replicator or PITR.
>>
> Slony's log shipping is another option.

Oh cool... I didn't know Slony could do that. Glad to hear it.

>
>


pgsql-general by date:

Previous
From: Brad Nicholson
Date:
Subject: Re: Syncing Databases Weekly
Next
From: jao@geophile.com
Date:
Subject: B-tree performance improvements in 8.x