You can use the Commvault software to back up and restore PostgreSQL data on the Azure database for PostgreSQL (PaaS).
Backups
Backups You Can Perform
- Full backups
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
Restores
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
-