pg_dump: Allow dumping data of specific foreign servers

Enterprise / PostgreSQL - Alvaro Herrera [alvh.no-ip.org] - 25 March 2020 16:19 EDT

The new command-line switch --include-foreign-data=PATTERN lets the user specify foreign servers from which to dump foreign table data. This can be refined by further inclusion/exclusion switches, so that the user has full control over which tables to dump.

A limitation is that this doesn't work in combination with parallel dumps, for implementation reasons. This might be lifted in the future, but requires shuffling some code around.

Author: Luis Carril

2f9eb31320 pg_dump: Allow dumping data of specific foreign servers
doc/src/sgml/ref/pg_dump.sgml | 30 ++++++++
src/bin/pg_dump/pg_dump.c | 110 +++++++++++++++++++++++++--
src/bin/pg_dump/pg_dump.h | 1 +
src/bin/pg_dump/t/001_basic.pl | 14 +++-
src/bin/pg_dump/t/003_pg_dump_with_server.pl | 36 +++++++++
5 files changed, 185 insertions(+), 6 deletions(-)

Upstream: git.postgresql.org


  • Share