Search Postgresql Archives

Re: [COMMITTERS] recover deleted records

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux