Re: Streaming replication: sequences on slave seemingly ahead of sequences on master

Поиск
Список
Период
Сортировка
От Michael Nolan
Тема Re: Streaming replication: sequences on slave seemingly ahead of sequences on master
Дата
Msg-id CAOzAquLzW7K-EFByczEPBezmHuCjDVx2c76Ghc1UYG68hHEMiA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Streaming replication: sequences on slave seemingly ahead of sequences on master  (Vincent de Phily <vincent.dephily@mobile-devices.fr>)
Список pgsql-general
Дерево обсуждения
This is due to how sequences are pre-allocated in blocks to sessions running on the master.

Since the slave is updated via the WALs, and not via 'nextval' function calls in queries, the sequences that are actually used will remain in sync with the master.
--
Mike Nolan

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

Предыдущее
От: Vincent de Phily
Дата:
Сообщение: Re: Streaming replication: sequences on slave seemingly ahead of sequences on master
Следующее
От: Rebecca Clarke
Дата:
Сообщение: .pgpass not working