Re: wrong sequence value in dump file - Mailing list pgsql-hackers

From Tom Lane
Subject Re: wrong sequence value in dump file
Date
Msg-id 1245511.1752678377@sss.pgh.pa.us
Whole thread Raw
In response to wrong sequence value in dump file  (Fabrice Chapuis <fabrice636861@gmail.com>)
Responses Re: wrong sequence value in dump file
List pgsql-hackers
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().

            regards, tom lane



pgsql-hackers by date:

Previous
From: Andres Freund
Date:
Subject: Re: Read-Write optimistic lock (Re: sinvaladt.c: remove msgnumLock, use atomic operations on maxMsgNum)
Next
From: Jacob Champion
Date:
Subject: Re: Explicitly enable meson features in CI