Ultimate

X_LIVE_REPLICA_IDENTITY

Means

a replicated table has no replica identity

Typical cause

an entity table with no primary key under REPLICA IDENTITY DEFAULT, or with REPLICA IDENTITY NOTHING: once published, Postgres refuses its UPDATE and DELETE and a change cannot be keyed. A table with a primary key is never named (22.1.0; until then every non-FULL table was, on every boot). Warned at preflight, never thrown

Fix

ALTER TABLE <t> REPLICA IDENTITY FULL; or a primary key — one per table the warning names; rows already in the WAL keep the identity they were written with

Listed under Realtime

This page as markdown