pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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.
>>



view thread (5+ messages)

Message-ID: <4677C02B.8090607@intera.si>
Permalink:  ../4677C02B.8090607@intera.si/
Also on:    postgresql.org/message-id/4677C02B.8090607@intera.si

 · 

reply

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