One thing is the number of records in the table and another is the current value of the sequence.
Execute: select max (field) from bobo.menu_pages; In both master and slave server. What give you back? "field" is the data that belongs to the sequence. El lun., 15 feb. 2021 18:55, Paolo Saudin <paolosau...@gmail.com> escribió: > 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 │ > └───────┘ > >
