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

Manually Creating the Replication Store Table

If you need to customize the replication store table to suit your environment, you can manually create the table instead of letting the PowerExchange capture process automatically generate it.

For example, you might want to customize the table to support table partitions.

To create the table, use the following sample SQL statements:

CREATE TABLE table_name(
         id bigserial,
         lsn pg_lsn NOT NULL,
         xid xid NOT NULL,
         data text NOT NULL);
CREATE UNIQUE INDEX ON table_name (id);
CREATE INDEX ON table_name (lsn);

Make sure that your customizations are compatible with the column definitions in the sample SQL.

If you use a table name other than the default name of public.pwx_repl, enter the custom name in the REPLSTORETBL parameter in the PG CAPI_CONNECTION statement in the dbmover.cfg file.

Rename Saved Search

Table of Contents

CDC Guide for Linux, UNIX, and Windows

CDC Guide for Linux, UNIX, and Windows

Manually Creating the Replication Store Table

Manually Creating the Replication Store Table