AWS Database Migration: From On-Premises PostgreSQL to RDS Using Backup-Restore and DMS

Database migration is one of those tasks that sounds straightforward on paper but has a dozen moving pieces when you actually sit down to do it. Move data from here to there. Simple enough. But then you ask: what engine? What version? How much data? Is the destination already populated? Is this a one-time move or do you need continuous replication? This post covers two real migration scenarios using PostgreSQL and AWS RDS: the first is migrating from an on-premises database to AWS RDS using a backup and restore approach, and the second is migrating from one RDS instance to another using AWS Database Migration Service. Both are hands-on, step by step, exactly the way you would do it in a real project.