Microsoft Azure Database for PostgreSQL

Updated

You can use the Commvault software to back up and restore PostgreSQL data on the Microsoft 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) 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 Amazon, Google, Alibaba, Azure) across regions

    • An on-premises instance

    • A disk location