I don't remember exactly what I read to get this idea. Perhaps it was this
particular presentation slide:
https://www.slideshare.net/pgdayasia/postgresql-wal-for-dbas/15
The great news is that it must. Some of the helpful folks on IRC introduced
me to two different methods of retrieving the inform
On Tue, Sep 10, 2019 at 7:18 PM Aaron Spike wrote:
> I'm pretty sure that the records I'm looking for are part of one of these
> aborted transactions. From what I read online, it seems that data from
> uncommitted transactions exists in the Write-Ahead Logs. Is there anyway to
> access this dat
I've used PITR on a number of occasions to look back at old data and
recover deleted records. Recently while searching for a missing record I
ran across the following line in the output of pg_xlogdump:
rmgr: Transaction len (rec/tot):200/ 226, tx: 26025438, lsn:
> 127/9166CF18, prev 127/91
