I accidentaly deleted over 1.000.000 records from one table in my database. Is there any way to recover them? Please help me as soon as possible...
After the records were deleted, no other operation was made on the database. In fact, all the postgres services were shut down. I found a xlog file containing those records but I don't know the structure of this file. This is Postgres 7.2.1 on Mandrake 8.1
Well - you'll probably need to wait until a developer can make a suggestion to get your data back. However, I do know enough to say that your data will still be there - so long as no further action takes place you'll be alright.
You'll probably want to take a backup of your whole .../data/ directory to be on the safe side. At a guess, it might be enough to rewind your current transaction-id and pg_dump that table, but I'm really out of my depth here.
-- Richard Huxton Archonet Ltd
---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
