Skip site navigation (1) Skip section navigation (2)

pgsql: Fix pg_upgrade for invalid indexes

From: Bruce Momjian <bruce(at)momjian(dot)us>
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Fix pg_upgrade for invalid indexes
Date: 2012-12-11 20:09:31
Message-ID: E1TiW8x-0001CI-Lt@gemulon.postgresql.org (view raw or flat)
Thread:
Lists: pgsql-committers
Fix pg_upgrade for invalid indexes

All versions of pg_upgrade upgraded invalid indexes caused by CREATE
INDEX CONCURRENTLY failures and marked them as valid.  The patch adds a
check to all pg_upgrade versions and throws an error during upgrade or
--check.

Backpatch to 9.2, 9.1, 9.0.  Patch slightly adjusted.

Branch
------
master

Details
-------
http://git.postgresql.org/pg/commitdiff/e95c4bd1133acf7fc58a52212253129ef2dc9d12

Modified Files
--------------
contrib/pg_upgrade/check.c |   91 ++++++++++++++++++++++++++++++++++++++++++++
1 files changed, 91 insertions(+), 0 deletions(-)


pgsql-committers by date

Next:From: Kevin GrittnerDate: 2012-12-11 20:35:09
Subject: pgsql: Fix performance problems with autovacuum truncation in busywork
Previous:From: Heikki LinnakangasDate: 2012-12-11 16:59:39
Subject: pgsql: Consistency check should compare last record replayed,not last

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group