To manage a database, you can either use an existing instance or add a new instance.
Before You Begin
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
From the navigation pane, go to Protect > Databases.
The Instances page appears.
Click Add instance, and then select Cloud database service.
The Add Cloud DB instance dialog box appears.
From the Select vendor list, select a vendor where you want to create an instance.
From the Database service list, select PostgreSQL.
From the Cloud account list, select a hypervisor.
From the Backup plan list, select a server plan.
From the Instance name list, select an instance.
In the Database user box, type the user name to access the Cloud SQL for PostgreSQL application.
In the Password box, type the password to access the Cloud SQL for PostgreSQL application.
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.
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.