From jane@mistral.ru Sat Mar  20 14:31:24 1999
Received: from cit-u.citmgu.ru (cit-u.citmgu.ru [194.85.135.66])
	by hub.org (8.9.2/8.9.1) with ESMTP id JAA01382
	for <pgsql-sql@postgresql.org>; Sat, 20 Mar 1999 09:31:24 -0500 (EST)
	(envelope-from jane@mistral.ru)
Received: from mistral.ru (ws13.citmgu.ru [194.85.135.80])
	by cit-u.citmgu.ru (8.8.8/8.8.8) with ESMTP id RAA10727
	for <pgsql-sql@postgresql.org>; Sat, 20 Mar 1999 17:37:14 +0300 (MSK)
	(envelope-from jane@mistral.ru)
Message-ID: <36F3B45E.73BDDD9@mistral.ru>
Date: Sat, 20 Mar 1999 17:44:47 +0300
From: Eugenia Bulakh <jane@mistral.ru>
Organization: CIT
X-Mailer: Mozilla 4.04 [en] (WinNT; I)
MIME-Version: 1.0
To: pgsql-sql@postgresql.org
Subject: [SQL] Restore deleted records
Content-Type: text/plain; charset=koi8-r
Content-Transfer-Encoding: 7bit

Hello.

I accidentally deleted some recordes from my table. How can I restore
them? Is it possible in 6.4.2?
In earler versions I used 'Time travel' feature, which allows  a user to
run a historical queries. But in 6.3 it was removed. Can I do it another
way?

Thanks in advance.

Jane.




From kostik@esir.ru Tue Aug  26 09:37:38 2003
X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [64.117.224.130])
	by svr1.postgresql.org (Postfix) with ESMTP id 5BDC8D1D82E
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Tue, 26 Aug 2003 06:37:38 -0300 (ADT)
Received: from svr1.postgresql.org ([64.117.224.193])
	by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new,
	port 10024) with ESMTP id 45425-07
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Tue, 26 Aug 2003 06:37:09 -0300 (ADT)
Received: from gw.esir.ru (mailhub.esir.ru [195.46.117.225])
	by svr1.postgresql.org (Postfix) with ESMTP id 8E317D1B900
	for <pgsql-sql@postgresql.org>; Tue, 26 Aug 2003 06:37:05 -0300 (ADT)
Received: (from root@localhost)
	by gw.esir.ru (8.12.8/8.12.8/Debian-2) id h7Q9bRTI002209
	for pgsql-sql@postgresql.org.AVP; Tue, 26 Aug 2003 18:37:27 +0900
Received: from mail (mail.esir.ru [10.1.1.236])
	by gw.esir.ru (8.12.8/8.12.8/Debian-2) with ESMTP id h7Q9bOUA002188
	for <pgsql-sql@postgresql.org>; Tue, 26 Aug 2003 18:37:26 +0900
Received: from kostik (10.1.1.248)
	by mail with MERCUR-SMTP/POP3/IMAP4-Server (v3.30.03 FC-8388608)
	for <pgsql-sql@postgresql.org>; Tue, 26 Aug 2003  18:37:02 +0900
Message-ID: <004f01c36bb5$9a962690$f801010a@esir.ru>
From: "Konstantin Petrenko" <kostik@esir.ru>
To: <pgsql-sql@postgresql.org>
Subject: Restore deleted records
Date: Tue, 26 Aug 2003 18:37:02 +0900
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_NextPart_000_004C_01C36C01.0A625750"
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express 6.00.2800.1158
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
Reply-To: kostik@esir.ru
X-Virus-Scanned: by amavisd-new at postgresql.org
X-Spam-Status: No, hits=0.7 tagged_above=0.0 required=5.0 tests=HTML_40_50
X-Spam-Level: 
X-Archive-Number: 200308/309
X-Sequence-Number: 14925

This is a multi-part message in MIME format.

------=_NextPart_000_004C_01C36C01.0A625750
Content-Type: text/plain;
	charset="koi8-r"
Content-Transfer-Encoding: quoted-printable

Hello.

I accidentally deleted some recordes from my table. How can I restore
them? Is it possible in 7.3.3?

Thanks
Konstantin Petrenko.


------=_NextPart_000_004C_01C36C01.0A625750
Content-Type: text/html;
	charset="koi8-r"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; charset=3Dkoi8-r">
