You can use the Commvault software to back up and restore PostgreSQL data on the Azure Database for PostgreSQL Single Servers and Azure Database for PostgreSQL Flexible Servers.
Backups You Can Perform
When You Can Perform Backups
On a schedule: The server plan that you assign manages scheduled backups
On demand: You can perform on-demand backups at any time
Data You Can Back Up
PostgreSQL system databases
PostgreSQL user databases
Data You Cannot Back Up
You can use a file server to back up the following content, which is not included in backups of Azure Database for PostgreSQL databases:
Operating system data
PostgreSQL application files
PostgreSQL Server information schema
PostgreSQL Server performance schema
For Azure database for PostgreSQL Flexible Servers, by default, the pg_cron extension is enabled and the schema that is named as cron is created in the postgres database where the pg_cron metadata is saved. Since the Azure Server administrator will not have the privilege to dump/drop/restore the schema, the postgres database backups fail. Hence, the postgres database backup will be skipped from the backups of Azure PostgreSQL Flexible Servers.
If cron.database_name is set to a different database, you must create a new subclient in order to skip the database from backups.
Backups You Can Use for Restores
The most recent backup: For example, restore the most recent backup to its original location
A backup from a specific date: For example, restore data to a point in time before it became unusable
Backups from a date range: For example, restore data that was accidentally deleted
Destinations You Can Restore To
In-place: Restore data to the location that it was backed up from
Out-of-place: Restore data to the following destinations:
Cross-cloud: You can restore PostgreSQL databases from one cloud platform (such as Amazon Web Services and Google Cloud Platform) to a different cloud platform. The source computer and destination computer should have the same operating system.
An instance in the same platform or a different platform (such as Alibaba Cloud, Amazon Web Services, Azure, and Google Cloud Platform) across regions
An on-premises instance
A disk location