2009/11/24 Allan Morris Caras <amsca...@yahoo.com>: > Hi, > > I tried to test it but it says couldn't find class 'pg_attribute'
It is strange - but this software isn't maintained long time, and it's not actual. so it is a bad Pavel > > When I tried looking into the table that deleted records from, it didn't > revert back what I've deleted. > > Any clues? > > > > > > ----- Original Message ---- > From: Pavel Stehule <pavel.steh...@gmail.com> > To: Allan Morris Caras <amsca...@yahoo.com> > Cc: pgsql-general@postgresql.org > Sent: Tue, November 24, 2009 6:31:17 PM > Subject: Re: [COMMITTERS] recover deleted records > > 2009/11/24 Allan Morris Caras <amsca...@yahoo.com>: >> Hi, >> >> No, auto vacuum is not enabled. > > ok then don't try to call vacuum in any form. so some undelete is > possible. It was good new. Bad new - nobody wrote any tool for it. > There are pgfsck, but itsn't three years actualised - but you can try > it. > > look on http://svana.org/kleptog/pgsql/pgfsck.html > > good luck > Pavel Stehule > > > >> >> >> >> >> >> ----- Original Message ---- >> From: Pavel Stehule <pavel.steh...@gmail.com> >> To: Allan Morris Caras <amsca...@yahoo.com> >> Cc: "pgsql-general@postgresql.org >> PG-General Mailing List" >> <pgsql-general@postgresql.org> >> Sent: Tue, November 24, 2009 6:14:22 PM >> Subject: Re: [COMMITTERS] recover deleted records >> >> Hello >> >> Have you enabled autovacuum? >> >> Pavel >> >> p.s. please, don't use pgsql-commiters mailing list for general questions. >> >> use pgsql-general. >> >> 2009/11/24 Allan Morris Caras <amsca...@yahoo.com>: >>> I have accidentally / stupidly deleted records from a table. >>> >>> I tried delete from where exist and it deleted the whole table. >>> >>> Is there a way I can recover it? >>> >>> I'm using postgres 8.4 >>> >>> Any help is appreciated. TIA >>> >>> >>> >>> >>> >>> -- >>> Sent via pgsql-committers mailing list (pgsql-committ...@postgresql.org) >>> To make changes to your subscription: >>> http://www.postgresql.org/mailpref/pgsql-committers >>> >> >> >> >> >> > > > > > -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general