Re: [HACKERS] Restore deleted rows

2009-05-01 Thread Greg Stark
On Wed, Apr 29, 2009 at 7:03 PM, Dimitri Fontaine wrote: > The idea is to have VACUUM not discard the no more visible tuples but store > them on a specific fork (which you'll want to have on a WORM (cheap) > tablespace, separate issue). > Then you want to be able to associate the tuple xid info wi

Re: [HACKERS] Restore deleted rows

2009-05-01 Thread Dimitri Fontaine
Hi, On Tuesday 28 April 2009 20:43:38 Robert Treat wrote: > We had started down the path of making a function to read deleted tuples > from a table for a DR scenario we were involved with once. The idea was > that you could do something like select * from > viewdeletedpages('tablename') t (table t

Re: [HACKERS] Restore deleted rows

2009-04-30 Thread Robert Treat
On Wednesday 29 April 2009 14:03:14 Dimitri Fontaine wrote: > Hi, > > On Tuesday 28 April 2009 20:43:38 Robert Treat wrote: > > We had started down the path of making a function to read deleted tuples > > from a table for a DR scenario we were involved with once. The idea was > > that you could do

Re: [HACKERS] Restore deleted rows

2009-04-28 Thread Robert Treat
On Monday 27 April 2009 11:17:42 Tom Lane wrote: > Alvaro Herrera writes: > > Anton Egorov escribió: > >> 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.postgres

Re: [HACKERS] Restore deleted rows

2009-04-27 Thread Tom Lane
Alvaro Herrera writes: > Anton Egorov escribió: >> 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 anoth

Re: [HACKERS] Restore deleted rows

2009-04-27 Thread Alvaro Herrera
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

[HACKERS] Restore deleted rows

2009-04-26 Thread Anton Egorov
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?