TERENYI Balazs wrote:
> Hi!
>
> How can I make pg_xlog files human readable? I have forgotten to switch on
> the debug_print_query option and somehow rows were deleted from a
> database. I don't know how.
You can't, really. If you haven't vacuumed, you can modify tqual.c,
function HeapTupleSatisfiesSnapshot() to always return true, recompile
and install that binary, and a SELECT will then show all the rows.
Make a backup first, and be sure you use that modified binary only for
during recovery.
--
Bruce Momjian | http://candle.pha.pa.us
pgman@candle.pha.pa.us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026