About 2 years ago a new guy at our company deleted all contents of a table on a development server and I managed to
restore them by changing the XID value with pg_resetxlog.
You can get last chackpoint's XID by running pg_controldata; then use pg_resetxlog -x and try different values. You'll
need to repeat the "copy from backup - change XID - start postmaster" cycle a few times; but it should be doable in less
than an hour.
Regards,
Aleksander
Jim Nasby wrote:
Your best bet on something like this is probably going to be contacting
a company that does PostgreSQL support and inquiring about data
recovery. EnterpriseDB and Command Prompt both employ folks who could
probably accomplish this; I think OmniTI might as well. There's probably
a few others.
On Jun 12, 2007, at 11:19 AM, zz_11@xxxxxxx wrote:
No, I do not have WAL archiving.
I hope some one have done the hacking in postmaster.
If no one have done this, my idea was to change the vacuum
(or make e new copy).
I am not familiar with pg code, but as I know by running
vacuum, pg marks deleted records as free, and my idea was to
mark this records as real record in the database (if it is
possible).
regards,
ivan.
