Re: Problems with Binary Replication

Andreas <maps.on@gmx.net> 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