In case you have opted for Azure Database for PostgreSQL server, you’re in all probability on the lookout for a completely managed, clever, and versatile cloud database service that lets you deal with constructing functions whereas offloading important administration duties akin to availability, scalability, and knowledge safety to the service supplier. Nonetheless, a few of these duties—backup being a living proof—could have further necessities pertaining to your group’s compliance and enterprise wants that decision for a specialised, end-to-end answer.
Azure Backup and Azure Databases have come collectively to construct an enterprise-scale backup answer for Azure Database for PostgreSQL that facilitates versatile and granular backups and restores whereas supporting retention for as much as 10 years. It’s an elastic-scale, zero-infrastructure answer that doesn’t require you to deploy or handle backup infrastructure, brokers, or storage accounts whereas offering a easy and constant expertise to centrally handle and monitor the backups.
Enhanced capabilities from Azure Backup and Azure Databases
Lengthy-term retention in normal or archive tier
Retain backups for as much as 10 years within the normal or archive tier in line with your compliance and audit wants with restoration factors pruned mechanically by the built-in lifecycle administration functionality past the desired retention length.
Buyer-controlled, granular backup and restore throughout subscriptions
Outline the backup coverage along with your selection of backup schedule and retention guidelines with the pliability to set off an on-demand backup out of the common schedule for patching eventualities. Each backup and restores may be triggered for a person database or a gaggle of databases throughout subscriptions.
Set off point-in-time restores to the supply server or every other Azure Database for PostgreSQL server, even on larger database variations, making restores backward-compatible. Alternatively, restore the backup dump to a blob storage account and restore later to any PostgreSQL deployment on or off Azure.
Central administration and monitoring with Backup Heart
Handle and monitor all of the backup-related operations and jobs throughout servers, useful resource teams, places, subscriptions, and tenants from a single pane of glass known as the Backup Center.
By no means lose your backups, even should you lose the supply server
Backup knowledge is encrypted and saved in a separate safety and fault area such that even when the supply server have been to develop into compromised, the backups would stay intact within the Azure Backup managed storage accounts, that are in Microsoft tenant as an alternative of buyer’s tenant. The geo-redundant storage for backups additionally maintains a duplicate of the backup knowledge within the paired secondary area.
RBAC-based entry to the database utilizing Azure Lively Listing (Azure AD) authentication
The service does not assume entry on the PostgreSQL server, neither does it ask on your credentials to hook up with the database that it must backup. Aligning to the Azure safety rules, the person is predicted to grant the vault MSI (managed service id is a characteristic of Azure AD) and the required permissions on the useful resource.
Watch the demo beneath to study extra about Azure Backup for Azure Database for PostgreSQL.
It’s possible you’ll use this answer independently or along with the native backup answer supplied by Azure Database for PostgreSQL that provides retention for as much as 35 days. The native answer is suited to operational recoveries when the database admin desires to get well from the most recent backups. The Azure Backup answer alternatively helps the IT admin with their group’s compliance wants in addition to extra granular and versatile backup and restore.
- Azure CLI assist for automating all operations.
- Extending the answer for different Azure Database companies such Azure Database for MySQL and Azure Database for MariaDB.