sequence sync option with pg_dump

Question

I use pg_dump to backup and restore to target and manually sync (using setval function) sequences on tables. Is following an option to avoid manual sync or manual sync is always required?

pg_dump -s (schema-only) + pg_dump -a (only data from tables/LOB/Sequence Values)

And then i use pg_restore in same order which sync the sequences automatically

Define *manually sync sequences on tables* as update to question. — Adrian Klaver, Dec 14 '22 at 21:42
question updated adrian. I am using setval function to sync the sequences after pg_restore — Falcon, Dec 15 '22 at 19:07

score 1 · Answer 1 · answered Dec 15 '22 at 03:41

1

To get a script that sets the value of a sequence seq, you can run a data-only pg_dump for this sequence:

pg_dump -a -t seq

answered Dec 15 '22 at 03:41

Laurenz Albe

209,280
17
206
263

sequence sync option with pg_dump

1 Answers1