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 amsca...@yahoo.com: I have accidentally / stupidly deleted records from a table. I tried delete from where exist and it

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 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:

Re: [GENERAL] [COMMITTERS] recover deleted records

2009-11-24 Thread Pavel Stehule
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.

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 pavel.steh...@gmail.com To: Allan Morris Caras

Re: [GENERAL] [COMMITTERS] recover deleted records

2009-11-24 Thread Pavel Stehule
2009/11/24 Allan Morris Caras amsca...@yahoo.com: 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

Re: [GENERAL] [COMMITTERS] recover deleted records

2009-11-24 Thread Scott Bailey
Pavel Stehule wrote: 2009/11/24 Allan Morris Caras amsca...@yahoo.com: 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