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

PostgreSQL: Set Replica Identity when the connector starts

    XMLWordPrintable

Details

    • False
    • None
    • False
    • 0
    • 0% 0%

    Description

      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

      Attachments

        Issue Links

          Activity

            People

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

              Dates

                Created:
                Updated:
                Resolved: