Re: [GENERAL] Incremental / Level -1 backup in PG - Mailing list pgsql-general

From rakeshkumar464
Subject Re: [GENERAL] Incremental / Level -1 backup in PG
Date
Msg-id 1490172570150-5951148.post@n3.nabble.com
Whole thread Raw
In response to Re: [GENERAL] Incremental / Level -1 backup in PG  (Stephen Frost <sfrost@snowman.net>)
Responses Re: [GENERAL] Incremental / Level -1 backup in PG  (Stephen Frost <sfrost@snowman.net>)
List 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 by date:

Previous
From: rakeshkumar464
Date:
Subject: Re: [GENERAL] Incremental / Level -1 backup in PG
Next
From: Francisco Olarte
Date:
Subject: Re: [GENERAL] Incremental / Level -1 backup in PG