Thread: urgent help required

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. ?

1).   the pgsql-hackers mailing list is not the place for this kind of
question.  Please use pgsql-admin or pgsql-general

2) Please use a subject line which indicates the nature of your issues.

3) PostgreSQL 8.2 is EOL and you should upgrade.

4) If you formatted the hard drive, your data is gone.

-- 
Josh Berkus
PostgreSQL Experts Inc.
http://pgexperts.com

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!