4回答
- 新しい順
- 投票が多い順
- コメントが多い順
0
I'm actually seeing the same issue. The only resource I could come up with is this: https://stackoverflow.com/questions/44018819/aws-dms-streaming-replication-logical-decoding-output-pluginstest-decoding-n
回答済み 3年前
0
Reading the docs:
https://docs.aws.amazon.com/dms/latest/userguide/CHAP_Source.PostgreSQL.html#CHAP_Source.PostgreSQL.RDSPostgreSQL
It says:
This static parameter requires a reboot of the DB instance to take effect.
So reboot your RDS instance after making the paramater group change and you should be all set.
Edited by: rseedfi on Jun 30, 2021 8:30 PM
回答済み 3年前
0
Here are steps required for AWS managed PostgreSQL database:
- The admin user account has the required roles that allow it to set up CDC. If you use an account other than the admin user account, the account must have the rds_superuser role and the rds_replication role. The rds_replication role grants permissions to manage logical slots and to stream data using logical slots.
- rds.logical_replication parameter in your DB CLUSTER parameter group to 1
- wal_sender_timeout DMS requires a minimum of 10000 milliseconds (10 seconds), and fails if the value is between 0 and 10000.
- shared_preload_libraries should include pglogical
回答済み 1年前