Terhubung ke Cloud SQL dengan akses Google Pribadi tidak didukung.
Perbedaan antara PostgreSQL standar dan Cloud SQL untuk PostgreSQL
Secara umum, fungsi PostgreSQL yang disediakan oleh instance Cloud SQL
sama dengan fungsi yang disediakan oleh instance PostgreSQL yang dihosting
secara lokal. Namun, ada beberapa perbedaan antara instance PostgreSQL
standar dan instance Cloud SQL.
Fitur yang tidak didukung untuk Cloud SQL untuk PostgreSQL
Semua fitur yang memerlukan hak istimewa SUPERUSER dengan pengecualian berikut:
Jika Anda ditetapkan ke peran cloudsqlsuperuser, Anda dapat menjalankan pernyataan CREATE CAST dan DROP CAST. Untuk mengetahui informasi selengkapnya, lihat Batasan dan hak istimewa superuser.
Metode transmisi WITHOUT FUNCTION.
Worker latar belakang kustom.
Klien psql di Cloud Shell tidak mendukung operasi yang
memerlukan koneksi ulang, seperti terhubung ke database yang berbeda menggunakan
perintah \c.
Kompilasi tepat waktu (JIT) Mesin Virtual Level Rendah (LLVM).
Perbedaan penting antara PostgreSQL dan Cloud SQL untuk PostgreSQL
Beberapa opsi dan parameter PostgreSQL tidak diaktifkan untuk diedit sebagai
flag Cloud SQL.
[[["Mudah dipahami","easyToUnderstand","thumb-up"],["Memecahkan masalah saya","solvedMyProblem","thumb-up"],["Lainnya","otherUp","thumb-up"]],[["Sulit dipahami","hardToUnderstand","thumb-down"],["Informasi atau kode contoh salah","incorrectInformationOrSampleCode","thumb-down"],["Informasi/contoh yang saya butuhkan tidak ada","missingTheInformationSamplesINeed","thumb-down"],["Masalah terjemahan","translationIssue","thumb-down"],["Lainnya","otherDown","thumb-down"]],["Terakhir diperbarui pada 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)."]]
