Postgres Questions

Yes, any machines in other regions will come up with ROLE=replica. (This is for PG Flex, at least—not sure about the older Stolon variety.)

$ fly status
ID              STATE    ROLE     REGION  IMAGE
b915aabbaa0453  started  primary  ewr     flyio/postgres-flex:15.3
abcd091290fedc  started  replica  bos     flyio/postgres-flex:15.3

This part I would shy away from… The metadata for that does get preserved by clone, but stopped replicas will cause WALs to accumulate back on the primary, as I understand it:

https://community.fly.io/t/runaway-pg-wal-disk-usage/17438/2

When dabbling in the past, I did eventually see…

Warning: Inactive replication slot repmgr_slot_1545901680 is retaining 283 MB of WAL

And the size of /data/postgresql/pg_wal/ really was increasing (until the replica was hastily brought back online).