I can't change data redundancy from geo-redundant to local redundancy in an Azure database for PostgreSQL single server

Question

Hello, I have a postgreSQL single server database with the backup redundancy option in "geo-redundant" and the Locally redundant option enabled does not appear. What can be caused this?

Answer 1

Hi, @Gerald Ortiz Candela Welcome to Microsoft Q&A thanks for posting your question.

As per the documentation, the backup storage redundancy option, whether locally redundant or geo-redundant, can only be set during server creation. Once the server is created, you cannot change the backup storage redundancy option.

If you need to change the backup storage redundancy option, you will need to create a new server with the desired redundancy option and migrate your data to the new server.

https://learn.microsoft.com/en-us/azure/postgresql/single-server/concepts-backup

Regards

Geetha