Hi @chew, without analysing everything you’ve got there, one thing that sticks out for me is that a Fly Postgres app will go read-only if its disk is nearly full (because it gets more complicated to recover if it gets completely full).
You can check this by fly ssh console-ing in and running df.
If you need more space for your database, you can extend the volume on each instance.