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 5A887D1B19B for ; Wed, 14 Jul 2004 13:20:37 -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 06454-05 for ; Wed, 14 Jul 2004 16:20:31 +0000 (GMT) Received: from mx2.aftenposten.no (mx2.aftenposten.no [80.91.34.76]) by svr1.postgresql.org (Postfix) with ESMTP id 5664ED1B26D for ; Wed, 14 Jul 2004 13:20:29 -0300 (ADT) Received: from localhost (localhost.aftenposten.no [127.0.0.1]) by mx2.aftenposten.no (Postfix) with ESMTP id E027F7F7E6A for ; Wed, 14 Jul 2004 18:20:28 +0200 (CEST) Received: from mx2.aftenposten.no ([127.0.0.1]) by localhost (mx2.aftenposten.no [127.0.0.1]) (amavisd-new, port 10024) with LMTP id 02482-01-3 for ; Wed, 14 Jul 2004 18:20:28 +0200 (CEST) Received: from smtp1.aftenposten.no (unknown [80.91.34.6]) by mx2.aftenposten.no (Postfix) with ESMTP id 8EC5E7F7E67 for ; Wed, 14 Jul 2004 18:20:28 +0200 (CEST) Received: from telecommail.inpoc.no (unverified) by smtp1.aftenposten.no (Content Technologies SMTPRS 4.3.12) with ESMTP id for ; Wed, 14 Jul 2004 18:22:25 +0200 Received: from urlemainframe ([192.168.90.13]) by telecommail.inpoc.no with SMTP (Microsoft Exchange Internet Mail Service Version 5.5.2653.13) id LXYN0KT7; Wed, 14 Jul 2004 18:22:27 +0200 Message-ID: <001d01c469be$7cadbc80$0d5aa8c0@urlemainframe> From: "Rune Lending" To: Subject: recover deleted tuples Date: Wed, 14 Jul 2004 18:20:32 +0200 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_001A_01C469CF.401C4DC0" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1437 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.8 tagged_above=0.0 required=5.0 tests=HTML_30_40, HTML_MESSAGE X-Spam-Level: X-Archive-Number: 200407/208 X-Sequence-Number: 14276 This is a multi-part message in MIME format. ------=_NextPart_000_001A_01C469CF.401C4DC0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable We had an accident with a table where all tuples where deleted. We have not= run VACUUM yet and it seems like the datas are in place in the base direct= ory. Our backup were not active when this happened. I have seen some talk about that it is possible to restore those missing da= ta in this case, but I have not yet seen a solution for it. Can anyone plea= se help with this problem, it is kind of critical for us.. Thanks a lot in advance.. /rune ------=_NextPart_000_001A_01C469CF.401C4DC0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
We had an accident with a table where all = tuples=20 where deleted. We have not run VACUUM yet and it seems like the datas are i= n=20 place in the base directory. Our backup were&nb= sp;not=20 active when this happened.
I have seen some talk about that it is pos= sible to=20 restore those missing data in this case, but I have not yet seen a solution= for=20 it. Can anyone please help with this pro= blem, it=20 is kind of critical for us..
 
Thanks a lot in advance..
 
 
/rune
------=_NextPart_000_001A_01C469CF.401C4DC0--