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 DB.
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.
If you do not have a hypervisor to select, you can add a hypervisor. For more information, see Adding 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.
-
In the Maintenance DB box, type the name of the system database that is used as the maintenance database.
-
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.