Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-admin by date

Next:From: Daniel DrotosDate: 2006-05-29 15:23:22
Subject: Re: recover of data directory
Previous:From: Gourish SingbalDate: 2006-05-29 11:19:20
Subject: Re: recover of data directory

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group