Re: PG_XLOG

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