Fabrice Chapuis <fabrice636...@gmail.com> writes: > When dumping with pg_dump and the directory option, I got a sequence value > that is greater in the dump file than the sequence in the source database.
Perhaps you were dumping from a standby server? It's normal for
a standby to show a value up to 32 counts more than the primary,
because of some tricks that sequence.c plays to reduce the number
of WAL records generated for nextval().
regards, tom lane
