Re: PostgreSQL Concern Regarding PITR.

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Saturday, June 6, 2020, Vivek Gadge <vvkgadge56@xxxxxxxxx> 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.


[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux