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
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
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
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
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
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
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?