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?