Quickest way to migrate a pgsql database from one RDS cluster to another

0

I have a postgresql database that I need to migrate from aurora v1 rds cluster to another aurora v2 cluster, I tried the backup and restore method using pgadmin tool but it will take around one hour the whole process due to the size of data. I'm wondering if there could be a quicker way to achieve this migration?

1 Answer
1
Accepted Answer

Hey there. Yes that’s one option I have used in the past. But like you say a big dataset can take time.

Database migration as such will take as long as how much data there is.

However, AWS do offer a service that can do this for you. DMS which I also use. You can migrate and keep in sync data from one DB to another.

Please see https://docs.aws.amazon.com/dms/index.html

profile picture
EXPERT
answered a year ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions