pgsql: Clean up some aspects of pg_dump/pg_restore item-selection logic

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Clean up some aspects of pg_dump/pg_restore item-selection logic
Date: 2018-01-25 19:26:29
Message-ID: E1eenAL-0002OA-3F@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Clean up some aspects of pg_dump/pg_restore item-selection logic.

Ensure that CREATE DATABASE and related commands are issued when, and
only when, --create is specified. Previously there were scenarios
where using selective-dump switches would prevent --create from having
any effect. For example, it would fail to do anything in pg_restore
if the archive file had been made by a selective dump, because there
would be no TOC entry for the database.

Since we don't issue \connect either if we don't issue CREATE DATABASE,
this could result in unexpectedly restoring objects into the wrong
database.

Also fix pg_restore's selective restore logic so that when an object is
selected to be restored, we also restore its ACL, comment, and security
label if any. Previously there was no way to get the latter properties
except through tedious mucking about with a -L file. If, for some
reason, you don't want these properties, you can match the old behavior
by adding --no-acl etc.

While at it, try to make _tocEntryRequired() a little better organized
and better documented.

Discussion: https://postgr.es/m/32668.1516848577@sss.pgh.pa.us

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/0d4e6ed3085828edb68f516067d45761c0a89ac5

Modified Files
--------------
doc/src/sgml/ref/pg_restore.sgml | 7 +-
src/bin/pg_dump/pg_backup_archiver.c | 226 +++++++++++++++++++++--------------
src/bin/pg_dump/pg_dump.c | 9 +-
3 files changed, 153 insertions(+), 89 deletions(-)

Browse pgsql-committers by date

  From Date Subject
Next Message Tom Lane 2018-01-25 19:32:34 pgsql: Add missing "static" markers.
Previous Message Alvaro Herrera 2018-01-25 19:12:41 pgsql: Ignore partitioned indexes where appropriate