Re: Syncing Databases Weekly

Поиск
Список
Период
Сортировка
От Joshua D. Drake
Тема Re: Syncing Databases Weekly
Дата
Msg-id 43E8F078.8090402@commandprompt.com
обсуждение исходный текст
Ответ на Re: Syncing Databases Weekly  (Brad Nicholson <bnichols@ca.afilias.info>)
Список 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 по дате отправления:

Предыдущее
От: Brad Nicholson
Дата:
Сообщение: Re: Syncing Databases Weekly
Следующее
От: jao@geophile.com
Дата:
Сообщение: B-tree performance improvements in 8.x