Thread: PostgreSQL Concern Regarding PITR.
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 ?
Thanks & Regrads
Vivek Gadge.
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.
On Sat, Jun 6, 2020, 10:51 PM 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 ?
For versions 11 and 12, look at the docs on logical replication, publications and subscriptions. Also search for change data capture (CDC) for examples on how to use.
-Greg
> On Jun 6, 2020, at 2:24 PM, 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 . > Very common restore situation. To accomplish it; you need the ability to a restore and instantiate an out of band instanceand then review/extract the data needed. This really should be part of your recovery plan as it is more likely tooccur than a full database recovery. Your backup solution is going to dictate how this occurs.