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