does AWS DMS support partition tables from postgres
1
i'm trying to migrate instance postgres rds to another aws postgres instance it seams when i migrate my database lose the partition tables of postgres database i'm currently using postgres 13
asked 6 months ago158 views
1 Answers
1
Yes , AWS DMS do support partition tables in postgresql. Please see below https://docs.aws.amazon.com/dms/latest/userguide/CHAP_Source.PostgreSQL.html#CHAP_Source.PostgreSQL.Homogeneous.DMS https://aws.amazon.com/blogs/database/migrate-to-native-partitioned-tables-in-postgresql-10-using-aws-database-migration-service/ https://aws.amazon.com/blogs/database/introducing-aws-dms-replication-engine-version-3-1-2/
answered 6 months ago
Relevant questions
Refactoring from Oracle to postgres, Do I need to drop foreign key constraitns at postgres
asked 4 days agodoes AWS DMS support partition tables from postgres
asked 6 months agoIssues connecting to Postgres RDS instance from within a VPC
asked 3 years agoUpgrade RDS Postgres engine from 9.6.11 to 10.6 - Migrate to Aurora
Accepted Answerasked 3 years agoHow to create SSL dblink connection from RDS to postgres on premise?
asked 5 months agoDMS task fails when Postgres DateStyle parameter is not ISO
asked a month agoDoes DMS support updating value of sequences in the target for postgres to postgres data migration?
asked a month agoDMS Migration MongoDB source and RDS Postgres as destination
Accepted Answerasked 20 days agoAWS DMS Postgres to OpenSearch LOB handling
asked 6 months agoETL from an Oracle database into RDS Postgres too slow
Accepted Answerasked 2 years ago