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 wrote:
> Fabrice Chapuis writes:
> > When dumping with pg_dump and the directory option, I got a sequence
> value
> > that is greater in the dump file tha
Fabrice Chapuis 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 th