Hi all, (Bertrand and Andres in CC.) While listening at Bertrand's talk about logical decoding on standbys last week at Prague, I got surprised by the fact that we do not reflect in the catalogs the reason why a conflict happened for a slot. There are three of them depending on ReplicationSlotInvalidationCause: - WAL removed. - Invalid horizon. - Insufficient WAL level.
This idea has been hinted around here on the original thread that led to be87200efd93: https://www.postgresql.org/message-id/[email protected] However v44 has picked up the idea of a boolean: https://www.postgresql.org/message-id/[email protected] ReplicationSlotCtl holds this information, so couldn't it be useful for monitoring purposes to know why a slot got invalidated and add a column to pg_get_replication_slots()? This could just be an extra text conflicting_reason, defaulting to NULL when there's nothing to see. Thoughts? -- Michael
signature.asc
Description: PGP signature
