PostgresRDS 9.4.20 AWS DMS source pglogical shared_preload_libraries param

Question

So I'm trying to use a PostgresRDS 9.4.20 as a source for AWS DMS cdc.  It errors out saying pglogical is not available.  I got the same error with a PostgresRDS 9.6 but I was able to fix this by adding pglogical to the shared_preload_libraries parameter group used by the rds.  However I cannot add it to the parameter group used by my 9.4.20 rds because it is not a allowed value in that version.  Can you please let me know how to overcome this hiccup without upgrading my rds version?

Accepted Answer

Hello,  
  
RDS Postgres does not support pglogical in the 9.4 major version. The only logical decoding plugin we offer for 9.4 is test_decoding.  
  
For a full list of extensions and the versions we support them in please consult:  
https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/CHAP_PostgreSQL.html#PostgreSQL.Concepts.General.FeatureSupport.Extensions  
  
Thanks,  
John H

Answer

How do I install/enable test_decoding on a database in aws postgres rds 9.4.20?  
  
Ah found it: SELECT * FROM pg_create_logical_replication_slot('test_slot', 'test_decoding');

PostgresRDS 9.4.20 AWS DMS source pglogical shared_preload_libraries param

相关内容