PostgreSQL Transactional Replication Settings

Enable Transactional Replication wizard or the Manage Transactional Log Settings dialog

The information below explains how to configure the transactional replication settings for PostgreSQL in the Enable Transactional Replication wizard or the Manage Transactional Log Settings dialog available from the Transactional Setup > Manage option on the connection in the Metadata Explorer.

When replicating from PostgreSQL using mirroring or synchronization, one transactional mode is available: Log Server Agent.

Log Settings

Decoding Plugin: Plugin Name

The default plugin is called ‘test_decoding’ and is normally installed with every PostgreSQL installation. To verify availability, check the location where the decoding plugins are normally installed:

MS Windows	<Postgres installation folder>/lib
Ubuntu	/usr/lib/postgres/9.5/lib
RedHat	/usr/pgsql-9.5/lib

If the plugin is missing, you can either install it using the Postgres installation files, or request a file from the technical support team via the Help Center to install the dbm_decoding plugin. Note that if you are using PostgreSQL as a cloud database, you need to use the test_decoding plugin.

Replication Slot: Use Existing Slot

Replication slots are channels that you open on the database to allow Syniti DR to receive data changes from the log. While the default is to use a new slot specifically for a Syniti DR connection, it is possible to reuse an existing slot if it is not consumed by any other connection. A replication slot has to be uniquely assigned to a single Syniti DR connection.

Replication Slot: Add New Slot

Syniti DR needs to define a “replication_slot” for every connection that it uses to replicate from PostgreSQL. This option allows you to set up a new slot from Syniti DR. However, the new slot will be added only if the maximum number of slots has not been exceeded. This value is set in the postgresql.conf file. Be aware that if slots are created then left unused, they still consume resources, so you should always manage replication slots carefully.

For more information on replication slots and the settings needed for transactional replications from PostgreSQL, see PostgreSQL Database Setup

Verify (available only in the Manage Transactional Log Settings dlialog)