From: Bruno Wolff III <bruno@wolff.to>
To: CoL <col@mportal.hu>
Cc: pgsql-sql@postgresql.org
Subject: Re: Restore deleted records
Date: Wed, 27 Aug 2003 07:36:01 -0500
Message-ID: <20030827123601.GB25066@wolff.to> (raw)
In-Reply-To: <bige7p$1luk$1@news.hub.org>
References: <004f01c36bb5$9a962690$f801010a@esir.ru>
<bige7p$1luk$1@news.hub.org>
> Konstantin Petrenko wrote, On 8/26/2003 11:37 AM:
>
> >Hello.
> >
> >I accidentally deleted some recordes from my table. How can I restore
> >them? Is it possible in 7.3.3?
> if you have a dump, or you are still in a transaction, you can rollback.
I avoided responding earlier, hoping you could get some more detailed help.
Besides recovering from backup (or not committing the transaction if by
some chance you haven't already) you can probably get back data from the
deleted rows if you haven't run a vacuum since committing the delete.
I don't know the specifics of how to do this, but the initial step will
be to shut the database cluster down and make a copy of it before running
vacuum. Once vacuum has been run, the old tuples will start being written
over and you won't have a reliable way to recover the data. If you have
alrerady done a vacuum full, you probably won't be able to much of anything
back.
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-sql@postgresql.org
Cc: bruno@wolff.to, col@mportal.hu
Subject: Re: Restore deleted records
In-Reply-To: <20030827123601.GB25066@wolff.to>
* 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