"Srinivasa Perumal" <[EMAIL PROTECTED]> writes > > hi, is there is way undelete or recover the deleted row in a table in postgres.iam layman, can anyone help me. >
Here is one way but I am not sure it is a good one. The precondition is that you didn't schedule any vacuum on your database. Since PG never really destory any data as you delete them before you use vacuum, so you still have chance to find back your data - copy down the values, and re-insert them again. PG uses visibility rules to fill out the garbage data, say, the data you deleted. So if you change the visibility rules, you could see your data again. The visibility rules is in function/macro HeapTupleSatisfiesVisibility(), return true means the tuple is visible, else, not. So if you know how to compile PG kernel, here is how: (1) shutdown your database and backup your data; (2) change HeapTupleSatisfiesVisibility(), just let it return "true", which means, it will treat everything as visible, including deleted rows; compile the kernel; (3) restart your database and find out the data you want - you may select them into another table; (4) revert the changes, and restart your database and insert the rows you just find out. Regards, Qingqing ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster