Is using Transaction XID or LSN the more accurate and precise way to perform PITR?
3
votes
1
answer
164
views
I am practising Point in Time Recovery (PITR) on PostgreSQL 13 against accidental data deletion. Since PostgreSQL offers multiple parameters to perform PITR, I am bit confused choosing between Transaction XID and LSN.
If an accidental
DELETE
statement removed a large number of rows, and I obtained the corresponding XID
and starting LSN
from the WAL dump, would performing PITR yield the same result regardless of whether I use the XID or LSN?
Is there a risk of losing other committed transactions if I restore using the XID?
Asked by goodfella
(595 rep)
Feb 13, 2025, 08:28 AM
Last activity: Feb 13, 2025, 09:41 AM
Last activity: Feb 13, 2025, 09:41 AM