In case you have opted for Azure Database for PostgreSQL server, you might be in all probability searching for a completely managed, clever, and versatile cloud database service that lets you give attention to constructing functions whereas offloading vital administration duties corresponding to availability, scalability, and knowledge safety to the service supplier. Nevertheless, 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 resolution.
Azure Backup and Azure Databases have come collectively to construct an enterprise-scale backup resolution 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 resolution 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 customary or archive tier
Retain backups for as much as 10 years within the customary or archive tier in line with your compliance and audit wants with restoration factors pruned routinely 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 alternative of backup schedule and retention guidelines with the flexibleness 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 bunch of databases throughout subscriptions.
Set off point-in-time restores to the supply server or some other Azure Database for PostgreSQL server, even on increased 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 Middle
Handle and monitor all of the backup-related operations and jobs throughout servers, useful resource teams, areas, subscriptions, and tenants from a single pane of glass known as the Backup Middle.
By no means lose your backups, even in the event 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 turn out to be compromised, the backups would stay intact within the Azure Backup managed storage accounts, that are in Microsoft tenant as a substitute of buyer’s tenant. The geo-redundant storage for backups additionally maintains a replica of the backup knowledge within the paired secondary area.
RBAC-based entry to the database utilizing Azure Lively Listing (Azure AD) authentication
The service would not assume entry on the PostgreSQL server, neither does it ask in your credentials to connect 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 mandatory permissions on the useful resource.
Watch the demo beneath to be taught extra about Azure Backup for Azure Database for PostgreSQL.
You might use this resolution independently or along with the native backup resolution provided by Azure Database for PostgreSQL that provides retention for as much as 35 days. The native resolution is suited to operational recoveries when the database admin desires to get better from the newest backups. The Azure Backup resolution then again 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 providers such Azure Database for MySQL and Azure Database for MariaDB.