Home - News ( United States | United Kingdom | Italy | Germany ) - Football scores

Showing content from https://cloud.google.com/sql/docs/postgres/features below:

Cloud SQL for PostgreSQL features

Stay organized with collections Save and categorize content based on your preferences.

This page describes the major features and capabilities of Cloud SQL for PostgreSQL. Cloud SQL is also available for

and

.

For more information about the features for each edition of Cloud SQL for PostgreSQL, see Introduction to Cloud SQL editions.

• Fully managed PostgreSQL databases in the cloud.
• Instances available in the Americas, EU, Asia, and Australia. See all locations where you can create Cloud SQL instances.
• Supports migration from source databases to Cloud SQL destination databases using Database Migration Service (DMS).
• Customer data encrypted on Google's internal networks and in database tables, temporary files, and backups.
• Support for secure external connections with the Cloud SQL Auth Proxy or with the SSL/TLS protocol.
• Data replication between multiple zones with automatic failover.
• Import and export databases using SQL dump files.
• Support for PostgreSQL client-server protocol and standard PostgreSQL connectors.
• Automated backups, on-demand backups, and point-in-time recovery.
• Instance cloning.
• Integration with Google Cloud Observability logging and monitoring.
• Support for multiple PostgreSQL versions.
• Logical replication

Cloud SQL supports many PostgreSQL extensions. For a complete list of these extensions, see Configure PostgreSQL extensions.

Cloud SQL supports the PL/pgSQL SQL procedural language.

You can use Cloud SQL with App Engine applications running in the flexible environment that are written in:

• C#
• Go
• Java
• Node.js
• PHP
• Python
• Ruby

You can also use Cloud SQL with external applications using the standard PostgreSQL client-server protocol.

You can connect to a Cloud SQL instance from:

• A psql client. Learn more.
• Third-party tools that use the standard PostgreSQL client-server protocol.
• External applications. Learn more.
• App Engine applications. Learn more.
• Applications running on Compute Engine. Learn more.
• Applications running on Google Kubernetes Engine. Learn more.
• Cloud Run functions. Learn more.
  • Cloud Run. Learn more.

Connecting to Cloud SQL with Private Google access isn't supported.

In general, the PostgreSQL functionality provided by a Cloud SQL instance is the same as the functionality provided by a locally-hosted PostgreSQL instance. However, there are a few differences between a standard PostgreSQL instance and a Cloud SQL instance.

• Any feature that requires SUPERUSER privileges with the following exceptions:

  • You can use the CREATE EXTENSION statement only for supported extensions.

  • If you are assigned to the cloudsqlsuperuser role, then you can perform CREATE CAST and DROP CAST statements. For more information, see Superuser restrictions and privileges.

• The WITHOUT FUNCTION cast method.

• Custom background workers.

• The psql client in Cloud Shell doesn't support operations that require a reconnection, such as connecting to a different database using the \c command.

• Low-Level Virtual Machine (LLVM) Just-in-Time (JIT) compilation.

• Some PostgreSQL options and parameters aren't enabled for editing as Cloud SQL flags.

  To request the addition of a configurable Cloud SQL flag, use the Cloud SQL for PostgreSQL Forum.

Except as otherwise noted, the content of this page is licensed under the Creative Commons Attribution 4.0 License, and code samples are licensed under the Apache 2.0 License. For details, see the Google Developers Site Policies. Java is a registered trademark of Oracle and/or its affiliates.

Last updated 2025-07-02 UTC.

[[["Easy to understand","easyToUnderstand","thumb-up"],["Solved my problem","solvedMyProblem","thumb-up"],["Other","otherUp","thumb-up"]],[["Hard to understand","hardToUnderstand","thumb-down"],["Incorrect information or sample code","incorrectInformationOrSampleCode","thumb-down"],["Missing the information/samples I need","missingTheInformationSamplesINeed","thumb-down"],["Other","otherDown","thumb-down"]],["Last updated 2025-07-02 UTC."],[],[]]

RetroSearch is an open source project built by @garambo | Open a GitHub Issue

Search and Browse the WWW like it's 1997 | Search results from DuckDuckGo

HTML: 3.2 | Encoding: UTF-8 | Version: 0.7.4