Google Cloud SQL for PostgreSQL

Updated

You can use the Commvault software to back up and restore Google Cloud SQL for PostgreSQL.

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 Cloud SQL 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