Re: vacuumdb: vacuuming of database "xy" failed: PANIC: corrupted item pointer: 19227

Поиск
Список
Период
Сортировка
От Tech 2010
Тема Re: vacuumdb: vacuuming of database "xy" failed: PANIC: corrupted item pointer: 19227
Дата
Msg-id ce84ef46-4c54-493b-8048-cfda814a1bfb@d21g2000yqn.googlegroups.com
обсуждение исходный текст
Ответ на vacuumdb: vacuuming of database "xy" failed: PANIC: corrupted item pointer: 19227  (Tech 2010 <tch072@gmail.com>)
Список pgsql-general
On 18 nov., 13:40, thombr...@gmail.com (Thom Brown) wrote:
> 2009/11/18 Tech 2010 <tch...@gmail.com>:
>
> > Hello!
>
> > How do I location of this pointer and how do I zero it so I can access
> > the rest of the data?
>
> > "zero_damaged_pages = true" did not help in this case, because I
> > always get same numbers being zeroed. This is with 8.4.0 and 8.4.1.
>
> > Thanks.
>
> You probably just need to reindex a table.  Try vacuuming each table
> individually until you get this error, or just check the vacuum log
> output to identify it, then just run a REINDEX on it.
xy=# reindex table xy_data;
ERROR:  concurrent insert in progress



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

Предыдущее
От: Skylar Saveland
Дата:
Сообщение: Re: [Fwd: Re: Creating new database]
Следующее
От: Richard Huxton
Дата:
Сообщение: Re: Can anyone help setting up pgbouncer?