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
asked 3 months ago94 views
No Answers

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions