Andreas <[email protected]> writes:
> Now I added 1 row on the master.
> Before both sequence start values were 403.
> After the insert the master shows 404 as expected but the "hot-standby"
> shows 436.
What are you doing to get it to "show" a value --- not nextval(),
presumably?
I think that this may be the expected behavior from pre-caching of
sequence values. You would see the same thing on the master if you
were to forcibly crash and restart it.
regards, tom lane
--
Sent via pgsql-general mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general