dms homogeneous migration full load fails on more than 1 table present.

1

I am trying out DMS as a proof of concept from postgres RDS to postgres RDS - when migrating a databse containing only 1 table no problem is encountered however when attempting to migrate a larger database with multiple tables it fails.

Looking at the cloud watch logs the

+===== Source Table Capture List ========+

log entry does not list any tables present in the source database. Further investigation looking into the RDS error logs reveals a potential problem:

STATEMENT: SELECT count(*) AS partitions FROM pg_catalog.pg_inherits WHERE inhparent='"public"."firstsourcetable
public"."secondsourcetable
public"."thirdsourcetable"'::regclass;

Yielding the following error:

ERROR: improper relation name (too many dotted names): public.firstsourcetable
public.secondsourcetable
public.thirdsourcetable at character 77

Testing with only 2 tables present in the source database shows the same symptons however with a different error in the RDS error logs:

ERROR: cross-database references are not implemented: "public.secondsourcetable
public.firstsourcetable" at character 77

i am unsure if this is a bug when doing homogeneous postgres migrations, if it is a user error or misunderstanding of migrating multiple tables (from the same database) at a time?

Qarma
已提问 3 个月前99 查看次数
没有答案

您未登录。 登录 发布回答。

一个好的回答可以清楚地解答问题和提供建设性反馈,并能促进提问者的职业发展。

回答问题的准则