Logical decoding

[tcapturesupport]

Logical decoding provides the ability to stream modifications made via SQL to external consumers.

To be able to use logical decoding you need to install a plugin into postgresql to transform the WAL internal representation to a format the client can use.

This output plugin for logical replication generates raw queries based on the logical changes it finds. Those queries can be consumed as they are by any remote source.

TCapture uses an output plugin, called rdblogdec, that adds transaction information to the logical decoding .
rdblogdec is an evolution of the decoder_raw plugin , a SQL Format Plugins. This output plugin for logical replication generates raw queries based on the logical changes it finds. Those queries can be consumed as they are by any remote source.

References:

https://wiki.postgresql.org/wiki/Logical_Decoding_Plugins
https://github.com/michaelpq/pg_plugins/tree/main/decoder_raw
https://paquier.xyz/postgresql-2/postgres-9-4-feature-highlight-logical-replication-receiver/