Re: [GENERAL] Incremental / Level -1 backup in PG

Поиск
Список
Период
Сортировка
От rakeshkumar464
Тема Re: [GENERAL] Incremental / Level -1 backup in PG
Дата
Msg-id 1490172570150-5951148.post@n3.nabble.com
обсуждение исходный текст
Ответ на Re: [GENERAL] Incremental / Level -1 backup in PG  (Stephen Frost <sfrost@snowman.net>)
Ответы Re: [GENERAL] Incremental / Level -1 backup in PG
Список pgsql-general
Greetings,

>The short answer is 'no'.  There are complications around this,
>particularly at the edges and because files can be written and rewritten
>as you're reading them.
>Basically, no file with a timestamp after the
>checkpoint before the backup can be omitted from an incremental backup.

what you have written above applies to oracle/db2 too.  In case you are not
aware, during backup, those products have a mechanism to save the image
of any changing block as it existed before the start of the backup. that is
used
to reconstruct the PIT image of the block.

Anyhow looks like this can't be done in PG.

thanks all.






--
View this message in context: http://www.postgresql-archive.org/Incremental-Level-1-backup-in-PG-tp5951072p5951148.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.


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

Предыдущее
От: rakeshkumar464
Дата:
Сообщение: Re: [GENERAL] Incremental / Level -1 backup in PG
Следующее
От: Francisco Olarte
Дата:
Сообщение: Re: [GENERAL] Incremental / Level -1 backup in PG