Thread: Recover data....
Hi, Sorry, I am resending this email.. there was spelling mistake in earlier email... Please help me..... Due to some unknown reason all contents of PostGresql data folder ( D:\Program Files\PostgreSQL\8.4\data) got deleted except base and global folder. Please let me If I can recover my whole data.. Thanks & Regards, Azghar Hussain Project Lead (Software) - Risk and Insurance (RI), RMSI Pvt Ltd, A - 7, Sector - 16, Noida - 201301, UP, India Ph: +91 - 120 - 2511102, Ext No. 2655
"Azghar Hussain" <Azghar.Hussain@rmsi.com> wrote: > Due to some unknown reason all contents of PostGresql data folder > (D:\Program Files\PostgreSQL\8.4\data) got deleted except base and > global folder. > Please let me If I can recover my whole data.. Several of the other folders contain information crucial to storing the data -- they are an integral part of the database. It may be possible to rebuild some approximation of what is correct, but you will probably have some data loss or corruption if you go that way. The first thing is to copy what is left of the data directory tree to a backup location and keep it safe. http://wiki.postgresql.org/wiki/Corruption The next thing is probably to decide if you want to put a lot of time and resources into recovering what you can from what's left of your database, or just go to your last good backup. What backup technique are you using? How current is the copy? If you want to try to recover, you should provide a lot more information. This page provides some advice in that regard: http://wiki.postgresql.org/wiki/Guide_to_reporting_problems You might want to pay for expert help: http://www.postgresql.org/support/professional_support/ -Kevin