Re: Replication and PITR

Поиск
Список
Период
Сортировка
От Bo Lorentsen
Тема Re: Replication and PITR
Дата
Msg-id 451378DE.9090307@netgroup.dk
обсуждение исходный текст
Ответ на Re: Replication and PITR  (Bill Moran <wmoran@collaborativefusion.com>)
Ответы Re: Replication and PITR
Список pgsql-general
Bill Moran wrote:
> - No reliability.  On slow days, WAL logs could take a long time to
>   rotate, so small but important transactions might not be replicated
>   for a long time.
>
So it is all right for backup but for replication it could end up laking
too much behind, and a fail over could be hours behind.

So PITR can be used, but one of the cons is the unpredictable delay of
data. I thought one of the ideas behind the PITR system was to get
rather reason backups of data ...

/BL


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

Предыдущее
От: "surabhi.ahuja"
Дата:
Сообщение: ERROR: index "patient_pkey" is not a btree
Следующее
От: Bo Lorentsen
Дата:
Сообщение: Re: Replication and PITR