Re: recover of data directory - Mailing list pgsql-admin

From Tom Lane
Subject Re: recover of data directory
Date
Msg-id 14037.1148914696@sss.pgh.pa.us
Whole thread Raw
In response to recover of data directory  (Daniel Drotos <drdani@mazsola.iit.uni-miskolc.hu>)
Responses Re: recover of data directory  (Daniel Drotos <drdani@mazsola.iit.uni-miskolc.hu>)
List pgsql-admin
Daniel Drotos <drdani@mazsola.iit.uni-miskolc.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

pgsql-admin by date:

Previous
From: "Gourish Singbal"
Date:
Subject: Re: recover of data directory
Next
From: Daniel Drotos
Date:
Subject: Re: recover of data directory