Azure PostgreSQL Offsite Backups

Question

Hello, are the backups in Azure PostgreSQL Flexible/Hyperscale onsite or offsite?

Our node is currently located in North Central, and we need an offsite backup solution in case Azure backups are not already storing backups offsite. Do you have any recommendations?

Thank you.

Answer 1

Hi @Eric , welcome to Microsoft Q&A forum.

If I understand it correctly, you want to configure Azure backups in cross regions for Flexible/Hyperscale servers.

This can be achieved using Geo redundant backup which takes the backup of primary server in other geo locations.

Flexible server backups are copied to a remote region. that helps with disaster recovery situation in the event of the primary server region is down. This feature is currently enabled in selected regions. It takes a longer RTO and a higher RPO depending on the size of the data to restore and amount of recovery to perform. List of regions supporting:

Azure regions

However this is still not available for North Central US region. If it is possible for you to migrate it to say Central US region then this option is enabled.

Another way is through zone-redundant backups. Zone-redundant deployment enables Flexible server to be highly available. You can choose the region and the availability zone to deploy your primary database server. A standby replica server is automatically provisioned and managed in a different availability zone in the same region with the same compute, storage, and network configuration as the primary server.

We can configure it from High availability as mentioned in below screenshot:

Hyperscale also does not offer zone redundant and geo-redundant features, it comes with locally redundant storage (LRS).

Also we can take the backup on Azure Storage using pg_dump on other regions as mentioned in below article:

Backup Azure Database for PostgreSQL to a Blob Storage

Please let us know if this helps or else we can discuss it further.

----------

If answer is helpful please please click on as it could help other members of the Microsoft Q&A community who have similar questions and are looking for solutions. Thank you for helping to improve Microsoft Q&A!