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 <luis.car...@swarm64.com> Reviewed-by: Daniel Gustafsson <dan...@yesql.se> Reviewed-by: Surafel Temesgen <surafel3...@gmail.com> Reviewed-by: vignesh C <vignes...@gmail.com> Reviewed-by: Álvaro Herrera <alvhe...@2ndquadrant.com> Discussion: https://postgr.es/m/lejpr01mb0185483c0079d2f651b16231e7...@lejpr01mb0185.deuprd01.prod.outlook.de 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(-)
