| From: | rakeshkumar464 <rakeshkumar464(at)outlook(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Incremental / Level -1 backup in PG |
| Date: | 2017-03-22 08:49:30 |
| Message-ID: | 1490172570150-5951148.post@n3.nabble.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Francisco Olarte | 2017-03-22 10:30:04 | Re: Incremental / Level -1 backup in PG |
| Previous Message | rakeshkumar464 | 2017-03-22 08:40:49 | Re: Incremental / Level -1 backup in PG |