At the conclusion of <f6ed028e-ac25-e849-aec6-8d69416f0...@2ndquadrant.com>, pg_upgrade was changed to upgrade sequences "logically". We initially did that by adding a pg_dump option --sequence-data that would dump sequence data (setval calls) in spite of --schema-only. Later, that option was removed as a separate option and made automatic in --binary-upgrade, because we didn't think it was useful independently.
For logical replication, sequence data is not replicated at the moment. So it could be useful in some cases to have a simple way to dump just the sequence data. So I think it would be worth adding that option back. Comments? -- Peter Eisentraut http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers