PowerExchange captures Begin, Insert, Update, Delete, Commit, and Truncate operations for source transactions. PowerExchange does not capture DDL changes other than Truncate. Also, most PostgreSQL data types are supported.

PowerExchange retrieves the changes from a PostgreSQL logical replication slot that is reserved for PowerExchange use. PowerExchange then records the changes in the

replication store table

that either PowerExchange generates during capture processing or that you manually create in the source database.

The source database must use logical replication mode. Also, each source table must have a primary key.

To prepare PostgreSQL source for CDC, perform the following tasks:

To configure PowerExchange for PostgreSQL sources, specify the new PG CAPI_CONNECTION statement in the dbmover.cfg configuration file. Also, create capture registrations and extraction maps for the source tables by using either the PowerExchange Navigator or DTLUCBRG utility. Both interfaces have been enhanced to support PostgreSQL sources.

Also, PowerExchange requires the DataDirect ODBC driver for PostgreSQL to retrieve source metadata from the PostgreSQL database server. This driver is delivered as part of the PowerExchange installation. You do not need to download it.

Use of the PowerExchange Logger for Linux, UNIX, and Windows is optional.

For more information, see the

PowerExchange CDC Guide for Linux, UNIX, and Windows

, the

PowerExchange Navigator User Guide

, and

PowerExchange Utilities Guide

.