AWS, RDS: How to migrate +40GB Postgres database from AWS ec2 instance to RDS using hard disk files?

Question

It seems migrating Postgres database using data directory is viable:

How To Move a PostgreSQL Data Directory to a New Location on Ubuntu 16.04

But in case of RDS because SSHing to the RDS is not possible I am here to ask if there is any way to speed up my Postgres database migration.

John Rotenstein · Accepted Answer · 2019-01-18 07:58:56Z

1

You could use the AWS Database Migration Service:

AWS Database Migration Service (AWS DMS) is a cloud service that makes it easy to migrate relational databases, data warehouses, NoSQL databases, and other types of data stores. You can use AWS DMS to migrate your data into the AWS Cloud, between on-premises instances (through an AWS Cloud setup), or between combinations of cloud and on-premises setups.

answered Jan 18, 2019 at 7:58

John Rotenstein

273k28 gold badges456 silver badges541 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

AWS, RDS: How to migrate +40GB Postgres database from AWS ec2 instance to RDS using hard disk files?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related