2009/11/24 Allan Morris Caras <amscaras@xxxxxxxxx>: > 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.stehule@xxxxxxxxx> > To: Allan Morris Caras <amscaras@xxxxxxxxx> > Cc: pgsql-general@xxxxxxxxxxxxxx > Sent: Tue, November 24, 2009 6:31:17 PM > Subject: Re: [COMMITTERS] recover deleted records > > 2009/11/24 Allan Morris Caras <amscaras@xxxxxxxxx>: >> 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.stehule@xxxxxxxxx> >> To: Allan Morris Caras <amscaras@xxxxxxxxx> >> Cc: "pgsql-general@xxxxxxxxxxxxxx >> PG-General Mailing List" <pgsql-general@xxxxxxxxxxxxxx> >> 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 <amscaras@xxxxxxxxx>: >>> 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-committers@xxxxxxxxxxxxxx) >>> To make changes to your subscription: >>> http://www.postgresql.org/mailpref/pgsql-committers >>> >> >> >> >> >> > > > > > -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
