How to enable Backvault option to PostgreSQL Azure Flexible server.

Question

How to enable Backvault option to PostgreSQL Azure Flexible server.

Answer 1

You can follow this tutorial

https://learn.microsoft.com/en-us/azure/backup/tutorial-postgresql-backup

Answer 2

Hi
Arjun Bangaru,

Welcome to Microsoft Q&A forum and thanks for using Azure Services.

As I understand, you want to know about enablement of Backvault option to PostgreSQL Azure Flexible server.

In Flexible Server, by default, Azure Database for PostgreSQL enables automated backups of your entire server (encompassing all databases created) with a default retention period of 7 days. The automated backups include a daily incremental snapshot of the database. The log (WAL) files are archived to Azure Blob Storage continuously.

You can manually take a backup by using the PostgreSQL tool pg_dump. For examples, see Migrate your PostgreSQL database by using dump and restore.

If you want to back up Azure Database for PostgreSQL to Blob Storage, see Back up Azure Database for PostgreSQL to Blob Storage on our tech community blog.

Azure manages backup windows, and you can't customize them. The first full snapshot backup is scheduled immediately after a server is created. Subsequent snapshot backups are incremental and occur once a day.

Azure Database for PostgreSQL automatically creates server backups and stores them in:

• Zone-redundant storage, in regions where multiple zones are supported.
• Locally redundant storage, in regions that don't support multiple zones yet.
• The paired region, if you've configured geo-redundant backup.

These backup files can't be exported.

You can use backups to restore your server to a point in time only. The default backup retention period is 7 days. You can optionally configure the backup retention up to 35 days.

Reference documentation links:

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

https://techcommunity.microsoft.com/t5/azure-database-for-postgresql/new-backup-and-restore-enhancements-in-flexible-server/ba-p/3649253

Backup Vault option is applicable for Azure Database for PostgreSQL server running on an Azure VM to an Azure Backup Recovery Services vault.

However, if you want this feature suitable for Flexible Server, we recommend you to share your idea over Azure Database for PostgreSQL Feedback Channel from where concerned team will look into the feature requests depending on the priority and up-votes to implement the same.

Hope this helps. Do let us know if have further queries.

Thank you.