CDC Guide for Linux, UNIX, and Windows

10.5
- 10.5.6
- 10.5.5
- 10.5.4
- 10.5.3
- 10.5.2
- 10.5.1
- 10.4.1
- 10.4.0 HotFix 1
- 10.4.0

Back Next

PostgreSQL Data Sources

PowerExchange reads DML and Truncate operations for registered PostgreSQL source tables from a PostgreSQL logical replication slot for PowerExchange use. PowerExchange then persists the changes in the PowerExchange replication store table
in the PostgreSQL database.

PowerExchange automatically creates the replication slot and replication store table when capture processing starts. If you want to customize the table for your environment, you can manually create the table before starting change capture.

Use of the PowerExchange Logger for Linux, UNIX, and Windows is optional. When a CDC session starts, PowerExchange can retrieve change records from either the replication slot in real time or from PowerExchange Logger for Linux, UNIX, and Windows log files.

PowerExchange captures Begin, Insert, Update, Delete, Commit, and Truncate operations for source transactions. PowerExchange does not capture DDL changes, other than Truncate operations, that are made to the PostgreSQL source.

Each source table must have a primary key.

PowerExchange CDC Data Sources

PostgreSQL CDC

Download Guide

Watch

Comments

Communities

Knowledge Base

Success Portal