Re: Problems with Binary Replication

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Problems with Binary Replication
Дата
Msg-id 27919.1333229938@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Problems with Binary Replication  (Andreas <maps.on@gmx.net>)
Ответы Re: Problems with Binary Replication
Список pgsql-general
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

В списке pgsql-general по дате отправления: