Re: urgent help required - Mailing list pgsql-hackers

From Mark Kirkwood
Subject Re: urgent help required
Date
Msg-id 4F989B71.7070205@catalyst.net.nz
Whole thread Raw
In response to Re: urgent help required  (Josh Berkus <josh@agliodbs.com>)
List pgsql-hackers
On 19/04/12 06:23, Josh Berkus wrote:
> Nagaraj,
>
>> i am nagaraj, i am newbi in this database world. i required your help.
>> 2 dyas back i formatted one of my client system. which is having postgresql
>> 8.2 database&  that was having data. but i am not taken backup of the data.
>> 1) how to take the data from the formatted harddisk. ?
>> 2) how many folders or files will be their at base folder. When we install
>> postgresql 8.2?
>> 3) how to identify which folder contain which file. ?
>
> 4) If you formatted the hard drive, your data is gone.

Well that last point is not entirely true. Depending on the type of 
format used it may be possible to recover little/some/most (bit of a 
lottery there) of your data.

There are tools out there to help, however if the data is important it 
is worthwhile a) stopping using the disk(s) immediately and b) getting a 
computer forensics/data recovery service to help.

regards

Mark

P.s: Judging from the date of this thread the above advice may be too 
late, sorry. Next time always backup!


pgsql-hackers by date:

Previous
From: Jameison Martin
Date:
Subject: Re: patch submission: truncate trailing nulls from heap rows to reduce the size of the null bitmap
Next
From: Noah Misch
Date:
Subject: Re: Temporary tables under hot standby