Gap in sequence after fail-over

Поиск
Список
Период
Сортировка
От Simon Luijk
Тема Gap in sequence after fail-over
Дата
Msg-id BANLkTin3ZF=AujmZqXtzbs3j8Xcy-pjwug@mail.gmail.com
обсуждение исходный текст
Ответы Re: Gap in sequence after fail-over
Список pgsql-admin
I have two test systems with Postgresql in Hot-standby configuration. The intention
is to fail-over to the slave every so often. When ever we switch servers (fail-over)
and start inserting data, the primary ids have a gap of ~30. From the following
thread form 2001 it seems this maybe expected?

http://archives.postgresql.org/pgsql-bugs/2001-12/msg00082.php

With a Hot-standby set-up like this, that regularly switches, can I not rely on
the sequence always incrementing by 1?

Thank you
Simon

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

Предыдущее
От: "Kevin Grittner"
Дата:
Сообщение: Re: Postgres 9 slave lag
Следующее
От: Simon Riggs
Дата:
Сообщение: Re: Gap in sequence after fail-over