- Mais recentes
- Mais votos
- Mais comentários
To migrate your on-premises PostgreSQL database to Amazon RDS PostgreSQL with minimal downtime, you can follow a combination of strategies and best practices, leveraging tools like pg_dump
, pg_restore
, and AWS Database Migration Service (DMS).
For more details check out the following two docs:
- https://aws.amazon.com/blogs/database/best-practices-for-migrating-postgresql-databases-to-amazon-rds-and-amazon-aurora/
- https://docs.aws.amazon.com/dms/latest/sbs/chap-manageddatabases.postgresql-rds-postgresql.html
If this has answered your question or was helpful, accepting the answer would be greatly appreciated. Thank you!
Hello.
If you want to minimize downtime, I believe migrating using replication using AWS DMS will reduce downtime.
With this service, even if it is an on-premises database, it is possible to migrate it to a database on AWS via a VPN etc.
https://docs.aws.amazon.com/dms/latest/userguide/Welcome.html
https://docs.aws.amazon.com/dms/latest/userguide/CHAP_BestPractices.html
I think it would be a good idea to read the following documents as well.
https://repost.aws/knowledge-center/dms-migrate-postgresql-to-postgresql
Conteúdo relevante
- AWS OFICIALAtualizada há 2 anos
- AWS OFICIALAtualizada há 2 anos