pgsql: pg_upgrade: Handle hash index upgrades more smoothly.

From: Robert Haas <rhaas(at)postgresql(dot)org>
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: pg_upgrade: Handle hash index upgrades more smoothly.
Date: 2017-05-19 20:53:50
Message-ID: E1dBouE-0003E5-Bm@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

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

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/a95410e2ec39b6776381fd01198dc57a063e8185

Modified Files
--------------
src/bin/pg_upgrade/check.c | 17 +++++-
src/bin/pg_upgrade/pg_upgrade.h | 2 +
src/bin/pg_upgrade/version.c | 112 ++++++++++++++++++++++++++++++++++++++++
3 files changed, 130 insertions(+), 1 deletion(-)

Browse pgsql-committers by date

  From Date Subject
Next Message Tom Lane 2017-05-19 22:05:27 pgsql: Rethink flex flags for syncrep_scanner.l.
Previous Message Peter Eisentraut 2017-05-19 20:42:19 pgsql: Fix mistake in error message