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).