summaryrefslogtreecommitdiff
path: root/src/bin/pg_upgrade/dump.c
diff options
context:
space:
mode:
authorNathan Bossart <nathan@postgresql.org>2025-03-25 16:02:35 -0500
committerNathan Bossart <nathan@postgresql.org>2025-03-25 16:02:35 -0500
commit9c49f0e8cd7d59e240f5da88decf2d62d8a4ad0d (patch)
treeec2d4351a3f08556a82a7fdef548e016fecc4c1b /src/bin/pg_upgrade/dump.c
parentcf131fa942855acd42e8283185837566c7e8c15e (diff)
pg_dump: Add --sequence-data.
This new option instructs pg_dump to dump sequence data when the --no-data, --schema-only, or --statistics-only option is specified. This was originally considered for commit a7e5457db8, but it was left out at that time because there was no known use-case. A follow-up commit will use this to optimize pg_upgrade's file transfer step. Reviewed-by: Robert Haas <robertmhaas@gmail.com> Discussion: https://postgr.es/m/Zyvop-LxLXBLrZil%40nathan
Diffstat (limited to 'src/bin/pg_upgrade/dump.c')
-rw-r--r--src/bin/pg_upgrade/dump.c2
1 files changed, 1 insertions, 1 deletions
diff --git a/src/bin/pg_upgrade/dump.c b/src/bin/pg_upgrade/dump.c
index 23fe7280a16..b8fd0d0acee 100644
--- a/src/bin/pg_upgrade/dump.c
+++ b/src/bin/pg_upgrade/dump.c
@@ -52,7 +52,7 @@ generate_old_dump(void)
snprintf(log_file_name, sizeof(log_file_name), DB_DUMP_LOG_FILE_MASK, old_db->db_oid);
parallel_exec_prog(log_file_name, NULL,
- "\"%s/pg_dump\" %s --no-data %s --quote-all-identifiers "
+ "\"%s/pg_dump\" %s --no-data %s --sequence-data --quote-all-identifiers "
"--binary-upgrade --format=custom %s --no-sync --file=\"%s/%s\" %s",
new_cluster.bindir, cluster_conn_opts(&old_cluster),
log_opts.verbose ? "--verbose" : "",