Uploaded image for project: 'Debezium'
  1. Debezium
  2. DBZ-6112

PostgreSQL: Set Replica Identity when the connector starts

XMLWordPrintable

    • False
    • None
    • False

      Which use case/requirement will be addressed by the proposed feature?

      Replica Identity is an essential setting to control the amount of information emitted on UPDATE and DELETE operations, having it set incorrectly can lead to data loss.

      The only option to configure REPLICA IDENTITY right now is to set it up manually or include it in a CD pipeline.

      The proposal is to rely on Debezium to set it up, based on a new property in the connector configuration.

       

      Link to Zulip conversation

      Implementation ideas (optional)

      • A new property called "replica.type" containing a structure like "<fully-qualified_tableName>:<type>" where <type> is "DEFAULT / NOTHING/ FULL / INDEX" and <fully-qualified_tableName>¬†tables must be included in <tables.include.list> property
      • We can add a method called "initReplicaIndentity" in PostgresReplicationConnection class to set that property in PostgreSQL. This method will check the value of the replica identity before applying any change
      • The new property will be optional in the connector configuration

            Unassigned Unassigned
            miguel.sotomayor Miguel Sotomayor
            Votes:
            1 Vote for this issue
            Watchers:
            5 Start watching this issue

              Created:
              Updated:
              Resolved: