[[["이해하기 쉬움","easyToUnderstand","thumb-up"],["문제가 해결됨","solvedMyProblem","thumb-up"],["기타","otherUp","thumb-up"]],[["이해하기 어려움","hardToUnderstand","thumb-down"],["잘못된 정보 또는 샘플 코드","incorrectInformationOrSampleCode","thumb-down"],["필요한 정보/샘플이 없음","missingTheInformationSamplesINeed","thumb-down"],["번역 문제","translationIssue","thumb-down"],["기타","otherDown","thumb-down"]],["최종 업데이트: 2025-08-14(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)."]]
