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:28
Message-ID: E1ZaUM5-0000vx-05@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_3_STABLE

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

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

Browse pgsql-committers by date

  From Date Subject
Next Message Bruce Momjian 2015-09-11 19:51:29 pgsql: pg_dump, pg_upgrade: allow postgres/template1 tablespace moves
Previous Message Robert Haas 2015-09-11 18:56:40 pgsql: Fix build problems in commit aa65de042f5828968f2f6cd65f45c543a40