Skip to main content

Limitations and considerations

The following limitations apply when using Amazon RDS for PostgreSQL as a source:

  • The database name cannot include a semi-colon (;).
  • Task names cannot start with "rds" as RDS is a reserved string on AWS.
  • Both the source table and the corresponding target table must have an identical Primary Key. In the event that one of the tables does not have a Primary Key, the result of DELETE and UPDATE record operations will be unpredictable.
  • The “Start Process Changes from Timestamp” run option is not supported.
  • Replication of the Before Image is not supported.
  • Replication of multiple tables with the same name but a different case (e.g. table1, TABLE1 and Table1) may cause unpredictable behavior and is therefore not supported.
  • Change processing of [CREATE | ALTER | DROP] table DDLs are supported, unless they are held in an inner function/procedure body block or in other nested constructs.

    For example, the following change will not be captured:

    CREATE OR REPLACE FUNCTION attu.create_distributors1() RETURNS void

    LANGUAGE plpgsql

    AS $$

    BEGIN

    create table attu.distributors1(did serial PRIMARY KEY,name varchar(40) NOT NULL);

    END;

    $$;

  • Change processing of TRUNCATE operations is not supported.
  • Deferred Constraints are not supported.
  • Partitioned tables

    • CDC is not supported.

  • When using the Parallel Load feature, table segmentation according to partitions or sub-partitions is not supported.
  • When using filters that do not contain a Primary Key, DELETE operations will not be captured.
  • A DDL operation that occurs during Full Load, but that was not preceded by a DML operation will not be captured.

  • PostGIS datatypes are not supported.

  • Unique Indexes with CASE expressions are not supported.

  • The SQL MERGE command introduced in PostgreSQL 15.x has not been certified.

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!