Replication sequence
От
Paolo Saudin
Тема
Replication sequence
Дата
Msg-id
CADtZQgnz9AvzigpeSBAyT53TrZRF42DqZVN7SscpN2DMkJDTYQ@mail.gmail.com
Список
Дерево обсуждения
Replication sequence Paolo Saudin <paolosaudin@gmail.com>
Re: Replication sequence Jehan-Guillaume de Rorthais <jgdr@dalibo.com>
Re: Replication sequence Paolo Saudin <paolosaudin@gmail.com>
Re: Replication sequence Jehan-Guillaume de Rorthais <jgdr@dalibo.com>
Re: Replication sequence Paolo Saudin <paolosaudin@gmail.com>
Re: Replication sequence Loles <lolesft@gmail.com>
Re: Replication sequence Paolo Saudin <paolosaudin@gmail.com>
Hi all,
I have two servers, a primary and a secondary one with a streaming replica setup.
Today I noticed that some sequences are not lined-up, the replica ones are well ahead, while the records number is the same. How is it possible?
Thanks,
Paolo
--
-- primary server
--
postgres@db-srv1:~$ psql
psql (9.5.19)
cf-db-srv1:5432 postgres@rete_llpp=# SELECT last_value FROM bobo.menu_pages_mp_id_seq;
┌────────────┐
│ last_value │
├────────────┤
│ 74 │
└────────────┘
cf-db-srv1:5432 postgres@rete_llpp=# select count(*) from bobo.menu_pages;
┌───────┐
│ count │
├───────┤
│ 74 │
└───────┘
psql (9.5.19)
cf-db-srv1:5432 postgres@rete_llpp=# SELECT last_value FROM bobo.menu_pages_mp_id_seq;
┌────────────┐
│ last_value │
├────────────┤
│ 74 │
└────────────┘
cf-db-srv1:5432 postgres@rete_llpp=# select count(*) from bobo.menu_pages;
┌───────┐
│ count │
├───────┤
│ 74 │
└───────┘
--
-- replica server
--
postgres@db-srv2:~$ psql
psql (9.5.24)
postgres@db-srv2:~$ psql
psql (9.5.24)
cf-db-srv2:5433 postgres@rete_llpp=# SELECT last_value FROM bobo.menu_pages_mp_id_seq;
┌────────────┐
│ last_value │
├────────────┤
│ 105 │
└────────────┘
│ last_value │
├────────────┤
│ 105 │
└────────────┘
cf-db-srv2:5433 postgres@rete_llpp=# select count(*) from bobo.menu_pages;
┌───────┐
│ count │
├───────┤
│ 74 │
└───────┘
│ count │
├───────┤
│ 74 │
└───────┘
В списке pgsql-general по дате отправления
От: Adrian Klaver
Дата: