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

Question

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?

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

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

Relevanter Inhalt