• Sources: primary
  • Summary: Regions own rows through a region column in every primary key, and row-filtered publications prevent loops where origin = none would drop relayed rows. With synchronized_standby_slots set, consumers saw duplicates but no holes after a primary kill, and emptying it left consumers 69 to 92 rows ahead of the new primary. A killed hub delayed downstream rows by about 54 seconds and lost nothing.
  • Why it matters: It shows which Postgres 17 to 19 settings make logical replication survive failover and how to check a consumer's position with IDENTIFY_SYSTEM.