Cloud SQL for PostgreSQL

Overview

Cloud SQL for PostgreSQL is a fully-managed database service that makes it easy to set up, maintain, manage, and administer your PostgreSQL relational databases on Google Cloud. For information specific to PostgreSQL, see the PostgreSQL documentation.

Features

Cloud SQL provides extensive documentation. If you're new to Cloud SQL for PostgreSQL, then be sure to check out the Cloud SQL for PostgreSQL features page.

Instance settings

Many configuration settings go into the creation of a Cloud SQL instance. Your needs may vary from the defaults. See the Creating instances and Instance settings pages for more information.

Connectivity

Cloud SQL offers connectivity through public IP addresses, private IP addresses, or both public and private addresses.

For Database Migration Service, the IP allowlist connectivity method is appropriate when using a public IP address, and the VPC peering connectivity method is used for private IP addresses.

Cloud SQL recommends using SSL/TLS certificates when connecting to a Cloud SQL instance.

Cloud SQL users

The first time you connect to a new Cloud SQL instance, use the postgres account.

Because it's a managed service, Cloud SQL doesn't allow PostgreSQL users to have SUPER privileges.

Cascading read replicas

Database Migration Service lets you migrate data to a Cloud SQL destination instance, and then set up cascading read replicas for that instance. For more information, see Set up cascading read replicas.

High availability

After you promote a Cloud SQL replica to become a primary instance, you can configure it for high availability (HA). If your HA-configured instance becomes unresponsive, then Cloud SQL automatically switches to serving data from a standby instance.

What's next

Learn more about everything you can do with your Cloud SQL instance.