Re: [GENERAL] [COMMITTERS] recover deleted records

2009-11-24 Thread Scott Bailey
Pavel Stehule wrote: 2009/11/24 Allan Morris Caras : 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,

Re: [GENERAL] [COMMITTERS] recover deleted records

2009-11-24 Thread Pavel Stehule
2009/11/24 Allan Morris Caras : > 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 > rev

Re: [GENERAL] [COMMITTERS] recover deleted records

2009-11-24 Thread Allan Morris Caras
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 To: Allan Morris Caras Cc: pgsql-general@postgresql.org

Re: [GENERAL] [COMMITTERS] recover deleted records

2009-11-24 Thread Pavel Stehule
2009/11/24 Allan Morris Caras : > 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://s

Re: [GENERAL] [COMMITTERS] recover deleted records

2009-11-24 Thread Allan Morris Caras
Hi, No, auto vacuum is not enabled. - Original Message From: Pavel Stehule To: Allan Morris Caras Cc: "pgsql-general@postgresql.org >> PG-General Mailing List" Sent: Tue, November 24, 2009 6:14:22 PM Subject: Re: [COMMITTERS] recover deleted records Hello Have you enabled autov

Re: [GENERAL] [COMMITTERS] recover deleted records

2009-11-24 Thread Pavel Stehule
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 : > I have accidentally / stupidly deleted records from a table. > > I tried delete from where exist and it deleted the whole tab