X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id CA50CD1B342 for ; Thu, 15 Jul 2004 10:00:05 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 50425-09 for ; Thu, 15 Jul 2004 13:00:05 +0000 (GMT) Received: from mx1.aftenposten.no (mx1.aftenposten.no [80.91.34.36]) by svr1.postgresql.org (Postfix) with ESMTP id 35530D1B2A6 for ; Thu, 15 Jul 2004 09:59:54 -0300 (ADT) Received: from localhost (localhost.aftenposten.no [127.0.0.1]) by mx1.aftenposten.no (Postfix) with ESMTP id 1A0094C9016 for ; Thu, 15 Jul 2004 15:00:03 +0200 (CEST) Received: from mx1.aftenposten.no ([127.0.0.1]) by localhost (mx1.aftenposten.no [127.0.0.1]) (amavisd-new, port 10024) with LMTP id 74401-01-10 for ; Thu, 15 Jul 2004 15:00:02 +0200 (CEST) Received: from smtp2.aftenposten.no (unknown [80.91.34.7]) by mx1.aftenposten.no (Postfix) with ESMTP id 7C3144C91DD for ; Thu, 15 Jul 2004 15:00:02 +0200 (CEST) Received: from telecommail.inpoc.no (unverified) by smtp2.aftenposten.no (Content Technologies SMTPRS 4.3.12) with ESMTP id for ; Thu, 15 Jul 2004 15:00:21 +0200 Received: by TELECOMMAIL with Internet Mail Service (5.5.2653.19) id ; Thu, 15 Jul 2004 15:02:01 +0200 Message-ID: From: "Lending, Rune" To: "'pgsql-admin@postgresql.org'" Subject: recover deletede tuples Date: Thu, 15 Jul 2004 15:02:00 +0200 MIME-Version: 1.0 X-Mailer: Internet Mail Service (5.5.2653.19) Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C46A6B.EA8A17A0" X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.5 tagged_above=0.0 required=5.0 tests=HTML_40_50, HTML_MESSAGE X-Spam-Level: X-Archive-Number: 200407/177 X-Sequence-Number: 14245 This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------_=_NextPart_001_01C46A6B.EA8A17A0 Content-Type: text/plain I have deleted some important tuples, but have not run vacuum yet. I am looking at the oid file in the base structure, and I can see the tuples are in this file. I used pgfsck and worked just fine on small tables, but it dies when I am running it on a large table. The datas I want to recover is from a 7.2 database. Is there any other way of recover deleted tuples that still remains on disc? Are there any scripts that can read base files? Please help, it is kind of critical for us. /rune ------_=_NextPart_001_01C46A6B.EA8A17A0 Content-Type: text/html Melding
I have deleted some important tuples, but have not run vacuum yet. I am looking at the oid file in the base structure, and I can see the tuples are in this file.
I used pgfsck and worked just fine on small tables, but it dies when I am running it on a large table. 
The datas I want to recover is from a 7.2 database.
 
Is there any other way of recover deleted tuples that still remains on disc?
Are there any scripts that can read base files?
 
Please help, it is kind of critical for us.
 
/rune
------_=_NextPart_001_01C46A6B.EA8A17A0--