I can highly recommend the Database Migration Service, used it to migrate a production DB into RDS without any downtime. True black magic!
Snapshot process works only for RDS not for a database running on EC2. You options are
- Use pg_dump/pg_restore into a new RDS instance
- Set up replication, either native logical replication or using DMS.
--> DMS will be a good choice with minimal downtime. However it comes with some limitations. [+] https://docs.aws.amazon.com/dms/latest/userguide/CHAP_Source.PostgreSQL.html#CHAP_Source.PostgreSQL.Limitations
--> native tool pg_dump and pg_restore will face downtime.
To answer your previous questions:
- It supports cross account cross region. As long as VPCs are communicating with each other. You may also migrating through internet. [+] https://docs.aws.amazon.com/dms/latest/userguide/CHAP_ReplicationInstance.VPC.html
- Using DMS Performance impact to the source should be minimal. Depends what are the task configurations such as (whether parallel-load during fullload, or some customers will create multiple tasks to migrate from source, then that will be causing some burden to the source)
- with pg_dump and pg_restore. You basically treat PostgreSQL on EC2 as on-prem. As long as you have one machine (Can be another EC2 or local machine) having access to EC2 and RDS. Follow the steps in [+] https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/PostgreSQL.Procedural.Importing.EC2.html
Hope above helps.
- Accepted AnswerEXPERTasked 3 years ago
- asked 3 months ago
- AWS OFFICIALUpdated a year ago
- AWS OFFICIALUpdated 7 months ago
- How can I connect Amazon QuickSight to a private Amazon RDS data source in a different AWS Region or AWS account?AWS OFFICIALUpdated a year ago
- How can I associate a Route 53 health check from a different AWS account to a record set in my account?AWS OFFICIALUpdated a year ago
- EXPERTpublished 7 months ago
- EXPERTpublished 2 months ago