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


Reply via email to