Re: pg_upgrade problem with invalid indexes

Bruce Momjian wrote:

> There are a few possible fixes.  The first would be to have pg_upgrade
> throw an error on any invalid index in the old cluster.  Another option
> would be to preserve the invalid state in pg_dump --binary-upgrade.

Yet another option would be for pg_dump --binary-upgrade to ignore
invalid indexes altogether (and probably "not ready" indexes, too, not
sure).

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