Hi, I tried to test it but it says couldn't find class 'pg_attribute' 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
