pgsql: pg_dump, pg_upgrade: allow postgres/template1 tablespace moves

From: Bruce Momjian <bruce(at)momjian(dot)us>
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: pg_dump, pg_upgrade: allow postgres/template1 tablespace moves
Date: 2015-09-11 19:51:29
Message-ID: E1ZaUM5-0000w0-0E@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

pg_dump, pg_upgrade: allow postgres/template1 tablespace moves

Modify pg_dump to restore postgres/template1 databases to non-default
tablespaces by switching out of the database to be moved, then switching
back.

Also, to fix potentially cases where the old/new tablespaces might not
match, fix pg_upgrade to process new/old tablespaces separately in all
cases.

Report by Marti Raudsepp

Patch by Marti Raudsepp, me

Backpatch through 9.0

Branch
------
REL9_2_STABLE

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

Modified Files
--------------
contrib/pg_upgrade/info.c | 18 ++++++++++++++++--
src/bin/pg_dump/pg_dumpall.c | 22 ++++++++++++++++++++++
2 files changed, 38 insertions(+), 2 deletions(-)

Browse pgsql-committers by date

  From Date Subject
Next Message Robert Haas 2015-09-11 20:48:27 pgsql: Install lwlocknames.h even in vpath builds.
Previous Message Bruce Momjian 2015-09-11 19:51:28 pgsql: pg_dump, pg_upgrade: allow postgres/template1 tablespace moves