X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id CF966D1BB15 for ; Mon, 23 Feb 2004 11:24:40 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 46518-05 for ; Mon, 23 Feb 2004 07:24:41 -0400 (AST) Received: from smtp.pspl.co.in (www.pspl.co.in [202.54.11.65]) by svr1.postgresql.org (Postfix) with ESMTP id 2E0DDD1B581 for ; Mon, 23 Feb 2004 07:24:35 -0400 (AST) Received: (from root@localhost) by smtp.pspl.co.in (8.12.9/8.12.9) id i1NBOiMj010220 for ; Mon, 23 Feb 2004 16:54:44 +0530 X-Scanned: XAM28854 Scanned by XAMIME Received: from persistent.co.in (PS1003.pspl.co.in [203.199.147.140]) (authenticated bits=0) by persistent.co.in (8.12.9/8.12.9) with ESMTP id i1NBOhGK010206 for ; Mon, 23 Feb 2004 16:54:44 +0530 Message-ID: <403A75B5.4040302@persistent.co.in> Date: Mon, 23 Feb 2004 16:50:45 -0500 From: Anthony Raj Reply-To: anthony_raj@persistent.co.in User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.5) Gecko/20031007 X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: How to Recover From Accidental Deletes ? Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200402/371 X-Sequence-Number: 12544 Hi , I have been trying to look at ways to recover from any accidental deletes. Reading some pevious posts , its clear that its possible since the records are just marked for delete and not actually deleted. Its deleted only after a Vacuum command is run . I believe its possible to talk to backent and read the data in the form of raw tuples . Any one know how its done ? or any docs that talk about such stuff. thanks in advance, Anthony