From: Aleksander Kmetec - INTERA <aleksander.kmetec@intera.si>
To: Jim Nasby <decibel@decibel.org>
Cc: zz_11@mail.bg
Cc: pgsql-admin@postgresql.org
Subject: Re: How to restore updated records
Date: Tue, 19 Jun 2007 13:38:19 +0200
Message-ID: <4677C02B.8090607@intera.si> (raw)
In-Reply-To: <963E8496-D890-419B-B71A-773B4DBA1BDB@decibel.org>
References: <1181583306.d9d10231a3c6c@mail.bg>
<A5AC26D2F3B3CB42A3BCB88965C9343902D787CD@sv-7.intern.rossmann.de>
<1181665149.b014150a4b253@mail.bg>
<963E8496-D890-419B-B71A-773B4DBA1BDB@decibel.org>
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.
>>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: aleksander.kmetec@intera.si, decibel@decibel.org, zz_11@mail.bg
Subject: Re: How to restore updated records
In-Reply-To: <4677C02B.8090607@intera.si>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox