pgsql: pg_upgrade: Convert old visibility map format to new format.

From: Robert Haas <rhaas(at)postgresql(dot)org>
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: pg_upgrade: Convert old visibility map format to new format.
Date: 2016-03-11 17:36:34
Message-ID: E1aeQzK-0004Pm-K0@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers pgsql-hackers

pg_upgrade: Convert old visibility map format to new format.

Commit a892234f830e832110f63fc0a2afce2fb21d1584 added a second bit per
page to the visibility map, but pg_upgrade has been unaware of it up
until now. Therefore, a pg_upgrade from an earlier major release of
PostgreSQL to any commit preceding this one and following the one
mentioned above would result in invalid visibility map contents on the
new cluster, very possibly leading to data corruption. This plugs
that hole.

Masahiko Sawada, reviewed by Jeff Janes, Bruce Momjian, Simon Riggs,
Michael Paquier, Andres Freund, me, and others.

Branch
------
master

Details
-------
http://git.postgresql.org/pg/commitdiff/7087166a88fe0c04fc6636d0d6d6bea1737fc1fb

Modified Files
--------------
src/bin/pg_upgrade/file.c | 154 +++++++++++++++++++++++++++++++++++++++
src/bin/pg_upgrade/pg_upgrade.h | 6 ++
src/bin/pg_upgrade/relfilenode.c | 48 +++++++++---
3 files changed, 197 insertions(+), 11 deletions(-)

Responses

Browse pgsql-committers by date

  From Date Subject
Next Message Joel Jacobson 2016-03-11 20:44:19 Re: [COMMITTERS] pgsql: Provide much better wait information in pg_stat_activity.
Previous Message Tom Lane 2016-03-11 17:28:00 pgsql: When appropriate, postpone SELECT output expressions till after

Browse pgsql-hackers by date

  From Date Subject
Next Message Robert Haas 2016-03-11 17:37:01 Re: Freeze avoidance of very large table.
Previous Message David Steele 2016-03-11 17:28:51 Re: Combining Aggregates