Failover Between Regions with Azure PostgreSQL Flexible Server without connection string changes

bmckerr-MSFT fc388d harinarayanan94 was this resolved? It took me awhile to find it, but this issue is buried in the docs linked https://learn.microsoft.com/en-us/azure/postgresql/flexible-server/concepts-read-replicas#considerations:~:text=However%2C%20specific%20settings%2C%20like%20geo%2Dbackup%2C%20won%27t%20be%20replicated%20to%20the%20read%20replica.. Based on tests it looks like there's no way to fully bring your primary region back to the same state prior to failover without restoring your DB from a backup because you can't edit the geo-DR backup after creation (see https://learn.microsoft.com/en-us/azure/postgresql/flexible-server/concepts-geo-disaster-recovery#:~:text=Can%20be%20configured,No) and when you create a read replica it doesn't let you modify that setting. 

This is a significant factor in risk and RTO with respect to failback because you're not able to simply re-replicate back to primary with restored settings, but you need to re-replicate back, tag a backup, restore from backup, and then delete the temporarily replicated server. It's a mess.