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

Stopping Change Data Capture for a PostgreSQL Table

You might want to stop change data capture for a PostgreSQL source table if the table has been dropped, change activity no longer occurs on the table, or the data in the table is no longer of interest for CDC processing.

In PowerExchange Navigator, open the capture registration and set the

Status

option to

History

A capture registration that has a status of

History

cannot be activated again.

If you use the PowerExchange Logger for Linux, UNIX, and Windows, shut down the PowerExchange Logger and then warm start it.

This step refreshes the registration information that the PowerExchange Logger uses.

In PowerCenter, delete or update CDC workflows to make sure that no workflow processes the removed table.

Rename Saved Search

Table of Contents

CDC Guide for Linux, UNIX, and Windows

CDC Guide for Linux, UNIX, and Windows

Stopping Change Data Capture for a PostgreSQL Table

Stopping Change Data Capture for a PostgreSQL Table