Re: Ignore invalid indexes in pg_dump. - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Ignore invalid indexes in pg_dump.
Date
Msg-id 24486.1364506048@sss.pgh.pa.us
Whole thread Raw
In response to Re: Ignore invalid indexes in pg_dump.  (Bruce Momjian <bruce@momjian.us>)
Responses Re: Ignore invalid indexes in pg_dump.  ("anarazel@anarazel.de" <andres@anarazel.de>)
Fix for pg_upgrade and invalid indexes  (Bruce Momjian <bruce@momjian.us>)
List pgsql-hackers
Bruce Momjian <bruce@momjian.us> writes:
> Should I just patch pg_upgrade to remove the "indisvalid", skip
> "indisvalid" indexes, and backpatch it?  Users should be using the
> version of pg_upgrade to match new pg_dump.  Is there any case where
> they don't match?  Do I still need to check for "indisready"?

Yeah, if you can just ignore !indisvalid indexes that should work fine.
I see no need to look at indisready if you're doing that.
        regards, tom lane



pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: pg_upgrade segfaults when given an invalid PGSERVICE value
Next
From: "anarazel@anarazel.de"
Date:
Subject: Re: Ignore invalid indexes in pg_dump.