PostgreSQL 適用的 Cloud SQL 說明文件
PostgreSQL 適用的 Cloud SQL 是一項全代管資料庫服務,可協助您在 Google Cloud Platform 中設定、維護、管理及使用 PostgreSQL 關聯資料庫。
瞭解詳情
使用價值 $300 美元的免費抵免額,開始進行概念驗證
-
取得 Gemini 2.0 Flash Thinking 的存取權
-
每月免費使用 AI API 和 BigQuery 等熱門產品
-
不會自動收費,也不會要求您一定要購買特定方案
繼續探索超過 20 項一律免費的產品
使用超過 20 項實用的免費產品,包括 AI API、VM 和 data warehouse 等。
訓練
訓練與教學課程
搭配 Ruby on Rails 5 使用 PostgreSQL 適用的 Cloud SQL
瞭解如何將 Ruby on Rails 5 應用程式連線至 PostgreSQL 適用的 Cloud SQL。
訓練
訓練與教學課程
使用 Cloud Functions 連線至 Cloud SQL
瞭解如何從 Cloud Functions 連線至 Cloud SQL。
用途
用途
使用 Compute Engine 和 Cloud SQL 部署 Pega
瞭解如何使用 PostgreSQL 適用的 Cloud SQL 部署 Pega Platform,這個平台提供業務流程管理和客戶關係管理 (CRM) 功能。
客戶關係管理
參考架構
用途
用途
正式發布檢查清單
這份檢查清單列出建議完成的動作,協助您推出使用 Cloud SQL 的商業應用程式。此檢查清單建議的動作適用於 Cloud SQL。
正式版
推出
用途
用途
資料落地總覽
瞭解如何使用 Cloud SQL,對資料強制執行資料落地規定。
資料落地權
資料
用途
用途
使用 Secret Manager 處理 Cloud SQL 中的密鑰
瞭解如何使用 Secret Manager,將 Cloud SQL 執行個體和使用者的機密資訊儲存為密鑰。
Secret Manager
secret
程式碼範例
程式碼範例
Python SQLAlchemy
將 SQLAlchemy 與 PostgreSQL 適用的 Cloud SQL 資料庫搭配使用
程式碼範例
程式碼範例
Node.js 範例
在 Node.js 中連線至 PostgreSQL 適用的 Cloud SQL 資料庫
程式碼範例
程式碼範例
PHP PDO
使用 PHP PDO 連線至 PostgreSQL 適用的 Cloud SQL 資料庫
程式碼範例
程式碼範例
前往網路應用程式範例
使用 Go 連線至 PostgreSQL 適用的 Cloud SQL 的簡單範例
程式碼範例
程式碼範例
.NET 範例
這個範例應用程式示範在 Google App Engine 彈性環境中執行時,如何使用 PostgreSQL 資料庫將資料儲存在 Google Cloud SQL 中。
程式碼範例
程式碼範例
使用 Terraform 建立 PostgreSQL 適用的 Cloud SQL 執行個體,並設定私人網路選項。
程式碼範例
程式碼範例
Java Servlet
從 Java 應用程式連線至 PostgreSQL 適用的 Cloud SQL
除非另有註明,否則本頁面中的內容是採用創用 CC 姓名標示 4.0 授權,程式碼範例則為阿帕契 2.0 授權。詳情請參閱《Google Developers 網站政策》。Java 是 Oracle 和/或其關聯企業的註冊商標。
上次更新時間:2025-09-04 (世界標準時間)。
[[["容易理解","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-09-04 (世界標準時間)。"],[],[],null,["# Cloud SQL for PostgreSQL documentation\n======================================\n\n[Read product documentation](/sql/docs/postgres/features) Cloud SQL for PostgreSQL is a fully-managed database service that\nhelps you set up, maintain, manage, and administer your\nPostgreSQL relational databases on Google Cloud Platform.\n\n[Learn more](/sql/docs/postgres/features)\n[Get started for free](https://console.cloud.google.com/freetrial) \n\n#### Start your proof of concept with $300 in free credit\n\n- Get access to Gemini 2.0 Flash Thinking\n- Free monthly usage of popular products, including AI APIs and BigQuery\n- No automatic charges, no commitment \n[View free product offers](/free/docs/free-cloud-features#free-tier) \n\n#### Keep exploring with 20+ always-free products\n\n\nAccess 20+ free products for common use cases, including AI APIs, VMs, data warehouses,\nand more.\n\nDocumentation resources\n-----------------------\n\nFind quickstarts and guides, review key references, and get help with common issues. \nformat_list_numbered\n\n### Guides\n\n-\n\n [Create instances](/sql/docs/postgres/create-instance)\n\n-\n\n [Connection overview](/sql/docs/postgres/connect-overview)\n\n-\n\n [Enable and disable high availability on an instance](/sql/docs/postgres/configure-ha)\n\n-\n\n [Create and manage PostgreSQL databases](/sql/docs/postgres/create-manage-databases)\n\n-\n\n [Create and manage PostgreSQL users](/sql/docs/postgres/create-manage-users)\n\n-\n\n [Export and import using pg_dump, pg_dumpall, and pg_restore](/sql/docs/postgres/import-export/import-export-dmp)\n\n-\n\n [Export and import using CSV files](/sql/docs/postgres/import-export/import-export-csv)\n\n-\n\n [Create backups](/sql/docs/postgres/backup-recovery/backups)\n\n-\n\n [Create read replicas](/sql/docs/postgres/replication/create-replica)\n\n-\n\n [Build generative AI applications using Cloud SQL](/sql/docs/postgres/ai-overview)\n\nfind_in_page\n\n### Reference\n\n-\n\n [Client libraries and sample code for Cloud SQL](/sql/docs/postgres/admin-api/libraries)\n\n-\n\n [gcloud sql command-line](/sql/docs/postgres/cloud-sdk)\n\n-\n\n [Use the Cloud SQL Admin API](/sql/docs/postgres/admin-api)\n\n-\n\n [REST API](/sql/docs/postgres/admin-api/rest)\n\n-\n\n [Best practices](/sql/docs/postgres/best-practices)\n\n-\n\n [Performance tips](/sql/docs/postgres/admin-api/how-tos/performance)\n\n-\n\n [Authorize requests](/sql/docs/postgres/admin-api/how-tos/authorizing)\n\n-\n\n [Configure VPC Service Controls](/sql/docs/postgres/admin-api/configure-service-controls)\n\n-\n\n [Cloud SQL Admin API error messages](/sql/docs/postgres/admin-api-error-messages)\n\ninfo\n\n### Resources\n\n-\n\n [Pricing](/sql/docs/postgres/pricing)\n\n-\n\n [Quotas and limits](/sql/docs/postgres/quotas)\n\n-\n\n [Troubleshoot](/sql/docs/postgres/troubleshooting)\n\n-\n\n [Cloud SQL feature support by database engine](/sql/docs/feature_support)\n\n-\n\n [Release notes](/sql/docs/postgres/release-notes)\n\n-\n\n [Billing questions](/sql/docs/postgres/billing-questions)\n\n-\n\n [Getting support](/sql/docs/postgres/getting-support)\n\n-\n\n [Security bulletins](/sql/docs/postgres/security-bulletins)\n\nRelated resources\n-----------------\n\nTraining and tutorials \nUse cases \nCode samples \nExplore self-paced training, use cases, reference architectures, and code samples with examples of how to use and connect Google Cloud services. Training \nTraining and tutorials\n\n### Using Cloud SQL for PostgreSQL with Ruby on Rails 5\n\n\nLearn how to connect a Ruby on Rails 5 app to Cloud SQL for PostgreSQL.\n\n\n[Learn more](/ruby/rails/using-cloudsql-postgres) \nTraining \nTraining and tutorials\n\n### Connecting to Cloud SQL with Cloud Functions\n\n\nLearn how to connect to Cloud SQL from Cloud Functions.\n\n\n[Learn more](https://codelabs.developers.google.com/codelabs/connecting-to-cloud-sql-with-cloud-functions/) \nUse case \nUse cases\n\n### Deploying Pega using Compute Engine and Cloud SQL\n\n\nLearn how to deploy Pega Platform, which is a business process management and customer relationship management (CRM) platform with Cloud SQL for PostgreSQL.\n\nCRM Reference architecture\n\n\u003cbr /\u003e\n\n[Learn more](/solutions/deploying-pega-7-using-compute-engine-and-cloud-sql) \nUse case \nUse cases\n\n### Production launch checklist\n\n\nThis checklist provides recommended activities to complete for launching a commercial application that uses Cloud SQL. This checklist focuses on Cloud SQL-specific activities.\n\nProduction Launch\n\n\u003cbr /\u003e\n\n[Learn more](/sql/docs/postgres/launch-checklist) \nUse case \nUse cases\n\n### Data residency overview\n\n\nLearn how to use Cloud SQL to enforce data residency requirements for data.\n\nData residency data\n\n\u003cbr /\u003e\n\n[Learn more](/sql/docs/postgres/data-residency-overview) \nUse case \nUse cases\n\n### Use Secret Manager to handle secrets in Cloud SQL\n\n\nLearn how to use Secret Manager to store sensitive information about Cloud SQL instances\nand users as secrets.\n\nSecret Manager secret\n\n\u003cbr /\u003e\n\n[Learn more](/sql/docs/postgres/use-secret-manager) \nCode sample \nCode Samples\n\n### Python SQLAlchemy\n\n\nUse SQLAlchemy with your Cloud SQL for PostgreSQL database\n\n\n[Open GitHub\narrow_forward](https://github.com/GoogleCloudPlatform/python-docs-samples/tree/master/cloud-sql/postgres/sqlalchemy) \nCode sample \nCode Samples\n\n### Node.js sample\n\n\nConnecting to your Cloud SQL for PostgreSQL database in Node.js\n\n\n[Open GitHub\narrow_forward](https://github.com/GoogleCloudPlatform/nodejs-docs-samples/tree/master/cloud-sql/postgres/knex) \nCode sample \nCode Samples\n\n### PHP PDO\n\n\nConnecting your Cloud SQL for PostgreSQL database using PHP PDO\n\n\n[Open GitHub\narrow_forward](https://github.com/GoogleCloudPlatform/php-docs-samples/tree/main/cloud_sql/postgres/pdo) \nCode sample \nCode Samples\n\n### Go web app sample\n\n\nSimple examples of connecting to Cloud SQL for PostgreSQL using Go\n\n\n[Open GitHub\narrow_forward](https://github.com/GoogleCloudPlatform/golang-samples/tree/master/cloudsql/postgres/database-sql) \nCode sample \nCode Samples\n\n### .NET sample\n\n\nThis sample application demonstrates how to store data in Google Cloud SQL with a PostgreSQL database when running in Google App Engine Flexible Environment.\n\n\n[Open GitHub\narrow_forward](https://github.com/GoogleCloudPlatform/dotnet-docs-samples/tree/master/cloud-sql/postgres) \nCode sample \nCode Samples\n\n### Terraform for Cloud SQL networking\n\n\nUse Terraform to create Cloud SQL for PostgreSQL instances with private networking options.\n\n\n[Open GitHub\narrow_forward](https://github.com/GoogleCloudPlatform/cloudnetworking-config-solutions) \nCode sample \nCode Samples\n\n### Java servlet\n\n\nConnecting to Cloud SQL for PostgreSQL from a Java application\n\n\n[Open GitHub\narrow_forward](https://github.com/GoogleCloudPlatform/java-docs-samples/tree/master/cloud-sql/postgres/servlet)\n\nRelated videos\n--------------\n\n### Try Cloud SQL for yourself\n\nCreate an account to evaluate how our products perform in real-world scenarios. \nNew customers also get $300 in free credits to run, test, and deploy workloads. \n[Try Cloud SQL free](https://console.cloud.google.com/freetrial)"]]