Backing Up a Database Group for Google Cloud SQL for PostgreSQL

Updated

You can perform a full backup operation of a Cloud SQL for PostgreSQL database group.

Procedure

  1. From the navigation pane, go to Protect > Databases.

    The Overview page appears.

  2. On the Instances tab, click the instance.

    The instance page appears.

  3. On the Database groups tab, in the Database groups table, click the database group that you want to back up.

    The database group page appears.

  4. On the right side of the page, click Backup.

    The Backup options dialog box appears.

  5. Under Backup level, select Full.

  6. Click SUBMIT.

Note

  • If the database part of a database group (other than default) is renamed or removed, the backup content for the database group needs to be updated manually. The old database will not be removed automatically.

  • By default, backup operations using DumpBased backup set do not include information about roles. This is because pg_dump utility that is used to perform DumpBased backup operation does not back up roles information. To save this information using the pg_dumpall utility, enable backups for global objects in PostgreSQL databases.

Was this page helpful?