Re: How am I supposed to fix this?

Поиск
Список
Период
Сортировка
От Alvaro Herrera
Тема Re: How am I supposed to fix this?
Дата
Msg-id 20190806172047.GA31000@alvherre.pgsql
обсуждение исходный текст
Ответ на How am I supposed to fix this?  (Larry Rosenman <ler@lerctr.org>)
Список pgsql-hackers
On 2019-Aug-06, Larry Rosenman wrote:

> ler=# reindex index pg_toast_17760_index;
> ERROR:  relation "pg_toast_17760_index" does not exist

Maybe try "reindex index pg_toast.pg_toast_17760_index"

> ler=# reindex (verbose) database ler;
[...]
> ERROR:  index "pg_toast_17760_index" contains unexpected zero page at block
> 23686
> HINT:  Please REINDEX it.

I suspect REINDEX is trying to access that index for some other reason
than reindexing it.

-- 
Álvaro Herrera                https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services



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

Предыдущее
От: Tomas Vondra
Дата:
Сообщение: Re: How am I supposed to fix this?
Следующее
От: Peter Geoghegan
Дата:
Сообщение: Re: How am I supposed to fix this?