Re: Restore deleted rows

Anton Egorov escribió:
> Hi!
> 
> I need to recover deleted rows from table. After I delete those rows I
> stopped postgres immediately and create tar archive of database. I found
> solution http://archives.postgresql.org/pgsql-hackers/2005-03/msg00965.php,
> but is there another (easyer) way to do it?

I guess you could figure out the Xid of the transaction that deleted the
tuples, and mark it as aborted in pg_clog; you'd also need to reset the
hint bits on the tuples themselves.  Not necessarily any easier than the
above, but at least you don't have to patch Postgres code.

-- 
Alvaro Herrera                                http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.