pgsql: pg_dump: Allow dumping data of specific foreign servers

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

pgsql: pg_dump: Allow dumping data of specific foreign servers

Álvaro Herrera
pg_dump: Allow dumping data of specific foreign servers

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 <[hidden email]>
Reviewed-by: Daniel Gustafsson <[hidden email]>
Reviewed-by: Surafel Temesgen <[hidden email]>
Reviewed-by: vignesh C <[hidden email]>
Reviewed-by: Álvaro Herrera <[hidden email]>
Discussion: https://postgr.es/m/LEJPR01MB0185483C0079D2F651B16231E7FC0@...

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/2f9eb31320948b968e5f744b73032405e1f25225

Modified Files
--------------
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(-)