PostgreSQL Agent for Gluesync: Features Overview

Gluesync consumes changes from PostgreSQL by implementing the CDC (Change data capture) technique to read transaction logs from PostgreSQL replication slots technology starting from version 10;

From the books:

Logical decoding is the process of extracting all persistent changes to a database’s tables into a coherent, easy-to-understand format that can be interpreted without detailed knowledge of the database’s internal state. In PostgreSQL, logical decoding is implemented by decoding the contents of the write-ahead log, which describes changes on a storage level, into an application-specific form such as a stream of tuples or SQL statements. In the context of logical replication, a slot represents a stream of changes that can be replayed to a client in the order they were made on the origin server. Each slot streams a sequence of changes from a single database.

Works on any version of PostgreSQL starting from 10.0.