Re: missing chunk number 0 for toast value ...

Поиск
Список
Период
Сортировка
От MIlos Prudek
Тема Re: missing chunk number 0 for toast value ...
Дата
Msg-id 200605051949.33397.prudek@bvx.cz
обсуждение исходный текст
Ответ на Re: missing chunk number 0 for toast value ...  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-admin
> Find the row containing the busted toast reference, and delete that row
> (or just UPDATE it with some new value for the toasted column).  You can
> home in on it with the usual sorts of search methods --- look in the PG
> list archives for previous discussions of locating corrupted rows.

Thanks Tom. I ended up restoring the table from the last dump (created by
pg_dump) up to the point where corruption starts. Not the most surgical
solution but justified for my use case.


--
Milos Prudek

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

Предыдущее
От: "Joshua D. Drake"
Дата:
Сообщение: Re: Best way to upgrade Postgresql 7.4.x to 8.1.x?
Следующее
От: "Vadim Pestovnikov"
Дата:
Сообщение: handling errors of os.error module