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
gefragt vor 3 Monaten99 Aufrufe
Keine Antworten

Du bist nicht angemeldet. Anmelden um eine Antwort zu veröffentlichen.

Eine gute Antwort beantwortet die Frage klar, gibt konstruktives Feedback und fördert die berufliche Weiterentwicklung des Fragenstellers.

Richtlinien für die Beantwortung von Fragen