pg_upgrade: Upgrade sequence data via pg_dump
Peter Eisentraut <peter_e@gmx.net>
pg_upgrade: Upgrade sequence data via pg_dump Previously, pg_upgrade migrated sequence data like tables by copying the on-disk file. This does not allow any changes in the on-disk format for sequences. It's simpler to just have pg_dump set the new sequence values as it normally does. To do that, create a hidden submode in pg_dump that dumps sequence data even when a schema-only dump is requested, and trigger that submode in binary upgrade mode. (This new submode could easily be exposed as a command-line option, but it has limited use outside of pg_dump and would probably cause some confusion, so we don't do that at this time.) Reviewed-by: Anastasia Lubennikova <a.lubennikova@postgrespro.ru> Reviewed-by: Michael Paquier <michael.paquier@gmail.com>
Files
| Path | Change | +/− |
|---|---|---|
| src/bin/pg_dump/pg_backup_archiver.c | modified | +5 −1 |
| src/bin/pg_dump/pg_backup.h | modified | +3 −0 |
| src/bin/pg_dump/pg_dump.c | modified | +15 −4 |
| src/bin/pg_upgrade/info.c | modified | +1 −1 |