Overview

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

Features

Cloud SQL provides extensivedocumentation. If you'renew to Cloud SQL for PostgreSQL, then be sure to check out theCloud 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 theCreating instancesandInstance settings pages formore information.

Connectivity

Cloud SQL offersconnectivitythroughpublic IP addresses,private IP addresses, or bothpublic and private addresses.

For Database Migration Service, theIP allowlistconnectivity method is appropriate when using a public IP address, and theVPC peeringconnectivity method is used for private IP addresses.

Cloud SQL recommends usingSSL/TLScertificates when connecting to a Cloud SQL instance.

Cloud SQL users

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

Because it's a managed service, Cloud SQL doesn't allow PostgreSQL users to haveSUPER 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,seeSet up cascading read replicas.

High availability

After youpromotea Cloud SQL replica to become a primary instance, you can configure it forhigh availability (HA). If yourHA-configured instance becomes unresponsive, then Cloud SQL automaticallyswitches to serving data from a standby instance.

What's next

Learn more abouteverything you can dowith your Cloud SQL instance.