Hey! I currently have a postgres db and an accompanying app running in region A, and I want to move them both to region B. The app is stateless and easy enough to set the preferred region and have it move, however I’m not sure how to move the postgres master.
I can see in the docs there is mention of snapshot restores, but it looks like this requires a new postgres app, which I assume would require re-linking the app and db.
My app doesn’t have serious traffic yet so the downtime associated with that is totally acceptable right now.
However, is there a better way to perform this without tearing down the db app in fly and starting from scratch? Could I add a replica then somehow mark it as the new leader?