Creating Instances

MySQL   |  PostgreSQL

Beta

This is a beta release of Cloud SQL for PostgreSQL. This product might be changed in backward-incompatible ways and is not subject to any SLA or deprecation policy.

This page describes how to create a Google Cloud SQL for PostgreSQL instance.

For detailed information about all instance settings, see Instance Settings.

Creating an instance

Console

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

   Go to the Cloud SQL Instances page

2. Click Create instance.
3. Select PostgreSQL and click Next.
4. Enter an ID for the instance.
   You do not need to prepend the project ID onto the instance ID. This is done automatically where appropriate (for example, in the log files).
   Important: You should be aware that some resource identifiers (such as project IDs) might be retained beyond the life of your project. For this reason, avoid storing sensitive information in resource identifiers.
   ...see naming guidelines
5. Enter a password for the postgres user.
6. Under Configuration options, update any other settings you need for your instance:

   Setting	Notes
   Machine type and storage
   Cores	The number of vCPUs for your instance. Learn more.
   Memory	The amount of memory for your instance, in GiBs. Learn more.
   Storage type	Determines whether your instance uses SSD or HDD storage. Learn more.
   Storage capacity	The amount of storage provisioned for the instance. Learn more.
   Automatic storage increase	Determines whether Cloud SQL automatically provides more storage for your instance when free space runs low. Learn more.
   Automatic backups and high availability
   Automatic backups	The window of time when you would like backups to start. Learn more.
   Authorized networks
   Authorized networks	For IP connections, only connections from authorized networks can connect to your instance. Learn more.
   Cloud SQL flags
   Cloud SQL flags	You can use Cloud SQL flags to control settings and parameters for your instance. Learn more.
   Maintenance schedule
   Maintenance window	Determines a one-hour window when Cloud SQL can perform disruptive maintenance on your instance. If you do not set the window, then disruptive maintenance can be done at any time. Learn more.
   Maintenance timing	Your preferred timing for instance updates, relative to other instances in the same project. Learn more.

7. Click Create.
8. After the instance finishes initializing, select the instance to open it.

gcloud

For information about installing and getting started with the Cloud SDK, see Installing Cloud SDK. For information about the Cloud Shell, see Google Cloud Shell.

1. Create the instance:

   gcloud sql instances create [INSTANCE_NAME] --database-version=POSTGRES_9_6 \
          --cpu=[NUMBER_CPUS] --memory=[MEMORY_SIZE]
   

   There are restrictions on the values for vCPUs and memory size:

   • vCPUs must be either 1 or an even number between 2 and 32.
   • Memory must be:
     • 0.9 to 6.5 GiB per vCPU
     • A multiple of 256 MiB
     • At least 3.75 GiB (3840 MiB)

   For example, the following string creates an instance with two vCPUs and 7,680 MiB of memory:

    gcloud sql instances create myinstance --cpu=2 --memory=7680MiB \
           --database-version=POSTGRES_9_6
   

   You can also create a shared-core instance by using --tier db-f1-micro or --tier db-g1-small and dropping the --cpu and --memory parameters.

   You can add more parameters to determine other instance settings:

   Setting	Parameter	Notes
   Required parameters
   Database version	--database-version	POSTGRES_9_6
   Region	--region	See valid values.
   Machine type and storage
   Storage type	--storage-type	Determines whether your instance uses SSD or HDD storage. Learn more.
   Storage capacity	--storage-size	The amount of storage provisioned for the instance, in GB. Learn more.
   Automatic storage increase	--storage-auto-increase	Determines whether Cloud SQL automatically provides more storage for your instance when free space runs low. Learn more.
   Automatic storage increase limit	--storage-auto-increase-limit	Determines how large Cloud SQL can automaticaly grow storage. Available only for the beta command (gcloud beta sql instances create). Learn more.
   Automatic backups and high availability
   Automatic backups	--backup-start-time	The window of time when you would like backups to start. Learn more.
   Authorize networks
   Authorized networks	--authorized-networks	For IP connections, only connections from authorized networks can connect to your instance. Learn more.
   Add Cloud SQL flags
   Cloud SQL flags	--database-flags	You can use Cloud SQL flags to control settings and parameters for your instance. Learn more about Cloud SQL flags. Learn more about how to format this parameter.
   Set maintenance schedule
   Maintenance window	--maintenance-window-day, --maintenance-window-hour	Determines a one-hour window when Cloud SQL can perform disruptive maintenance on your instance. If you do not set the window, then disruptive maintenance can be done at any time. Learn more.
   Maintenance timing	--maintenance-release-channel	Your preferred timing for instance updates, relative to other instances in the same project. Use preview for earlier updates, and production for later updates. Learn more.

2. Note the automatically assigned IP address.

   If you are not using the Cloud SQL Proxy, you will use this address as the host address that your applications or tools use to connect to the instance.

3. Set the password for the postgres user:

   gcloud sql users set-password postgres no-host --instance=[INSTANCE_NAME] \
          --password=[PASSWORD]
   

cURL

1. Create the instance:

   ACCESS_TOKEN="$(gcloud auth application-default print-access-token)"
   curl --header "Authorization: Bearer ${ACCESS_TOKEN}" \
        --header 'Content-Type: application/json' \
        --data '{"name":"[INSTANCE_NAME]", "region":"[REGION]",
                 "databaseVersion": "POSTGRES_9_6",
                 "settings": {"tier": "[TIER_STRING]",
                 "backupConfiguration": {"enabled":true}}}' \
        -X POST \
        https://www.googleapis.com/sql/v1beta4/projects/[PROJECT-ID]/instances
   

   TIER_STRING is a string that represents the number of CPUs and the amount of memory you want your new instance to have. The string has the following format: db-custom-[CPUS]-[MEMORY_MBS]. You can also create a shared-core instance by supplying db-f1-micro or db-g1-small for the tier parameter.

   This example creates an instance with backups enabled. For a complete list of parameters for this call, see the Instances:insert page. For information about instance settings, including valid values for region and machine type, see Instance Settings.

2. When the instance finishes initializing, update the password for the postgres user:

   curl --header "Authorization: Bearer ${ACCESS_TOKEN}" \
        --header 'Content-Type: application/json' \
        --data '{"name": "postgres", "host": "", "password": "[PASSWORD]"}' \
        -X PUT \
        'https://www.googleapis.com/sql/v1beta4/projects/[PROJECT-ID]/instances/[INSTANCE_NAME]/users?host=&name=postgres'
   

3. Retrieve the automatically assigned IPv4 address for the new instance:

   curl --header "Authorization: Bearer ${ACCESS_TOKEN}" \
        -X GET \
        https://www.googleapis.com/sql/v1beta4/projects/[PROJECT-ID]/instances/[INSTANCE_NAME]
   

   Look for the ipAddress field in the response.

What's next

• Configure access to the instance.
• Connect to the instance with a psql client.
• Create a database on the instance.
• Import data into the instance.
• Create users on the instance.
• Learn more about instance settings.