Re: Recover data from aborted transactions - Mailing list pgsql-general

From Aaron Spike
Subject Re: Recover data from aborted transactions
Date
Msg-id CABcA21Q818v8oh+eZLp5bKL0+dcji51KynBpVyW8aW=MGtvOug@mail.gmail.com
Whole thread Raw
In response to Re: Recover data from aborted transactions  (Luca Ferrari <fluca1978@gmail.com>)
List pgsql-general
I don't remember exactly what I read to get this idea. Perhaps it was this particular presentation slide:

The great news is that it must. Some of the helpful folks on IRC introduced me to two different methods of retrieving the information I was looking for from my backups. I tested both and they worked excellently.

Using pg_filedump I was able to find the records in the raw files on disk:
And with the pg_dirtyread extension I was able to have access to the records from the running database server:



This electronic communication, including any attached documents, may contain confidential and/or legally privileged information that is intended only for use by the recipient(s) named above. If you have received this communication in error, please notify the sender immediately and delete the communication and any attachments. Views expressed by the author do not necessarily represent those of Martin Luther College.

pgsql-general by date:

Previous
From: "Peter J. Holzer"
Date:
Subject: Re: Strange Behaviour with multicolumn indexes
Next
From: Ron
Date:
Subject: Re: Referncing a calculated column in a select?