Fabrice Chapuis <fabrice636861@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().
