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.
> On Jun 6, 2020, at 2:24 PM, Vivek Gadge <[hidden email]> 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 instance and then review/extract the data needed. This really should be part of your recovery plan as it is more likely to occur than a full database recovery. Your backup solution is going to dictate how this occurs.