PostgreSQL Agent for Gluesync: Features Overview

Index

Core principles

This agent establishes a connection to PostgreSQL via a built-in JDBC driver.

Change data capture

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.

Supported version

With this agent, you can target any version of PostgreSQL starting from 9.0.

Platform supported features

Feature	Support	Notes
Target role	✅	Streams data into PostgreSQL through the bundled JDBC driver with TLS and pooling support.
Source role	✅	Reads logical replication slots/WAL to capture database changes from PostgreSQL 10+.
Snapshots	✅	Supports full-table snapshots for initial syncs or periodic reseeding.
CDC	✅	Continuously replays WAL records exposed via logical decoding.
CDC type	Logical decoding (WAL)	Uses PostgreSQL replication slots to emit change events as tuples/SQL statements, requires WAL and Wal2Json to be enabled.
User defined data types	✅	Supports user defined data types.
Bulk load	✅	Leverages staging-table Bulk load flows (COPY, MERGE) for large mirroring batches.
Source persisted internal cache	N/A	Depends on Core Hub metadata/state tables; no extra disk cache on the agent.
Target persisted internal cache	N/A	Writes go straight to PostgreSQL without intermediate file buffers.
Driver / connector	Built-in JDBC driver	Gluesync packages the vendor JDBC driver for secure, high-performance connectivity.
Chains	N/A	Not supported.
Truncate operation support (reading)	✅	Source agent can capture and forward TRUNCATE operations to the target.
Truncate operation support (writing)	✅	Supports Core Hub’s “TRUNCATE before snapshot” option when acting as a target.

Feature

Support

Notes

Target role

✅

Streams data into PostgreSQL through the bundled JDBC driver with TLS and pooling support.

Source role

✅

Reads logical replication slots/WAL to capture database changes from PostgreSQL 10+.

Snapshots

✅

Supports full-table snapshots for initial syncs or periodic reseeding.

CDC

✅

Continuously replays WAL records exposed via logical decoding.

CDC type

Logical decoding (WAL)

Uses PostgreSQL replication slots to emit change events as tuples/SQL statements, requires WAL and Wal2Json to be enabled.

User defined data types

✅

Supports user defined data types.

Bulk load

✅

Leverages staging-table Bulk load flows (COPY, MERGE) for large mirroring batches.

Source persisted internal cache

N/A

Depends on Core Hub metadata/state tables; no extra disk cache on the agent.

Target persisted internal cache

N/A

Writes go straight to PostgreSQL without intermediate file buffers.

Driver / connector

Built-in JDBC driver

Gluesync packages the vendor JDBC driver for secure, high-performance connectivity.

Chains

N/A

Not supported.

Truncate operation support (reading)

✅

Source agent can capture and forward TRUNCATE operations to the target.

Truncate operation support (writing)

✅

Supports Core Hub’s “TRUNCATE before snapshot” option when acting as a target.

Change data capture

Works on any version of PostgreSQL starting from 10.0.