Re: Syncing Databases Weekly

Поиск
Список
Период
Сортировка
От Richard Huxton
Тема Re: Syncing Databases Weekly
Дата
Msg-id 43E8D6F9.6010105@archonet.com
обсуждение исходный текст
Ответ на Syncing Databases Weekly  ("Benjamin Arai" <barai@cs.ucr.edu>)
Список pgsql-general
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.

PITR (Point In Time Recovery) - details in the manuals and recently
discussed on one of the lists.

--
   Richard Huxton
   Archonet Ltd

В списке pgsql-general по дате отправления:

Предыдущее
От: Nikolay Samokhvalov
Дата:
Сообщение: Re: Sequences/defaults and pg_dump
Следующее
От: SCassidy@overlandstorage.com
Дата:
Сообщение: Re: what is the data type for files(.txt,.doc,.jpeg) in