Re: could not read block... how could I identify/fix

Поиск
Список
Период
Сортировка
От Vick Khera
Тема Re: could not read block... how could I identify/fix
Дата
Msg-id CALd+dccZw7ghk_t32QkzpEa-XvAG=6nL4Mk0vX4+AHZjVM43Dg@mail.gmail.com
обсуждение исходный текст
Ответ на could not read block... how could I identify/fix  (Naoko Reeves <naokoreeves@gmail.com>)
Ответы Re: could not read block... how could I identify/fix  (Naoko Reeves <naokoreeves@gmail.com>)
Список pgsql-general
On Wed, Mar 28, 2012 at 6:31 PM, Naoko Reeves <naokoreeves@gmail.com> wrote:
> Do you think this should be the next step I might take?
> Could you give me an advice of how I could identify corrupted error.

It seems to me that since you can successfully dump the table (I
assume you validated the data was all there somehow), you should go
ahead and dump your whole DB, delete the current one, create it again,
then restore it from scratch.

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

Предыдущее
От: Maxim Boguk
Дата:
Сообщение: Why checkpoint_timeout had maximum value of 1h?
Следующее
От: Arvind Singh
Дата:
Сообщение: More PG Log