Re: [GENERAL] Recover corrupted data

Поиск
Список
Период
Сортировка
От Alexandre
Тема Re: [GENERAL] Recover corrupted data
Дата
Msg-id CAEPSA-e18FVMrUFqdGFCWGsmPnBO+s9vnRY-EkfaO_1VmnfFZw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: [GENERAL] Recover corrupted data  (Vick Khera <vivek@khera.org>)
Ответы Re: [GENERAL] Recover corrupted data
Список pgsql-general
1) We have a backup but its from the last month, I will try to backup the data without the table that raises the exception.
2) We dont use RAID.

Thank you

On Wed, Apr 19, 2017 at 12:49 PM, Vick Khera <vivek@khera.org> wrote:
1) restore from backup
2) fix whatever configuration you made to let windows (or your hardware) destroy your data on crash. is there some RAID cache that is not backed up by a battery?


On Wed, Apr 19, 2017 at 10:18 AM, Alexandre <psybox@gmail.com> wrote:
Hello,

The computer had a unexpected shutdown, it is a Windows machine.
Now some data appears to be corrupted, I am receiving exceptions like this:

ERROR: could not read block 0 in file "base/16393/16485": read only
0 of 8192 bytes

There is some way to correct this?


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

Предыдущее
От: Steve Clark
Дата:
Сообщение: Re: [GENERAL] Why so long?
Следующее
От: Alexandre
Дата:
Сообщение: Re: [GENERAL] Recover corrupted data