From: | Aaron Spike <spikeac(at)mlc-wels(dot)edu> |
---|---|
To: | Luca Ferrari <fluca1978(at)gmail(dot)com> |
Cc: | pgsql-general <pgsql-general(at)lists(dot)postgresql(dot)org> |
Subject: | Re: Recover data from aborted transactions |
Date: | 2019-09-12 20:03:25 |
Message-ID: | CABcA21Q818v8oh+eZLp5bKL0+dcji51KynBpVyW8aW=MGtvOug@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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 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:
https://git.postgresql.org/gitweb/?p=pg_filedump.git
And with the pg_dirtyread extension I was able to have access to the
records from the running database server:
https://github.com/df7cb/pg_dirtyread
--
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.
From | Date | Subject | |
---|---|---|---|
Next Message | Ron | 2019-09-12 20:35:56 | Re: Referncing a calculated column in a select? |
Previous Message | Peter J. Holzer | 2019-09-12 19:56:22 | Re: Strange Behaviour with multicolumn indexes |