Zero Downtime Postgres Database Migration from GCP to AWS RDS

In 2023, I was working at a company where we were running our Elixir backend on Gigalixir. Gigalixir is a PaaS similar to Heroku that at the time we were using provided its managed database service for Postgres via GCP (Google Cloud Platform). I foun...