Search Postgresql Archives

Re: Recover data from aborted transactions

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

 



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.

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux