AWS RDS is very convenient and takes care of almost all DBA tasks. It just works as long as you stay inside AWS. But if you want to have a local copy of your database or need to move data to another host it can be tricky.
TL;DR – For our solution skip to part last section
What doesn’t work
AWS daily backups
AWS RDS by default creates daily backups of your data. First thought would be get such backup and restore it locally. But those are not regular Postgres backups. They probably are VM image copies, but no way to know, as you cannot copy or see them. The only option is to restore them to another RDS instance.
AWS uses replication to maintain […]