我正在尝试使用AWS DMS迁移和同步PostgreSQL数据库，但出现以下错误。
Last Error Task error notification received from subtask 0, thread 0 [reptask/replicationtask.c:2673] [1020487]
RetCode: "SQL_ERROR SqlState: 42703 NativeError: 1
Message: ERROR: column "xlog_position" does not exist; No query has been executed with that handle; RetCode: SQL_ERROR SqlState: 42P01 NativeError: 1
Message: ERROR: relation "pglogical.replication_set" does not exist; No query has been executed with that handle; RetCode: SQL_ERROR SqlState: 42703 NativeError: 1 Message: ERROR: column "xlog_position" does not exist; No query has been executed with that handle;
Could not find any supported plugins available on source; Could not resolve default plugin; Could not assign a postgres plugin to use for replication; Failure in setting Postgres CDC agent control structure; Error executing command; Stream component failed at subtask 0, component st_0_JX7ONUUGB4A2AR2VQ4FMEZ7PFU ; Stream component 'st_0_JX7ONUUGB4A2AR2VQ4FMEZ7PFU' terminated [reptask/replicationtask.c:2680] [1020487] Stop Reason FATAL_ERROR Error Level FATAL
我正在使用两个PostgreSQL实例作为源和目标。我已经测试并验证了复制实例可以访问两个数据库实例。目标实例用户对数据库具有完全访问权限。我是否需要安装任何插件或进行其他配置才能使此迁移设置正常工作？
最佳答案
我设法按照下面提到的步骤解决了这个问题
https://docs.aws.amazon.com/dms/latest/userguide/CHAP_Source.PostgreSQL.html。
该问题是由于我正在使用DMS引擎v3.1.4所致，该引擎需要一些其他配置才能启动复制过程。这些说明可以在https://docs.aws.amazon.com/dms/latest/userguide/CHAP_Source.PostgreSQL.html#CHAP_Source.PostgreSQL.v10中找到
如果遇到此问题，请仔细检查DMS复制引擎版本。可以在“资源管理”中的“复制实例”下查看。