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 réponse
1
Réponse acceptée

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
répondu il y a un an

Vous n'êtes pas connecté. Se connecter pour publier une réponse.

Une bonne réponse répond clairement à la question, contient des commentaires constructifs et encourage le développement professionnel de la personne qui pose la question.

Instructions pour répondre aux questions