1 Answer
- Newest
- Most votes
- Most comments
0
Hi,
There are currently some points that should be taken into consideration when using PostgreSQL as a source database in DMS. For the moment, when a partitioned table is detected, the following occurs:
- The endpoint reports a list of parent and child tables.
- AWS DMS creates the table on the target as a regular table with the same properties as the selected tables.
- If the parent table in the source database has the same primary key value as its child tables, a "duplicate key" error is generated.
You can find the full list of limitations when using PostgreSQL as a DMS source on https://docs.aws.amazon.com/dms/latest/userguide/CHAP_Source.PostgreSQL.html#CHAP_Source.PostgreSQL.Limitations
Thanks.
Relevant content
- asked 7 months ago
- asked a year ago
- asked 10 months ago
- AWS OFFICIALUpdated a year ago
- AWS OFFICIALUpdated a year ago
- AWS OFFICIALUpdated 2 years ago