Re: [ADMIN] recover of data directory

2006-05-29 Thread Alvaro Herrera
Daniel Drotos wrote: > On Mon, 29 May 2006, Tom Lane wrote: > > >If you could identify which file is which, you could manually > >reconstruct the directories, but I'm afraid the odds of doing that > > Postgresql data files do not identifying themselves (in their content) > so it's an ext2fs prob

Re: [ADMIN] recover of data directory

2006-05-29 Thread Daniel Drotos
On Mon, 29 May 2006, Tom Lane wrote: If you could identify which file is which, you could manually reconstruct the directories, but I'm afraid the odds of doing that Postgresql data files do not identifying themselves (in their content) so it's an ext2fs problem. I'm trying to solve it, just

Re: [ADMIN] recover of data directory

2006-05-29 Thread Tom Lane
Daniel Drotos <[EMAIL PROTECTED]> 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). Be

Re: [ADMIN] recover of data directory

2006-05-29 Thread Gourish Singbal
  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 <[EMAIL PROTECTED]> wrote: Hi,During machine maintenance I've made 'rm -rf *' on postgres datadirectory by a (very stupid) mistake. Postmaster was n

[ADMIN] recover of data directory

2006-05-29 Thread Daniel Drotos
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 direct