<META content=3D"MSHTML 6.00.2800.1226" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV>Hello.<BR><BR>I accidentally deleted some recordes from my table. How =
can I=20
restore<BR>them? Is it possible in 7.3.3?<BR><BR>Thanks<BR>Konstantin=20
Petrenko.<BR><BR></DIV></BODY></HTML>

------=_NextPart_000_004C_01C36C01.0A625750--




From col@mportal.hu Tue Aug  26 20:22:37 2003
X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [64.117.224.130])
	by svr1.postgresql.org (Postfix) with ESMTP id 87C19D1B89B
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Tue, 26 Aug 2003 17:22:37 -0300 (ADT)
Received: from svr1.postgresql.org ([64.117.224.193])
	by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new,
	port 10024) with ESMTP id 28198-09
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Tue, 26 Aug 2003 17:22:07 -0300 (ADT)
Received: from news.hub.org (unknown [64.117.224.194])
	by svr1.postgresql.org (Postfix) with ESMTP id 7DDC7D1B8A4
	for <pgsql-sql@postgresql.org>; Tue, 26 Aug 2003 17:22:05 -0300 (ADT)
Received: from news.hub.org (host-64-117-224-194.altec1.com [64.117.224.194]
	(may be forged))
	by news.hub.org (8.12.9/8.12.9) with ESMTP id h7QKLuek061480
	for <pgsql-sql@postgresql.org>; Tue, 26 Aug 2003 20:21:56 GMT
	(envelope-from news@news.hub.org)
Received: (from news@localhost)
	by news.hub.org (8.12.9/8.12.9/Submit) id h7QJxsBF055635
	for pgsql-sql@postgresql.org; Tue, 26 Aug 2003 19:59:54 GMT
From: CoL <col@mportal.hu>
X-Newsgroups: comp.databases.postgresql.sql
Subject: Re: Restore deleted records
Date: Tue, 26 Aug 2003 22:02:30 +0200
Organization: Hub.Org Networking Services
Lines: 12
Message-ID: <bige7p$1luk$1@news.hub.org>
References: <004f01c36bb5$9a962690$f801010a@esir.ru>
Reply-To: col@mportal.hu
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
X-Complaints-To: usenet@news.hub.org
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US;
	rv:1.5a) Gecko/20030718
X-Accept-Language: hu, en-us, en
In-Reply-To: <004f01c36bb5$9a962690$f801010a@esir.ru>
To: pgsql-sql@postgresql.org
X-Virus-Scanned: by amavisd-new at postgresql.org
X-Archive-Number: 200308/314
X-Sequence-Number: 14930

Hi,

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.

C.




From bruno@wolff.to Wed Aug  27 12:30:14 2003
X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [64.117.224.130])
	by svr1.postgresql.org (Postfix) with ESMTP id 21384D1B97C
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Wed, 27 Aug 2003 09:30:14 -0300 (ADT)
Received: from svr1.postgresql.org ([64.117.224.193])
	by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new,
	port 10024) with ESMTP id 85573-05
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Wed, 27 Aug 2003 09:30:05 -0300 (ADT)
Received: from wolff.to (wolff.to [66.93.249.74])
	by svr1.postgresql.org (Postfix) with SMTP id 6F78BD1BA15
	for <pgsql-sql@postgresql.org>; Wed, 27 Aug 2003 09:30:01 -0300 (ADT)
Received: (qmail 25127 invoked by uid 500); 27 Aug 2003 12:36:01 -0000
Date: Wed, 27 Aug 2003 07:36:01 -0500
From: Bruno Wolff III <bruno@wolff.to>
To: CoL <col@mportal.hu>
Cc: pgsql-sql@postgresql.org
Subject: Re: Restore deleted records
Message-ID: <20030827123601.GB25066@wolff.to>
Mail-Followup-To: CoL <col@mportal.hu>, pgsql-sql@postgresql.org
References: <004f01c36bb5$9a962690$f801010a@esir.ru>
	<bige7p$1luk$1@news.hub.org>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <bige7p$1luk$1@news.hub.org>
User-Agent: Mutt/1.5.4i
X-Virus-Scanned: by amavisd-new at postgresql.org
X-Archive-Number: 200308/329
X-Sequence-Number: 14945

> 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.