Aurora Postgres - Logical Replication with different databases in same instance
We are trying to setup logical replication with aurora postgres using different databases on same instance but the instance just hangs. Is this currently supported or is there anything special we need to do for it to work? Thanks!
It is possible that you have hit this -
When creating a replication slot (the default behavior), CREATE SUBSCRIPTION cannot be executed inside a transaction block. Creating a subscription that connects to the same database cluster (for example, to replicate between databases in the same cluster or to replicate within the same database) will only succeed if the replication slot is not created as part of the same command. Otherwise, the CREATE SUBSCRIPTION call will hang. To make this work, create the replication slot separately (using the function pg_create_logical_replication_slot with the plugin name pgoutput) and create the subscription using the parameter create_slot = false. This is an implementation restriction that might be lifted in a future release.
How to enable Logical Replication for existing Aurora PG 13 Cluster?asked 6 months ago
Aurora PostgreSQL Replica Pricingasked 2 years ago
Aurora Postgres - Logical Replication with different databases in same instanceasked 3 months ago
Is supported Timestamptz datatype in DMS postgres replication?asked 3 years ago
RDS PostgreSQL cascading replication for Fivetran integration (logical replication not working on replica)asked 2 days ago
"Create Aurora Read Replica" option not available to migrate from RDS Postgres 11.12 to Aurora 11.12.asked 2 months ago
XA Global Transaction Support for Aurora Postgresasked 3 months ago
Changes to connection handling with Aurora Postgres?Accepted Answerasked 3 years ago
Aurora Postgres 13 with IAM Auth - Unable to establish logical replication connectionasked 5 months ago
Unable to use plugins to establish logical replication on source PostgreSQLasked a year ago