Migrating a WAL Connector Using the test_decoding Plugin to the pgoutput Plugin

Question

How do I migrate my logical replication connector from the test_decoding plugin to the pgoutput plugin?

Environment

Connector: PostgreSQL

Answer

We are deprecating the test_decoding update method and migrating all customers to the pgoutput update method. Pgoutput is PostgreSQL’s native decoding plugin for V10+.

Follow the steps below to migrate from test_decoding to pgoutput:

1. Drop the existing test_decoding slot.
2. Create a publication and a new pgoutput slot. For more information, refer to the PostgreSQL connector setup guide.
3. In the connection setup form, change the Update Method to Logical Replication.
4. Add the publication name and pgoutput slot name in the setup form.
5. Click Save and Test.
6. Run a full re-sync.