Adding an Instance for Google Cloud SQL for PostgreSQL

Updated

To manage a database, you can either use an existing instance or add a new instance.

Before You Begin

  • To discover database instances, enable the Cloud SQL Admin and Cloud Resource Manager APIs in the project where service account is hosted.

  • Your Google account must contain the following permissions to access the Google resources:

    Role

    Title

    Description

    Permissions

    Lowest Resource

    roles/cloudsql.viewer

    Cloud SQL Viewer

    Provides read-only access of Cloud SQL resource.

    cloudsql.backupRuns.get

    cloudsql.backupRuns.list

    cloudsql.databases.get

    cloudsql.databases.list

    cloudsql.instances.export

    cloudsql.instances.get

    cloudsql.instances.list

    cloudsql.instances.listServerCas

    cloudsql.sslCerts.get

    cloudsql.sslCerts.list

    cloudsql.users.list

    resourcemanager.projects.get

    resourcemanager.projects.list

    serviceusage.quotas.get

    serviceusage.services.get

    serviceusage.services.list

    Project

Procedure

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

    The Instances page appears.

  2. Click Add instance, and then select Cloud database service.

    The Add Cloud DB instance dialog box appears.

  3. From the Select vendor list, select Google Cloud Platform.

  4. From the Database service list, select PostgreSQL.

  5. From the Cloud account list, select an existing cloud account or create a new cloud account.

    The cloud account is represented in Commvault as a hypervisor. For instructions to create a Google Cloud Platform hypervisor, see Configuring Backups for Google Cloud Platform.

  6. From the Backup plan list, select a server plan.

  7. From the Instance name list, select an instance.

  8. In the Database user box, type the user name to access the Cloud SQL for PostgreSQL application.

  9. In the Password box, type the password to access the Cloud SQL for PostgreSQL application.

  10. If SSL is enabled on the cloud, move the Use SSL options toggle key to the right, and then complete the following tasks:

    • In the SSL CA file box, provide SSL CA file path in the proxy computer.

    • In the SSL Key file box, provide SSL key file path in the proxy computer.

    • In the SSL Cert file box, provide SSL certificate file path in the proxy computer.

  11. Click Add.

Results

  • The new instance contains a dump-based backup set and a default subclient.

  • When you add an instance, a default database group is automatically created. The default database group includes all the data in the PostgreSQL database. You cannot delete the default database group.