Editing Instances

After you create an instance, you can edit the instance at any time to change its settings. For information about instance settings and how changing settings can impact an instance, see Instance Settings.

Editing general instance settings

Console

  1. Go to the Cloud SQL Instances page in the Google Cloud Platform Console.

    Go to the Cloud SQL Instances page

  2. Select an instance to edit by clicking the instance name.
  3. Click Edit.
  4. Make your changes to the instance settings.

    Learn more about instance settings.

  5. Click Save to apply your changes.

gcloud

Use the instances patch command and specify the flags for the settings you want to edit.

For example, the following command modifies the backup start time.

gcloud sql instances patch [INSTANCE_NAME] --backup-start-time 16:00

If the patch modifies a value that requires your instance to be restarted, you will be prompted to proceed with the change or cancel.

For details about all the options you can specify in the instances patch command, run gcloud sql instances patch --help or see the instances patch command in the Cloud SDK documentation.

Editing access control settings

Console

  1. Go to the Cloud SQL Instances page in the Google Cloud Platform Console.

    Go to the Cloud SQL Instances page

  2. Select an instance to edit by clicking the instance name.
  3. Select the Access Control tab.
  4. Make your changes to the access control settings.

    From this panel, you can:

    • Add or remove an IPv4 address assigned to the instance.
    • Add or remove authorized networks from which external applications can connect.

      For more information, see Configuring access for IP connections.

  5. Click Save to apply your changes.

gcloud

Use the instances patch command and specify the flags for the access control settings you want to edit.

Access control setting include instance IPv4 address, authorized networks, and SSL configuration. For example, the following command assigns an IP address and authorizes the specified IP address range.

gcloud sql instances patch [INSTANCE_NAME] --assign-ip --authorized-networks 192.168.100.0/24

For details about all the options you can specify in the instances patch command, run gcloud sql instances patch --help or see the instances patch command in the Cloud SDK documentation.

Send feedback about...

Cloud SQL for PostgreSQL