2009/11/24 Allan Morris Caras <[email protected]>: > 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 <[email protected]> > To: Allan Morris Caras <[email protected]> > Cc: "[email protected] >> PG-General Mailing List" > <[email protected]> > 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 <[email protected]>: >> 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 ([email protected]) >> To make changes to your subscription: >> http://www.postgresql.org/mailpref/pgsql-committers >> > > > > > -- Sent via pgsql-general mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
