On Thu, Mar 28, 2013 at 10:31:51PM +0100, anara...@anarazel.de wrote: > > > Tom Lane <t...@sss.pgh.pa.us> schrieb: > > >Bruce Momjian <br...@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. > > You need to look at inisready in 9.2 since thats used for about to be dropped > indexes. No?
Well, if it is dropped, pg_dump will not dump it. At this point though, pg_upgrade is either running in check mode, or it is the only user. I think we are OK. -- Bruce Momjian <br...@momjian.us> http://momjian.us EnterpriseDB http://enterprisedb.com + It's impossible for everything to be true. + -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers