Postgres Pro
Downloads
Home   >   mailing lists

Re: PostgreSQL Concern Regarding PITR. - Mailing list pgsql-admin

From David G. Johnston
Subject Re: PostgreSQL Concern Regarding PITR.
Date
Msg-id CAKFQuwbJC3OEcCR6hAifFoHbwo2+THs7RtaHnd2=KK-i5qo0fg@mail.gmail.com
Whole thread Raw
In response to PostgreSQL Concern Regarding PITR.  (Vivek Gadge <vvkgadge56@gmail.com>)
List pgsql-admin
Tree view
On Saturday, June 6, 2020, Vivek Gadge <vvkgadge56@gmail.com> wrote:
Is it possible to perform the table level PITR in postgresql version 9.6 or 10, if yes could u plz assist .

If no ,then is there any facilities/utilities provided in upgraded postgresql versions like 11 or 12 

No, WAL interleaves all data in the cluster, PITR simply stops WAL replay.  PITR will not produce a corrupted database cluster.  You have to PITR the whole thing then pull out the table from the restored version.

David J.

pgsql-admin by date:

Previous
From: Vivek Gadge
Date:
Subject: PostgreSQL Concern Regarding PITR.
Next
From: Greg Spiegelberg
Date:
Subject: Re: PostgreSQL Concern Regarding PITR.