X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 7F4719FA315 for ; Mon, 29 May 2006 11:58:32 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 14792-08 for ; Mon, 29 May 2006 11:58:20 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by postgresql.org (Postfix) with ESMTP id 74D9D9FA16E for ; Mon, 29 May 2006 11:58:20 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.6/8.13.6) with ESMTP id k4TEwGQo014038; Mon, 29 May 2006 10:58:16 -0400 (EDT) To: Daniel Drotos cc: pgsql-admin@postgresql.org Subject: Re: recover of data directory In-reply-to: References: <20060510080835.C087C9F931D@postgresql.org> Comments: In-reply-to Daniel Drotos message dated "Mon, 29 May 2006 12:17:07 +0200" Date: Mon, 29 May 2006 10:58:16 -0400 Message-ID: <14037.1148914696@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200605/394 X-Sequence-Number: 21926 Daniel Drotos writes: > During machine maintenance I've made 'rm -rf *' on postgres data > directory by a (very stupid) mistake. Postmaster was not running that > time. > Using e2undel I dumped out contents of deleted files (3728 files have > been deleted by that command). Because of "rm -r", sizes of recovered > directory files are 0, so I have no filenames and directory structure. > Is there any chance of recover data directory if only dumped file > contents are available? If you could identify which file is which, you could manually reconstruct the directories, but I'm afraid the odds of doing that correctly with so many files are nil. Time to get out your last backup. regards, tom lane