Re: Replication sequence - Mailing list pgsql-general

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 │
└───────┘

--

-- replica server

--
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 │
└────────────┘

cf-db-srv2:5433 postgres@rete_llpp=# select count(*) from bobo.menu_pages;

┌───────┐
│ count │
├───────┤
│    74 │
└───────┘