La connessione a Cloud SQL con l'accesso privato Google non è supportata.
Differenze tra PostgreSQL standard e Cloud SQL per PostgreSQL
In generale, la funzionalità PostgreSQL fornita da un'istanza Cloud SQL è la stessa fornita da un'istanza PostgreSQL ospitata localmente. Tuttavia, esistono alcune differenze tra un'istanza PostgreSQL standard e un'istanza Cloud SQL.
Funzionalità non supportate per Cloud SQL per PostgreSQL
Qualsiasi funzionalità che richieda privilegi SUPERUSER, con le seguenti eccezioni:
Se ti viene assegnato il ruolo cloudsqlsuperuser, puoi eseguire le istruzioni CREATE CAST e DROP CAST. Per ulteriori informazioni, vedi Restrizioni e privilegi di superutente.
Il metodo di trasmissione WITHOUT FUNCTION.
Worker personalizzati in background.
Il client psql in Cloud Shell non supporta le operazioni che richiedono una riconnessione, ad esempio la connessione a un database diverso utilizzando il comando \c.
Compilazione Just-in-Time (JIT) di Low-Level Virtual Machine (LLVM).
Differenze notevoli tra PostgreSQL e Cloud SQL per PostgreSQL
Alcune opzioni e alcuni parametri PostgreSQL non sono abilitati per la modifica come
flag Cloud SQL.
[[["Facile da capire","easyToUnderstand","thumb-up"],["Il problema è stato risolto","solvedMyProblem","thumb-up"],["Altra","otherUp","thumb-up"]],[["Difficile da capire","hardToUnderstand","thumb-down"],["Informazioni o codice di esempio errati","incorrectInformationOrSampleCode","thumb-down"],["Mancano le informazioni o gli esempi di cui ho bisogno","missingTheInformationSamplesINeed","thumb-down"],["Problema di traduzione","translationIssue","thumb-down"],["Altra","otherDown","thumb-down"]],["Ultimo aggiornamento 2025-09-04 UTC."],[],[],null,["# Cloud SQL for PostgreSQL features\n\n\u003cbr /\u003e\n\n[MySQL](/sql/docs/mysql/features \"View this page for the MySQL database engine\") \\| PostgreSQL \\| [SQL Server](/sql/docs/sqlserver/features \"View this page for the SQL Server database engine\")\n\n\u003cbr /\u003e\n\nThis page describes the major features and capabilities of Cloud SQL for PostgreSQL. Cloud SQL is also available for [MySQL](/sql/docs/mysql/features) and [SQL Server](/sql/docs/sqlserver/features).\n\n\u003cbr /\u003e\n\n| **Note:** For information about the supported versions of database engines, see [Database versions and version policies](/sql/docs/postgres/db-versions).\n\nPostgreSQL features by Cloud SQL editions\n-----------------------------------------\n\nFor more information about the features for each edition of Cloud SQL for PostgreSQL,\nsee [Introduction to Cloud SQL editions](/sql/docs/postgres/editions-intro).\n\nPostgreSQL feature support for Cloud SQL\n----------------------------------------\n\n- Fully managed PostgreSQL databases in the cloud.\n- Instances available in the Americas, EU, Asia, and Australia. See [all\n locations where you can create Cloud SQL\n instances](/sql/docs/postgres/locations).\n- Supports migration from source databases to Cloud SQL destination databases using [Database Migration Service\n (DMS)](/database-migration/docs/postgres/configure-source-database).\n- Customer data encrypted on Google's internal networks and in database tables, temporary files, and backups.\n- Support for secure external connections with the Cloud SQL Auth Proxy or with the SSL/TLS protocol.\n- Data replication between multiple zones with automatic failover.\n- Import and export databases using SQL dump files.\n- Support for PostgreSQL client-server protocol and standard PostgreSQL connectors.\n- Automated backups, on-demand backups, and point-in-time recovery.\n- Instance cloning.\n- Integration with Google Cloud Observability logging and monitoring.\n- Support for multiple [PostgreSQL versions](/sql/docs/postgres/db-versions).\n- Logical replication\n\nSupported PostgreSQL extensions for Cloud SQL\n---------------------------------------------\n\nCloud SQL supports many PostgreSQL extensions. For a complete list of these\nextensions, see [Configure PostgreSQL\nextensions](/sql/docs/postgres/extensions).\n\nSupported PostgreSQL procedural languages for Cloud SQL\n-------------------------------------------------------\n\nCloud SQL supports the [`PL/pgSQL` SQL procedural\nlanguage](https://www.postgresql.org/docs/current/static/plpgsql.html).\n\nSupported languages for Cloud SQL for PostgreSQL\n------------------------------------------------\n\nYou can use Cloud SQL with App Engine applications running in the\nflexible environment that are written in:\n\n- C#\n- Go\n- Java\n- Node.js\n- PHP\n- Python\n- Ruby\n\nYou can also use Cloud SQL with external applications using the standard\nPostgreSQL client-server protocol.\n\nHow you can connect to Cloud SQL for PostgreSQL instances\n---------------------------------------------------------\n\nYou can connect to a Cloud SQL instance from:\n\n- A `psql` client. [Learn more](/sql/docs/postgres/connect-admin-ip).\n- Third-party tools that use the standard PostgreSQL client-server protocol.\n- External applications. [Learn\n more](/sql/docs/postgres/connect-external-app).\n- App Engine applications. [Learn\n more](/sql/docs/postgres/connect-app-engine).\n- Applications running on Compute Engine. [Learn\n more](/sql/docs/postgres/connect-compute-engine).\n- Applications running on Google Kubernetes Engine. [Learn\n more](/sql/docs/postgres/connect-kubernetes-engine).\n- Cloud Run functions. [Learn more](/sql/docs/postgres/connect-functions).\n - Cloud Run. [Learn more](/sql/docs/mysql/connect-run).\n\nConnecting to Cloud SQL with Private Google access isn't supported.\n\nDifferences between standard PostgreSQL and Cloud SQL for PostgreSQL\n--------------------------------------------------------------------\n\nIn general, the PostgreSQL functionality provided by a Cloud SQL\ninstance is the same as the functionality provided by a locally-hosted\nPostgreSQL instance. However, there are a few differences between a standard\nPostgreSQL instance and a Cloud SQL instance.\n\n### Unsupported features for Cloud SQL for PostgreSQL\n\n- Any feature that requires `SUPERUSER` privileges with the following exceptions:\n\n - You can use the `CREATE EXTENSION` statement only for [supported extensions](#extensions).\n\n - 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](/sql/docs/postgres/users#superuser-restrictions-and-privileges).\n\n- The `WITHOUT FUNCTION` cast method.\n\n- Custom background workers.\n\n- The `psql` client in Cloud Shell doesn't support operations that\n require a reconnection, such as connecting to a different database using the\n `\\c` command.\n\n- Low-Level Virtual Machine (LLVM) Just-in-Time (JIT) compilation.\n\n### Notable differences between PostgreSQL and Cloud SQL for PostgreSQL\n\n- Some PostgreSQL options and parameters aren't enabled for editing as [Cloud SQL flags](/sql/docs/postgres/flags).\n\n To request the addition of a configurable Cloud SQL flag, use the [Cloud SQL for PostgreSQL Forum](https://www.googlecloudcommunity.com/gc/forums/filteredbylabelpage/board-id/cloud-database/label-name/cloud%20sql%20for%20postgres)."]]
