Horton

pg_upgrade: Handle hash index upgrades more smoothly.

Robert Haas <rhaas@postgresql.org>

View on postgr.es
Commit: a95410e2ec39b6776381fd01198dc57a063e8185
Author: Robert Haas <rhaas@postgresql.org>
Date: 2017-05-19T20:49:38Z
Releases: 10.0 
pg_upgrade: Handle hash index upgrades more smoothly.

Mark any old hash indexes as invalid so that they don't get used, and
create a script to run REINDEX on all of them.  Without this, we'd
still try to use any upgraded hash indexes, but it would fail.

Amit Kapila, reviewed by me.  Per a suggestion from Tom Lane.

Discussion: http://postgr.es/m/CAA4eK1Jidtagm7Q81q-WoegOVgkotv0OxvHOjFxcvFRP4X=mSw@mail.gmail.com

Files

PathChange+/−
src/bin/pg_upgrade/check.c modified +16 −1
src/bin/pg_upgrade/pg_upgrade.h modified +2 −0
src/bin/pg_upgrade/version.c modified +112 −0

Discussion