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@mail.bg 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.
>>