Error: RDS Proxy Currently Doesn’t Support Streaming Replication Mode

Issue

The Amazon RDS for PostgreSQL connector syncs fail with the following error:

FATAL: Feature not supported: RDS Proxy currently doesn't support streaming replication mode

Environment

Connector: Amazon RDS PostgreSQL

Resolution

To resolve this issue, delete all RDS Proxies from your Amazon RDS environment. See Amazon's Deleting an RDS Proxy documentation for more information.

Alternatively, update your connector to use XMIN or Fivetran Teleport Sync as the incremental sync method. To update the an existing connector's incremental sync method, do the following:

1. In Fivetran, go to your Amazon RDS PostgreSQL connector page.
2. Select the Setup tab.
3. Click Edit connection.
4. Under Update Method, select either Detect Changes via XMIN or Detect Changes via Fivetran Teleport Sync.
5. Click Save & Test.

Cause

This issue occurs when your Amazon RDS environment utilizes an RDS Proxy, and you configure your connector to use the logical replication incremental sync method.

RDS Proxy doesn't support streaming replication. See Amazon's RDS Proxy Troubleshooting documentation for more information. As a result, our logical replication incremental sync method is incompatible with Amazon RDS environments with an active RDS Proxy.