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 B6CB49FA682 for ; Mon, 29 May 2006 08:19:31 -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 79616-04 for ; Mon, 29 May 2006 08:19:24 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from ug-out-1314.google.com (ug-out-1314.google.com [66.249.92.172]) by postgresql.org (Postfix) with ESMTP id 766F39FA315 for ; Mon, 29 May 2006 08:19:24 -0300 (ADT) Received: by ug-out-1314.google.com with SMTP id a2so58889ugf for ; Mon, 29 May 2006 04:19:22 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references; b=KTdDoWZkhQvXwKsop7QdCWH0K30qbU3bfB5tmiraVxHpYkjZEN5WrMivNmD//+ZWhXGo8hpC9rV8jJoT6PvC+HObyObZkPsoe/j8ypqHTcsBnZyTqX5nSPK+/fJYWs2rGa8a45Nf7NeyHDEHX5Ws0osR1Ryb315zqYUHlTP2odo= Received: by 10.66.185.40 with SMTP id i40mr1790298ugf; Mon, 29 May 2006 04:19:20 -0700 (PDT) Received: by 10.66.222.12 with HTTP; Mon, 29 May 2006 04:19:20 -0700 (PDT) Message-ID: <674d1f8a0605290419s36d85000q1cf73e0db2a0b568@mail.gmail.com> Date: Mon, 29 May 2006 04:19:20 -0700 From: "Gourish Singbal" To: "Daniel Drotos" Subject: Re: recover of data directory Cc: pgsql-admin@postgresql.org In-Reply-To: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_149987_8652437.1148901560639" References: <20060510080835.C087C9F931D@postgresql.org> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200605/393 X-Sequence-Number: 21925 ------=_Part_149987_8652437.1148901560639 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: quoted-printable Content-Disposition: inline tough luck .. could u query the unix groups and see if u could retrive the original filenames and directory structure ?. On 5/29/06, Daniel Drotos wrote: > > Hi, > > 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? > > Daniel > > ---------------------------(end of broadcast)--------------------------- > TIP 1: if posting/reading through Usenet, please send an appropriate > subscribe-nomail command to majordomo@postgresql.org so that your > message can get through to the mailing list cleanly > --=20 Best, Gourish Singbal ------=_Part_149987_8652437.1148901560639 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline
 
tough luck .. could u query the unix groups and see if u could retrive= the original filenames and directory structure ?.

 
On 5/29/06, = Daniel Drotos <= drdani@mazsola.iit.uni-miskolc.hu> wrote:
Hi,

During machine mainte= nance 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 di= rectory structure.

Is there any chance of recover data directory if only dumped filecontents are available?

Daniel

---------------------------(= end of broadcast)---------------------------
TIP 1: if posting/reading t= hrough Usenet, please send an appropriate
      subscribe-nomail command to majordomo@postgresql.org so that y= our
      message can get through to the m= ailing list cleanly



--
Best,
Gourish Singbal=20 ------=_Part_149987_8652437.1148901560639--