Ok, effectively the dump comes from a standby. Thanks for your explanation.
Best regards, Fabrice On Wed, Jul 16, 2025 at 5:06 PM Tom Lane <[email protected]> wrote: > Fabrice Chapuis <[email protected]> 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 >
