Migrate on-premises Postgres DB to RDS Managed Postgres

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