Обсуждение: [HACKERS] pg_dump --sequence-data option

At the conclusion of
<f6ed028e-ac25-e849-aec6-8d69416f0090@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