Re: [GENERAL] Recover corrupted data

Поиск
Список
Период
Сортировка
От Moreno Andreo
Тема Re: [GENERAL] Recover corrupted data
Дата
Msg-id e5a313ec-87c3-3a43-2a2b-53eccd911992@evolu-s.it
обсуждение исходный текст
Ответ на Re: [GENERAL] Recover corrupted data  (Vick Khera <vivek@khera.org>)
Ответы Re: [GENERAL] Recover corrupted data
Список pgsql-general
Il 19/04/2017 17:49, Vick Khera ha scritto:
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?

IMHO If there's no hurry, it'd be better to start with point 2, because if your filesystem (or hardware) is somehow badly broken, it will happen again...
If you have more than one database in your cluster, you can find what's the database that's been corrupted and restore just that one, instead of the whole cluster.
Cheers
Moreno


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 по дате отправления:

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