Adding a Database Group for Google Cloud SQL for PostgreSQL

Updated

On this page

A default database group is created when you create an instance. But it does not back up the PostgreSQL databases. So, you must create at least one additional database group. You can create other database groups as well. For example, you can create a database group for databases that you want to back up once a week.

Procedure

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

    The Instances page appears.

  2. Click the instance that you want to add the database group to.

    The instance properties page appears.

  3. From the Backup sets list, select DumpBasedBackupSet.

    The DumpBasedBackupSet page appears.

  4. On the right of the page, click Add database group.

    The Add database group dialog box appears.

  5. In the Database group name box, type a name for the database group.

  6. In the Number of data streams box, enter the number of data streams that you want to use for backups.

  7. Optional: To include the object list in the backup content, select the Collect object list during backup check box.

    When you select this check box, restore operations run faster. However, backup operations might take additional time to back up the object list that contains the metadata information.

  8. Move the Use backup plan toggle key to the right, and then, from the Plan list, select a server plan.

  9. In the Databases table, select the check boxes for the databases that you want to include in the group.

  10. Click Add.