Re: [COMMITTERS] recover deleted records

Поиск
Список
Период
Сортировка
От Pavel Stehule
Тема Re: [COMMITTERS] recover deleted records
Дата
Msg-id 162867790911240414s22817df8gc5bce2133af9b54d@mail.gmail.com
обсуждение исходный текст
Ответ на Re: [COMMITTERS] recover deleted records  (Allan Morris Caras <amscaras@yahoo.com>)
Ответы Re: [COMMITTERS] recover deleted records  (Scott Bailey <artacus@comcast.net>)
Список pgsql-general
2009/11/24 Allan Morris Caras <amscaras@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 didn't revert back what I've deleted.
>
> Any clues?
>
>
>
>
>
> ----- Original Message ----
> From: Pavel Stehule <pavel.stehule@gmail.com>
> To: Allan Morris Caras <amscaras@yahoo.com>
> Cc: pgsql-general@postgresql.org
> Sent: Tue, November 24, 2009 6:31:17 PM
> Subject: Re: [COMMITTERS] recover deleted records
>
> 2009/11/24 Allan Morris Caras <amscaras@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.stehule@gmail.com>
>> To: Allan Morris Caras <amscaras@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 <amscaras@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-committers@postgresql.org)
>>> To make changes to your subscription:
>>> http://www.postgresql.org/mailpref/pgsql-committers
>>>
>>
>>
>>
>>
>>
>
>
>
>
>

В списке pgsql-general по дате отправления:

Предыдущее
От: Alban Hertroys
Дата:
Сообщение: Re: Multicolumn index including tsvector.
Следующее
От: Michal Szymanski
Дата:
Сообщение: Partitioning table and dynamic SQL in trigger