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
Hi,
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.
The sequence is defined as:
CREATE SEQUENCE id_seq_test
INCREMENT BY 1
MINVALUE 1
MAXVALUE 190
START 1000
CACHE 1
