That's our answer, yes. Read replicas and we redirect requests that need writes to a "primary" region: https://fly.io/blog/globally-distributed-postgres/

We tried cross region database calls for HTTP requests. They were bad. They seem to work ok for long lived connections like websockets, though.