Sunsetting the Logical Replication with test_decoding Update Method

Question

Why is logical replication with the test_decoding plugin no longer an incremental sync option?

Environment

Connector: PostgreSQL

Answer

We are sunsetting this incremental sync method. Learn more in our Logical replication documentation.

If your connector currently uses test_decoding, we will initiate the migration process for you. Learn more in the March 2023 PostgreSQL changelog.

IMPORTANT: If your table does not have a primary key, you must set up a replica identity in order to publish update and delete operations. Otherwise, we must exclude the connector from the migration. Learn more in our Tables without a primary key documentation.

See our Troubleshooting documentation for help in migrating your test_decoding connector to pgoutput.