Re: Recover data from aborted transactions

Поиск
Список
Период
Сортировка
От Aaron Spike
Тема Re: Recover data from aborted transactions
Дата
Msg-id CABcA21Q818v8oh+eZLp5bKL0+dcji51KynBpVyW8aW=MGtvOug@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Recover data from aborted transactions  (Luca Ferrari <fluca1978@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: "Peter J. Holzer"
Дата:
Сообщение: Re: Strange Behaviour with multicolumn indexes
Следующее
От: Ron
Дата:
Сообщение: Re: Referncing a calculated column in a select?