Re: urgent help required

From: Mark Kirkwood <mark(dot)kirkwood(at)catalyst(dot)net(dot)nz>
To: Josh Berkus <josh(at)agliodbs(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: urgent help required
Date: 2012-04-26 00:48:49
Message-ID: 4F989B71.7070205@catalyst.net.nz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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!

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Noah Misch 2012-04-26 02:04:11 Re: Temporary tables under hot standby
Previous Message Jameison Martin 2012-04-26 00:35:37 Re: patch submission: truncate trailing nulls from heap rows to reduce the size of the null bitmap