Re: recover of data directory

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Daniel Drotos <drdani(at)mazsola(dot)iit(dot)uni-miskolc(dot)hu>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: recover of data directory
Date: 2006-05-29 14:58:16
Message-ID: 14037.1148914696@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Daniel Drotos <drdani(at)mazsola(dot)iit(dot)uni-miskolc(dot)hu> 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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Daniel Drotos 2006-05-29 15:23:22 Re: recover of data directory
Previous Message Gourish Singbal 2006-05-29 11:19:20 Re: recover of data directory