Back to Details

azure-database-postgresql

Compare original and translation side by side

🇺🇸

Original

English
🇨🇳

Translation

Chinese

Azure Database for PostgreSQL Skill

Azure Database for PostgreSQL Skill

This skill provides expert guidance for Azure Database for PostgreSQL. Covers troubleshooting, best practices, decision making, architecture & design patterns, limits & quotas, security, configuration, integrations & coding patterns, and deployment. It combines local quick-reference content with remote documentation fetching capabilities.
本Skill为Azure Database for PostgreSQL提供专业指导，涵盖故障排查、最佳实践、决策制定、架构与设计模式、限制与配额、安全、配置、集成与编码模式以及部署等内容。它结合了本地快速参考内容与远程文档获取功能。

How to Use This Skill

如何使用本Skill

IMPORTANT for Agent: This file may be large. Use the Category Index below to locate relevant sections, then use 
read_file
with specific line ranges (e.g., 
L136-L144
) to read the sections needed for the user's question
IMPORTANT for Agent: If 
metadata.generated_at
is more than 3 months old, suggest the user pull the latest version from the repository. If 
mcp_microsoftdocs
tools are not available, suggest the user install it: Installation Guide
This skill requires network access to fetch documentation content:
  • Preferred: Use 
    mcp_microsoftdocs:microsoft_docs_fetch
    with query string 
    from=learn-agent-skill
    . Returns Markdown.
  • Fallback: Use 
    fetch_webpage
    with query string 
    from=learn-agent-skill&accept=text/markdown
    . Returns Markdown.
Agent注意事项：本文件可能较大，请使用下方的分类索引定位相关章节，然后使用
read_file
工具并指定具体行范围（例如
L136-L144
）来读取用户问题所需的章节内容
Agent注意事项：如果
metadata.generated_at
的时间超过3个月，请建议用户从仓库拉取最新版本。如果
mcp_microsoftdocs
工具不可用，请建议用户安装该工具：安装指南
本Skill需要网络访问权限来获取文档内容：
  • 优先方式：使用
    mcp_microsoftdocs:microsoft_docs_fetch
    工具，查询字符串为
    from=learn-agent-skill
    ，返回Markdown格式内容。
  • 备选方式：使用
    fetch_webpage
    工具，查询字符串为
    from=learn-agent-skill&accept=text/markdown
    ，返回Markdown格式内容。

Category Index

分类索引

CategoryLinesDescription
TroubleshootingL37-L58Diagnosing and fixing Azure PostgreSQL issues: connectivity/TLS, HA and replicas, CPU/memory/IOPS, slow queries, autovacuum, extensions/CLI/storage, capacity, and migration validation errors.
Best PracticesL59-L76Performance, security, migration, and tooling best practices for Azure PostgreSQL: tuning queries, extensions, pooling, bulk load, stats, partitioning, pgvector, Oracle migration, and backups.
Decision MakingL77-L89Guidance on sizing, scaling, and hosting Azure PostgreSQL, planning geo-replication/DR, and making cost/support decisions like reserved capacity and version extended support.
Architecture & Design PatternsL90-L100Patterns for using Azure PostgreSQL (often with OpenAI) to build recommendation/semantic search apps, microservices, multitenancy, real-time dashboards, and sharded/elastic data architectures.
Limits & QuotasL101-L120Backup/restore behavior, geo-restore and recovery, storage types/limits/performance, quotas and capacity limits, replica and connection limits, and known migration/conversion constraints
SecurityL121-L151Securing Azure Database for PostgreSQL: auth (Entra, SCRAM, TLS/SSL), firewall/VNet/Private Link, managed identities, encryption, auditing, roles, policies, and Defender for Cloud.
ConfigurationL152-L241Configuring Azure Database for PostgreSQL: server parameters, extensions, HA, maintenance, logging/monitoring, performance tuning, networking, migration settings, and WAL/replication options.
Integrations & Coding PatternsL242-L271Using Azure PostgreSQL with AI/ML (Azure AI, OpenAI, LangChain, Foundry), app SDKs (C#, Java, Python, Go, PHP), VS Code/Copilot, Storage, Data Factory, and migration tools (Ora2Pg, pg_dump).
DeploymentL272-L282CI/CD deployment to Azure PostgreSQL, major upgrades, Bicep-based provisioning, app deployments (Django/AKS, Web Apps + VNet), maintenance rollout behavior, and point-in-time restore.
分类行范围描述
故障排查L37-L58诊断并修复Azure PostgreSQL问题：连接性/TLS、高可用与副本、CPU/内存/IOPS、慢查询、自动清理、扩展/CLI/存储、容量以及迁移验证错误。
最佳实践L59-L76Azure PostgreSQL的性能、安全、迁移与工具最佳实践：查询调优、扩展、连接池、批量加载、统计信息、分区、pgvector、Oracle迁移以及备份。
决策制定L77-L89Azure PostgreSQL的规格选型、扩容与托管方式指导，地理复制/灾难恢复规划，以及成本/支持决策（如预留容量、版本扩展支持）。
架构与设计模式L90-L100使用Azure PostgreSQL（常结合OpenAI）构建推荐系统/语义搜索应用、微服务、多租户、实时仪表板以及分片/弹性数据架构的模式。
限制与配额L101-L120备份/恢复行为、异地恢复、存储类型/限制/性能、配额与容量限制、副本与连接限制，以及已知的迁移/转换约束
安全L121-L151保护Azure Database for PostgreSQL：身份验证（Entra、SCRAM、TLS/SSL）、防火墙/VNet/专用链接、托管标识、加密、审计、角色、策略以及Defender for Cloud。
配置L152-L241配置Azure Database for PostgreSQL：服务器参数、扩展、高可用、维护、日志/监控、性能调优、网络、迁移设置以及WAL/复制选项。
集成与编码模式L242-L271将Azure PostgreSQL与AI/ML（Azure AI、OpenAI、LangChain、Foundry）、应用SDK（C#、Java、Python、Go、PHP）、VS Code/Copilot、Storage、Data Factory以及迁移工具（Ora2Pg、pg_dump）结合使用。
部署L272-L282向Azure PostgreSQL进行CI/CD部署、大版本升级、基于Bicep的资源部署、应用部署（Django/AKS、Web Apps + VNet）、维护发布行为以及时间点恢复。

Troubleshooting

故障排查

TopicURL
Troubleshoot PostgreSQL extension management errors on Azurehttps://learn.microsoft.com/en-us/azure/postgresql/extensions/errors-extensions
Monitor and troubleshoot HA health for Azure PostgreSQLhttps://learn.microsoft.com/en-us/azure/postgresql/high-availability/how-to-monitor-high-availability
Resolve premigration validation error codes for PostgreSQL migrationhttps://learn.microsoft.com/en-us/azure/postgresql/migrate/migration-service/troubleshoot-error-codes
Interpret and apply autonomous tuning recommendationshttps://learn.microsoft.com/en-us/azure/postgresql/monitor/how-to-get-apply-recommendations-from-autonomous-tuning
Troubleshoot TLS connection failures in Azure PostgreSQLhttps://learn.microsoft.com/en-us/azure/postgresql/security/security-tls-troubleshoot
Diagnose transient connectivity errors in Azure PostgreSQLhttps://learn.microsoft.com/en-us/azure/postgresql/troubleshoot/concepts-connectivity
Monitor and tune autovacuum in Azure PostgreSQLhttps://learn.microsoft.com/en-us/azure/postgresql/troubleshoot/how-to-autovacuum-tuning
Diagnose and mitigate high CPU in PostgreSQLhttps://learn.microsoft.com/en-us/azure/postgresql/troubleshoot/how-to-high-cpu-utilization
Troubleshoot high CPU in PostgreSQL elastic clustershttps://learn.microsoft.com/en-us/azure/postgresql/troubleshoot/how-to-high-cpu-utilization-elastic-clusters
Investigate and reduce high IOPS in PostgreSQLhttps://learn.microsoft.com/en-us/azure/postgresql/troubleshoot/how-to-high-io-utilization
Diagnose and fix high memory usage in PostgreSQLhttps://learn.microsoft.com/en-us/azure/postgresql/troubleshoot/how-to-high-memory-utilization
Diagnose slow queries on Azure PostgreSQL flexible serverhttps://learn.microsoft.com/en-us/azure/postgresql/troubleshoot/how-to-identify-slow-queries
Resolve capacity errors when deploying or scaling Azure PostgreSQLhttps://learn.microsoft.com/en-us/azure/postgresql/troubleshoot/how-to-resolve-capacity-errors
Troubleshoot Azure CLI errors for PostgreSQLhttps://learn.microsoft.com/en-us/azure/postgresql/troubleshoot/how-to-troubleshoot-cli-errors
Troubleshoot connection issues to Azure PostgreSQLhttps://learn.microsoft.com/en-us/azure/postgresql/troubleshoot/how-to-troubleshoot-common-connection-issues
Troubleshoot Azure Storage extension errors in PostgreSQLhttps://learn.microsoft.com/en-us/azure/postgresql/troubleshoot/troubleshoot-azure-storage-extension
Resolve read replica conflict with recovery errorshttps://learn.microsoft.com/en-us/azure/postgresql/troubleshoot/troubleshoot-canceling-statement-due-to-conflict-with-recovery
Fix password authentication failed errors in PostgreSQLhttps://learn.microsoft.com/en-us/azure/postgresql/troubleshoot/troubleshoot-password-authentication-failed-for-user
主题链接
排查Azure上PostgreSQL扩展管理错误https://learn.microsoft.com/en-us/azure/postgresql/extensions/errors-extensions
监控并排查Azure PostgreSQL的高可用健康状况https://learn.microsoft.com/en-us/azure/postgresql/high-availability/how-to-monitor-high-availability
解决PostgreSQL迁移的预迁移验证错误代码https://learn.microsoft.com/en-us/azure/postgresql/migrate/migration-service/troubleshoot-error-codes
解读并应用自主调优建议https://learn.microsoft.com/en-us/azure/postgresql/monitor/how-to-get-apply-recommendations-from-autonomous-tuning
排查Azure PostgreSQL中的TLS连接失败问题https://learn.microsoft.com/en-us/azure/postgresql/security/security-tls-troubleshoot
诊断Azure PostgreSQL中的临时连接错误https://learn.microsoft.com/en-us/azure/postgresql/troubleshoot/concepts-connectivity
监控并调优Azure PostgreSQL的自动清理功能https://learn.microsoft.com/en-us/azure/postgresql/troubleshoot/how-to-autovacuum-tuning
诊断并缓解PostgreSQL中的高CPU占用问题https://learn.microsoft.com/en-us/azure/postgresql/troubleshoot/how-to-high-cpu-utilization
排查PostgreSQL弹性集群中的高CPU占用问题https://learn.microsoft.com/en-us/azure/postgresql/troubleshoot/how-to-high-cpu-utilization-elastic-clusters
调查并降低PostgreSQL中的高IOPS占用https://learn.microsoft.com/en-us/azure/postgresql/troubleshoot/how-to-high-io-utilization
诊断并修复PostgreSQL中的高内存占用问题https://learn.microsoft.com/en-us/azure/postgresql/troubleshoot/how-to-high-memory-utilization
诊断Azure PostgreSQL灵活服务器上的慢查询https://learn.microsoft.com/en-us/azure/postgresql/troubleshoot/how-to-identify-slow-queries
解决部署或扩容Azure PostgreSQL时的容量错误https://learn.microsoft.com/en-us/azure/postgresql/troubleshoot/how-to-resolve-capacity-errors
排查Azure CLI操作PostgreSQL时的错误https://learn.microsoft.com/en-us/azure/postgresql/troubleshoot/how-to-troubleshoot-cli-errors
排查与Azure PostgreSQL的连接问题https://learn.microsoft.com/en-us/azure/postgresql/troubleshoot/how-to-troubleshoot-common-connection-issues
排查PostgreSQL中Azure Storage扩展的错误https://learn.microsoft.com/en-us/azure/postgresql/troubleshoot/troubleshoot-azure-storage-extension
解决只读副本与恢复的冲突错误https://learn.microsoft.com/en-us/azure/postgresql/troubleshoot/troubleshoot-canceling-statement-due-to-conflict-with-recovery
修复PostgreSQL中的密码验证失败错误https://learn.microsoft.com/en-us/azure/postgresql/troubleshoot/troubleshoot-password-authentication-failed-for-user

Best Practices

最佳实践

TopicURL
Optimize Apache AGE graph query performance on Azurehttps://learn.microsoft.com/en-us/azure/postgresql/azure-ai/generative-ai-age-performance
Use pg_partman to partition large tables on Azurehttps://learn.microsoft.com/en-us/azure/postgresql/configure-maintain/how-to-use-pg-partman
Apply connection pooling best practices for Azure PostgreSQLhttps://learn.microsoft.com/en-us/azure/postgresql/connectivity/concepts-connection-pooling-best-practices
Apply Azure-specific considerations for PostgreSQL extensionshttps://learn.microsoft.com/en-us/azure/postgresql/extensions/concepts-extensions-considerations
Optimize pgvector performance on Azure PostgreSQLhttps://learn.microsoft.com/en-us/azure/postgresql/extensions/how-to-optimize-performance-pgvector
Use best practices for Oracle-to-Azure PostgreSQL migrationshttps://learn.microsoft.com/en-us/azure/postgresql/migrate/best-practices-oracle-to-postgresql
Apply best practices for migrating to Azure PostgreSQLhttps://learn.microsoft.com/en-us/azure/postgresql/migrate/migration-service/best-practices-migration-service-postgresql
Apply best practices for Oracle-to-PostgreSQL schema conversionhttps://learn.microsoft.com/en-us/azure/postgresql/migrate/oracle-schema-conversions/schema-conversions-best-practices
Apply query store best practices in PostgreSQLhttps://learn.microsoft.com/en-us/azure/postgresql/monitor/concepts-query-store-best-practices
Apply security best practices to Azure PostgreSQLhttps://learn.microsoft.com/en-us/azure/postgresql/security/security-overview
Bulk load data into Azure PostgreSQL flexible serverhttps://learn.microsoft.com/en-us/azure/postgresql/troubleshoot/how-to-bulk-load-data
Optimize pg_stat_statements query stats on Azure PostgreSQLhttps://learn.microsoft.com/en-us/azure/postgresql/troubleshoot/how-to-optimize-query-stats-collection
Use pg_repack to remove bloat on Azure PostgreSQLhttps://learn.microsoft.com/en-us/azure/postgresql/troubleshoot/how-to-perform-fullvacuum-pg-repack
Tune pg_dump and pg_restore for Azure PostgreSQLhttps://learn.microsoft.com/en-us/azure/postgresql/troubleshoot/how-to-pgdump-restore
主题链接
在Azure上优化Apache AGE图查询性能https://learn.microsoft.com/en-us/azure/postgresql/azure-ai/generative-ai-age-performance
在Azure上使用pg_partman对大表进行分区https://learn.microsoft.com/en-us/azure/postgresql/configure-maintain/how-to-use-pg-partman
应用Azure PostgreSQL的连接池最佳实践https://learn.microsoft.com/en-us/azure/postgresql/connectivity/concepts-connection-pooling-best-practices
应用PostgreSQL扩展的Azure特定注意事项https://learn.microsoft.com/en-us/azure/postgresql/extensions/concepts-extensions-considerations
在Azure PostgreSQL上优化pgvector性能https://learn.microsoft.com/en-us/azure/postgresql/extensions/how-to-optimize-performance-pgvector
应用Oracle到Azure PostgreSQL迁移的最佳实践https://learn.microsoft.com/en-us/azure/postgresql/migrate/best-practices-oracle-to-postgresql
应用迁移到Azure PostgreSQL的最佳实践https://learn.microsoft.com/en-us/azure/postgresql/migrate/migration-service/best-practices-migration-service-postgresql
应用Oracle到PostgreSQL schema转换的最佳实践https://learn.microsoft.com/en-us/azure/postgresql/migrate/oracle-schema-conversions/schema-conversions-best-practices
应用PostgreSQL中查询存储的最佳实践https://learn.microsoft.com/en-us/azure/postgresql/monitor/concepts-query-store-best-practices
应用Azure PostgreSQL的安全最佳实践https://learn.microsoft.com/en-us/azure/postgresql/security/security-overview
向Azure PostgreSQL灵活服务器批量加载数据https://learn.microsoft.com/en-us/azure/postgresql/troubleshoot/how-to-bulk-load-data
在Azure PostgreSQL上优化pg_stat_statements查询统计https://learn.microsoft.com/en-us/azure/postgresql/troubleshoot/how-to-optimize-query-stats-collection
在Azure PostgreSQL上使用pg_repack清理数据膨胀https://learn.microsoft.com/en-us/azure/postgresql/troubleshoot/how-to-perform-fullvacuum-pg-repack
调优Azure PostgreSQL的pg_dump与pg_restorehttps://learn.microsoft.com/en-us/azure/postgresql/troubleshoot/how-to-pgdump-restore

Decision Making

决策制定

TopicURL
Plan geo-disaster recovery for Azure PostgreSQL flexible serverhttps://learn.microsoft.com/en-us/azure/postgresql/backup-restore/concepts-geo-disaster-recovery
Choose compute tiers for Azure PostgreSQL flexible serverhttps://learn.microsoft.com/en-us/azure/postgresql/compute-storage/concepts-compute
Decide on reserved capacity purchases for Azure PostgreSQLhttps://learn.microsoft.com/en-us/azure/postgresql/configure-maintain/concepts-reserved-pricing
Decide on extended support for Azure PostgreSQL versionshttps://learn.microsoft.com/en-us/azure/postgresql/configure-maintain/extended-support
Choose Azure PostgreSQL hosting and deployment optionshttps://learn.microsoft.com/en-us/azure/postgresql/configure-maintain/overview-postgres-choose-server-options
Use pre-migration checklist to size Azure PostgreSQL targetshttps://learn.microsoft.com/en-us/azure/postgresql/migrate/best-practices-oracle-to-postgresql-checklist
Use premigration validations for Azure PostgreSQL migrationshttps://learn.microsoft.com/en-us/azure/postgresql/migrate/migration-service/concepts-premigration-migration-service
Plan geo-replication for Azure PostgreSQL flexible serverhttps://learn.microsoft.com/en-us/azure/postgresql/read-replica/concepts-read-replicas-geo
Scale compute tiers for Azure PostgreSQL flexible serverhttps://learn.microsoft.com/en-us/azure/postgresql/scale/how-to-scale-compute
主题链接
规划Azure PostgreSQL灵活服务器的异地灾难恢复https://learn.microsoft.com/en-us/azure/postgresql/backup-restore/concepts-geo-disaster-recovery
为Azure PostgreSQL灵活服务器选择计算层https://learn.microsoft.com/en-us/azure/postgresql/compute-storage/concepts-compute
决定是否购买Azure PostgreSQL的预留容量https://learn.microsoft.com/en-us/azure/postgresql/configure-maintain/concepts-reserved-pricing
决定是否为Azure PostgreSQL版本选择扩展支持https://learn.microsoft.com/en-us/azure/postgresql/configure-maintain/extended-support
选择Azure PostgreSQL的托管与部署选项https://learn.microsoft.com/en-us/azure/postgresql/configure-maintain/overview-postgres-choose-server-options
使用预迁移清单来规划Azure PostgreSQL目标的规格https://learn.microsoft.com/en-us/azure/postgresql/migrate/best-practices-oracle-to-postgresql-checklist
对Azure PostgreSQL迁移进行预迁移验证https://learn.microsoft.com/en-us/azure/postgresql/migrate/migration-service/concepts-premigration-migration-service
规划Azure PostgreSQL灵活服务器的地理复制https://learn.microsoft.com/en-us/azure/postgresql/read-replica/concepts-read-replicas-geo
为Azure PostgreSQL灵活服务器扩容计算层https://learn.microsoft.com/en-us/azure/postgresql/scale/how-to-scale-compute

Architecture & Design Patterns

架构与设计模式

TopicURL
Build recommendation systems with Azure PostgreSQL and OpenAIhttps://learn.microsoft.com/en-us/azure/postgresql/azure-ai/generative-ai-recommendation-system
Implement semantic search with Azure PostgreSQL and OpenAIhttps://learn.microsoft.com/en-us/azure/postgresql/azure-ai/generative-ai-semantic-search
Design microservices data architecture with PostgreSQL elastic clustershttps://learn.microsoft.com/en-us/azure/postgresql/configure-maintain/tutorial-microservices
Design multitenant apps with Azure PostgreSQL elastic clustershttps://learn.microsoft.com/en-us/azure/postgresql/configure-maintain/tutorial-multitenant-database
Design real-time dashboards with PostgreSQL elastic clustershttps://learn.microsoft.com/en-us/azure/postgresql/configure-maintain/tutorial-real-time-dashboard
Choose sharding models for Azure PostgreSQL elastic clustershttps://learn.microsoft.com/en-us/azure/postgresql/elastic-clusters/concepts-elastic-clusters-sharding-models
Select table types in Azure PostgreSQL elastic clustershttps://learn.microsoft.com/en-us/azure/postgresql/elastic-clusters/concepts-elastic-clusters-table-types
主题链接
使用Azure PostgreSQL与OpenAI构建推荐系统https://learn.microsoft.com/en-us/azure/postgresql/azure-ai/generative-ai-recommendation-system
使用Azure PostgreSQL与OpenAI实现语义搜索https://learn.microsoft.com/en-us/azure/postgresql/azure-ai/generative-ai-semantic-search
使用PostgreSQL弹性集群设计微服务数据架构https://learn.microsoft.com/en-us/azure/postgresql/configure-maintain/tutorial-microservices
使用Azure PostgreSQL弹性集群设计多租户应用https://learn.microsoft.com/en-us/azure/postgresql/configure-maintain/tutorial-multitenant-database
使用PostgreSQL弹性集群设计实时仪表板https://learn.microsoft.com/en-us/azure/postgresql/configure-maintain/tutorial-real-time-dashboard
为Azure PostgreSQL弹性集群选择分片模型https://learn.microsoft.com/en-us/azure/postgresql/elastic-clusters/concepts-elastic-clusters-sharding-models
在Azure PostgreSQL弹性集群中选择表类型https://learn.microsoft.com/en-us/azure/postgresql/elastic-clusters/concepts-elastic-clusters-table-types

Limits & Quotas

限制与配额

TopicURL
Understand backup and restore behavior for Azure PostgreSQLhttps://learn.microsoft.com/en-us/azure/postgresql/backup-restore/concepts-backup-restore
Recover dropped Azure PostgreSQL flexible servers from backupshttps://learn.microsoft.com/en-us/azure/postgresql/backup-restore/how-to-restore-dropped-server
Perform geo-restore to paired regions for Azure PostgreSQLhttps://learn.microsoft.com/en-us/azure/postgresql/backup-restore/how-to-restore-paired-region
Understand storage limits for Azure PostgreSQL flexible serverhttps://learn.microsoft.com/en-us/azure/postgresql/compute-storage/concepts-storage
Use Premium SSD storage with Azure PostgreSQL flexible serverhttps://learn.microsoft.com/en-us/azure/postgresql/compute-storage/concepts-storage-premium-ssd
Configure Premium SSD v2 performance for Azure PostgreSQLhttps://learn.microsoft.com/en-us/azure/postgresql/compute-storage/concepts-storage-premium-ssd-v2
Review capacity and functional limits for Azure PostgreSQLhttps://learn.microsoft.com/en-us/azure/postgresql/configure-maintain/concepts-limits
Request quota increases for Azure PostgreSQL flexible serverhttps://learn.microsoft.com/en-us/azure/postgresql/configure-maintain/how-to-request-quota-increase
Review elastic cluster capacity and functional limitshttps://learn.microsoft.com/en-us/azure/postgresql/elastic-clusters/concepts-elastic-clusters-limitations
Understand max client connections in PostgreSQL elastic clustershttps://learn.microsoft.com/en-us/azure/postgresql/elastic-clusters/how-to-network-elastic-clusters-default-maximum-connections
Review known issues and limitations of PostgreSQL migration servicehttps://learn.microsoft.com/en-us/azure/postgresql/migrate/migration-service/concepts-known-issues-migration-service
Understand limitations of Oracle-to-PostgreSQL schema conversion toolhttps://learn.microsoft.com/en-us/azure/postgresql/migrate/oracle-schema-conversions/schema-conversions-limitations
Use read replicas in Azure PostgreSQL flexible serverhttps://learn.microsoft.com/en-us/azure/postgresql/read-replica/concepts-read-replicas
Configure storage autogrow thresholds for Azure PostgreSQLhttps://learn.microsoft.com/en-us/azure/postgresql/scale/how-to-auto-grow-storage
Adjust storage performance for Azure PostgreSQL flexible serverhttps://learn.microsoft.com/en-us/azure/postgresql/scale/how-to-scale-storage-performance
Configure max_replication_slots and slot usage on Azure PostgreSQLhttps://learn.microsoft.com/en-us/azure/postgresql/server-parameters/param-replication-sending-servers
主题链接
了解Azure PostgreSQL的备份与恢复行为https://learn.microsoft.com/en-us/azure/postgresql/backup-restore/concepts-backup-restore
从备份中恢复已删除的Azure PostgreSQL灵活服务器https://learn.microsoft.com/en-us/azure/postgresql/backup-restore/how-to-restore-dropped-server
对Azure PostgreSQL执行到配对区域的异地恢复https://learn.microsoft.com/en-us/azure/postgresql/backup-restore/how-to-restore-paired-region
了解Azure PostgreSQL灵活服务器的存储限制https://learn.microsoft.com/en-us/azure/postgresql/compute-storage/concepts-storage
在Azure PostgreSQL灵活服务器上使用Premium SSD存储https://learn.microsoft.com/en-us/azure/postgresql/compute-storage/concepts-storage-premium-ssd
为Azure PostgreSQL配置Premium SSD v2性能https://learn.microsoft.com/en-us/azure/postgresql/compute-storage/concepts-storage-premium-ssd-v2
查看Azure PostgreSQL的容量与功能限制https://learn.microsoft.com/en-us/azure/postgresql/configure-maintain/concepts-limits
请求提升Azure PostgreSQL灵活服务器的配额https://learn.microsoft.com/en-us/azure/postgresql/configure-maintain/how-to-request-quota-increase
查看弹性集群的容量与功能限制https://learn.microsoft.com/en-us/azure/postgresql/elastic-clusters/concepts-elastic-clusters-limitations
了解PostgreSQL弹性集群中的最大客户端连接数https://learn.microsoft.com/en-us/azure/postgresql/elastic-clusters/how-to-network-elastic-clusters-default-maximum-connections
查看PostgreSQL迁移服务的已知问题与限制https://learn.microsoft.com/en-us/azure/postgresql/migrate/migration-service/concepts-known-issues-migration-service
了解Oracle到PostgreSQL schema转换工具的限制https://learn.microsoft.com/en-us/azure/postgresql/migrate/oracle-schema-conversions/schema-conversions-limitations
在Azure PostgreSQL灵活服务器上使用只读副本https://learn.microsoft.com/en-us/azure/postgresql/read-replica/concepts-read-replicas
为Azure PostgreSQL配置存储自动扩容阈值https://learn.microsoft.com/en-us/azure/postgresql/scale/how-to-auto-grow-storage
调整Azure PostgreSQL灵活服务器的存储性能https://learn.microsoft.com/en-us/azure/postgresql/scale/how-to-scale-storage-performance
在Azure PostgreSQL上配置max_replication_slots与插槽使用https://learn.microsoft.com/en-us/azure/postgresql/server-parameters/param-replication-sending-servers

Security

安全

TopicURL
Enable managed identity for Azure AI extension in PostgreSQLhttps://learn.microsoft.com/en-us/azure/postgresql/azure-ai/generative-ai-enable-managed-identity-azure-ai
Enable deletion protection for Azure PostgreSQL flexible serverhttps://learn.microsoft.com/en-us/azure/postgresql/configure-maintain/how-to-enable-deletion-protection
Configure private access and VNet for Azure PostgreSQLhttps://learn.microsoft.com/en-us/azure/postgresql/connectivity/quickstart-create-connect-server-vnet
Secure Data Factory–PostgreSQL connectivity via Private Linkhttps://learn.microsoft.com/en-us/azure/postgresql/integration/how-to-connect-data-factory-private-endpoint
Assign required permissions to run PostgreSQL migrationshttps://learn.microsoft.com/en-us/azure/postgresql/migrate/migration-service/concepts-required-user-permissions
Create PostgreSQL server and firewall via CLIhttps://learn.microsoft.com/en-us/azure/postgresql/samples/sample-create-server-and-firewall-rule
Create PostgreSQL VNet rule with Azure CLIhttps://learn.microsoft.com/en-us/azure/postgresql/samples/sample-create-server-with-vnet-rule
Configure access control and roles for Azure PostgreSQLhttps://learn.microsoft.com/en-us/azure/postgresql/security/security-access-control
Configure pgaudit-based audit logging in Azure PostgreSQLhttps://learn.microsoft.com/en-us/azure/postgresql/security/security-audit
Apply Azure Policy to secure Azure PostgreSQLhttps://learn.microsoft.com/en-us/azure/postgresql/security/security-azure-policy
Review security and compliance certifications for Azure PostgreSQLhttps://learn.microsoft.com/en-us/azure/postgresql/security/security-compliance
Configure data encryption keys for Azure PostgreSQLhttps://learn.microsoft.com/en-us/azure/postgresql/security/security-configure-data-encryption
Enable system-assigned managed identity for Azure PostgreSQLhttps://learn.microsoft.com/en-us/azure/postgresql/security/security-configure-managed-identities-system-assigned
Configure user-assigned managed identities for Azure PostgreSQLhttps://learn.microsoft.com/en-us/azure/postgresql/security/security-configure-managed-identities-user-assigned
Configure SCRAM authentication for Azure PostgreSQLhttps://learn.microsoft.com/en-us/azure/postgresql/security/security-connect-scram
Connect to Azure PostgreSQL using managed identitieshttps://learn.microsoft.com/en-us/azure/postgresql/security/security-connect-with-managed-identity
Understand data encryption at rest in Azure PostgreSQLhttps://learn.microsoft.com/en-us/azure/postgresql/security/security-data-encryption
Use Defender for Cloud with Azure PostgreSQLhttps://learn.microsoft.com/en-us/azure/postgresql/security/security-defender-for-cloud
Configure Microsoft Entra authentication for Azure PostgreSQLhttps://learn.microsoft.com/en-us/azure/postgresql/security/security-entra-configure
Configure firewall rules for Azure PostgreSQL public accesshttps://learn.microsoft.com/en-us/azure/postgresql/security/security-firewall-rules
Manage PostgreSQL database users on Azure flexible serverhttps://learn.microsoft.com/en-us/azure/postgresql/security/security-manage-database-users
Use managed identities with Azure PostgreSQL securelyhttps://learn.microsoft.com/en-us/azure/postgresql/security/security-managed-identity-overview
Configure TLS/SSL connections to Azure PostgreSQLhttps://learn.microsoft.com/en-us/azure/postgresql/security/security-tls-how-to-connect
Update Java client certificates for Azure PostgreSQL TLShttps://learn.microsoft.com/en-us/azure/postgresql/security/security-update-trusted-root-java
Configure authentication parameters on Azure PostgreSQLhttps://learn.microsoft.com/en-us/azure/postgresql/server-parameters/param-connections-authentication-authentication
Manage SSL connection parameters on Azure PostgreSQLhttps://learn.microsoft.com/en-us/azure/postgresql/server-parameters/param-connections-authentication-ssl
Configure TLS server parameters for Azure PostgreSQLhttps://learn.microsoft.com/en-us/azure/postgresql/server-parameters/param-tls
主题链接
为PostgreSQL中的Azure AI扩展启用托管标识https://learn.microsoft.com/en-us/azure/postgresql/azure-ai/generative-ai-enable-managed-identity-azure-ai
为Azure PostgreSQL灵活服务器启用删除保护https://learn.microsoft.com/en-us/azure/postgresql/configure-maintain/how-to-enable-deletion-protection
为Azure PostgreSQL配置专用访问与VNethttps://learn.microsoft.com/en-us/azure/postgresql/connectivity/quickstart-create-connect-server-vnet
通过专用链接保护Data Factory与PostgreSQL的连接https://learn.microsoft.com/en-us/azure/postgresql/integration/how-to-connect-data-factory-private-endpoint
分配运行PostgreSQL迁移所需的权限https://learn.microsoft.com/en-us/azure/postgresql/migrate/migration-service/concepts-required-user-permissions
通过CLI创建PostgreSQL服务器与防火墙https://learn.microsoft.com/en-us/azure/postgresql/samples/sample-create-server-and-firewall-rule
使用Azure CLI创建PostgreSQL VNet规则https://learn.microsoft.com/en-us/azure/postgresql/samples/sample-create-server-with-vnet-rule
为Azure PostgreSQL配置访问控制与角色https://learn.microsoft.com/en-us/azure/postgresql/security/security-access-control
在Azure PostgreSQL上配置基于pgaudit的审计日志https://learn.microsoft.com/en-us/azure/postgresql/security/security-audit
应用Azure Policy来保护Azure PostgreSQLhttps://learn.microsoft.com/en-us/azure/postgresql/security/security-azure-policy
查看Azure PostgreSQL的安全与合规认证https://learn.microsoft.com/en-us/azure/postgresql/security/security-compliance
为Azure PostgreSQL配置数据加密密钥https://learn.microsoft.com/en-us/azure/postgresql/security/security-configure-data-encryption
为Azure PostgreSQL启用系统分配的托管标识https://learn.microsoft.com/en-us/azure/postgresql/security/security-configure-managed-identities-system-assigned
为Azure PostgreSQL配置用户分配的托管标识https://learn.microsoft.com/en-us/azure/postgresql/security/security-configure-managed-identities-user-assigned
为Azure PostgreSQL配置SCRAM身份验证https://learn.microsoft.com/en-us/azure/postgresql/security/security-connect-scram
使用托管标识连接到Azure PostgreSQLhttps://learn.microsoft.com/en-us/azure/postgresql/security/security-connect-with-managed-identity
了解Azure PostgreSQL中的静态数据加密https://learn.microsoft.com/en-us/azure/postgresql/security/security-data-encryption
将Defender for Cloud与Azure PostgreSQL结合使用https://learn.microsoft.com/en-us/azure/postgresql/security/security-defender-for-cloud
为Azure PostgreSQL配置Microsoft Entra身份验证https://learn.microsoft.com/en-us/azure/postgresql/security/security-entra-configure
为Azure PostgreSQL公网访问配置防火墙规则https://learn.microsoft.com/en-us/azure/postgresql/security/security-firewall-rules
管理Azure灵活服务器上的PostgreSQL数据库用户https://learn.microsoft.com/en-us/azure/postgresql/security/security-manage-database-users
安全地将托管标识与Azure PostgreSQL结合使用https://learn.microsoft.com/en-us/azure/postgresql/security/security-managed-identity-overview
配置到Azure PostgreSQL的TLS/SSL连接https://learn.microsoft.com/en-us/azure/postgresql/security/security-tls-how-to-connect
更新Azure PostgreSQL TLS的Java客户端证书https://learn.microsoft.com/en-us/azure/postgresql/security/security-update-trusted-root-java
在Azure PostgreSQL上配置身份验证参数https://learn.microsoft.com/en-us/azure/postgresql/server-parameters/param-connections-authentication-authentication
在Azure PostgreSQL上管理SSL连接参数https://learn.microsoft.com/en-us/azure/postgresql/server-parameters/param-connections-authentication-ssl
为Azure PostgreSQL配置TLS服务器参数https://learn.microsoft.com/en-us/azure/postgresql/server-parameters/param-tls

Configuration

配置

TopicURL
Configure and plan scheduled maintenance for Azure PostgreSQLhttps://learn.microsoft.com/en-us/azure/postgresql/configure-maintain/concepts-maintenance
Understand major version upgrade behavior for Azure PostgreSQLhttps://learn.microsoft.com/en-us/azure/postgresql/configure-maintain/concepts-major-version-upgrade
Apply server configuration concepts for Azure PostgreSQL flexible serverhttps://learn.microsoft.com/en-us/azure/postgresql/configure-maintain/concepts-servers
Check supported PostgreSQL versions on Azure flexible serverhttps://learn.microsoft.com/en-us/azure/postgresql/configure-maintain/concepts-supported-versions
Schedule maintenance windows for Azure PostgreSQL flexible serverhttps://learn.microsoft.com/en-us/azure/postgresql/configure-maintain/how-to-configure-scheduled-maintenance
Deploy PostgreSQL elastic clusters using ARM templateshttps://learn.microsoft.com/en-us/azure/postgresql/elastic-clusters/quickstart-create-elastic-cluster-arm-template
Deploy PostgreSQL elastic clusters using Bicep templateshttps://learn.microsoft.com/en-us/azure/postgresql/elastic-clusters/quickstart-create-elastic-cluster-bicep
Configure retired azure_local_ai extension for in-database embeddingshttps://learn.microsoft.com/en-us/azure/postgresql/extensions/azure-local-ai
Allow and allowlist PostgreSQL extensions on Azurehttps://learn.microsoft.com/en-us/azure/postgresql/extensions/how-to-allow-extensions
Configure Azure Storage extension for PostgreSQL data import/exporthttps://learn.microsoft.com/en-us/azure/postgresql/extensions/how-to-configure-azure-storage-extension
Create PostgreSQL extensions on Azure flexible serverhttps://learn.microsoft.com/en-us/azure/postgresql/extensions/how-to-create-extensions
Drop PostgreSQL extensions on Azure flexible serverhttps://learn.microsoft.com/en-us/azure/postgresql/extensions/how-to-drop-extensions
Configure shared_preload_libraries for Azure PostgreSQLhttps://learn.microsoft.com/en-us/azure/postgresql/extensions/how-to-load-libraries
Update PostgreSQL extensions on Azure flexible serverhttps://learn.microsoft.com/en-us/azure/postgresql/extensions/how-to-update-extensions
Configure and use DiskANN vector indexing in PostgreSQLhttps://learn.microsoft.com/en-us/azure/postgresql/extensions/how-to-use-pgdiskann
Enable and use pgvector for vector search in PostgreSQLhttps://learn.microsoft.com/en-us/azure/postgresql/extensions/how-to-use-pgvector
View installed PostgreSQL extensions and versions on Azurehttps://learn.microsoft.com/en-us/azure/postgresql/extensions/how-to-view-installed-extensions
Configure high availability for Azure PostgreSQL flexible serverhttps://learn.microsoft.com/en-us/azure/postgresql/high-availability/how-to-configure-high-availability
Configure migration server parameters for Azure PostgreSQLhttps://learn.microsoft.com/en-us/azure/postgresql/migrate/migration-service/concepts-migration-server-parameters
Configure networking scenarios for PostgreSQL migration servicehttps://learn.microsoft.com/en-us/azure/postgresql/migrate/migration-service/how-to-network-setup-migration-service
Configure and access server logs in Azure PostgreSQLhttps://learn.microsoft.com/en-us/azure/postgresql/monitor/concepts-logging
Configure Azure Monitor workbooks for PostgreSQLhttps://learn.microsoft.com/en-us/azure/postgresql/monitor/concepts-workbooks
Set up metric alerts for PostgreSQL in Azurehttps://learn.microsoft.com/en-us/azure/postgresql/monitor/how-to-alert-on-metrics
Configure and access PostgreSQL diagnostic logshttps://learn.microsoft.com/en-us/azure/postgresql/monitor/how-to-configure-and-access-logs
Configure autonomous tuning parameters for PostgreSQLhttps://learn.microsoft.com/en-us/azure/postgresql/monitor/how-to-configure-autonomous-tuning
Configure and download PostgreSQL and upgrade logshttps://learn.microsoft.com/en-us/azure/postgresql/monitor/how-to-configure-server-logs
Manage intelligent tuning settings with Azure CLIhttps://learn.microsoft.com/en-us/azure/postgresql/monitor/how-to-enable-intelligent-performance-cli
Configure intelligent tuning via Azure portalhttps://learn.microsoft.com/en-us/azure/postgresql/monitor/how-to-enable-intelligent-performance-portal
List and change PostgreSQL server configuration via CLIhttps://learn.microsoft.com/en-us/azure/postgresql/samples/sample-change-server-configuration
Scale PostgreSQL server compute and storage via CLIhttps://learn.microsoft.com/en-us/azure/postgresql/samples/sample-scale-server-up-or-down
Enable and download PostgreSQL server logs via CLIhttps://learn.microsoft.com/en-us/azure/postgresql/samples/sample-server-logs
Understand server parameters for Azure PostgreSQL flexible serverhttps://learn.microsoft.com/en-us/azure/postgresql/server-parameters/concepts-server-parameters
List all server parameters for Azure PostgreSQL flexible serverhttps://learn.microsoft.com/en-us/azure/postgresql/server-parameters/how-to-server-parameters-list-all
List Azure PostgreSQL parameters with modified defaultshttps://learn.microsoft.com/en-us/azure/postgresql/server-parameters/how-to-server-parameters-list-modified
List read-only dynamic parameters on Azure PostgreSQLhttps://learn.microsoft.com/en-us/azure/postgresql/server-parameters/how-to-server-parameters-list-read-only
List read-write dynamic parameters on Azure PostgreSQLhttps://learn.microsoft.com/en-us/azure/postgresql/server-parameters/how-to-server-parameters-list-read-write-dynamic
List read-write static parameters on Azure PostgreSQLhttps://learn.microsoft.com/en-us/azure/postgresql/server-parameters/how-to-server-parameters-list-read-write-static
Revert all Azure PostgreSQL parameters to defaultshttps://learn.microsoft.com/en-us/azure/postgresql/server-parameters/how-to-server-parameters-revert-all-default
Revert a single Azure PostgreSQL parameter to defaulthttps://learn.microsoft.com/en-us/azure/postgresql/server-parameters/how-to-server-parameters-revert-one-default
Set Azure PostgreSQL server parameter values safelyhttps://learn.microsoft.com/en-us/azure/postgresql/server-parameters/how-to-server-parameters-set-value
Configure autovacuum parameters on Azure PostgreSQLhttps://learn.microsoft.com/en-us/azure/postgresql/server-parameters/param-autovacuum
Configure client connection default options on Azure PostgreSQLhttps://learn.microsoft.com/en-us/azure/postgresql/server-parameters/param-client-connection-defaults-defaults
Set locale and formatting defaults on Azure PostgreSQLhttps://learn.microsoft.com/en-us/azure/postgresql/server-parameters/param-client-connection-defaults-locale-formatting
Preload shared libraries via client defaults on Azure PostgreSQLhttps://learn.microsoft.com/en-us/azure/postgresql/server-parameters/param-client-connection-defaults-shared-library-preloading
Control statement behavior defaults on Azure PostgreSQLhttps://learn.microsoft.com/en-us/azure/postgresql/server-parameters/param-client-connection-defaults-statement-behavior
Tune connection settings and max_connections on Azure PostgreSQLhttps://learn.microsoft.com/en-us/azure/postgresql/server-parameters/param-connections-authentication-connection-settings
Configure TCP settings for Azure PostgreSQL connectionshttps://learn.microsoft.com/en-us/azure/postgresql/server-parameters/param-connections-authentication-tcp-settings
Use customized server options like azure_storage.blob_block_size_mbhttps://learn.microsoft.com/en-us/azure/postgresql/server-parameters/param-customized-options
Developer options server parameters on Azure PostgreSQLhttps://learn.microsoft.com/en-us/azure/postgresql/server-parameters/param-developer-options
Configure error handling parameters on Azure PostgreSQLhttps://learn.microsoft.com/en-us/azure/postgresql/server-parameters/param-error-handling
File location server parameters for Azure PostgreSQLhttps://learn.microsoft.com/en-us/azure/postgresql/server-parameters/param-file-locations
Intelligent tuning server parameters on Azure PostgreSQLhttps://learn.microsoft.com/en-us/azure/postgresql/server-parameters/param-intelligent-tuning
Lock management server parameters on Azure PostgreSQLhttps://learn.microsoft.com/en-us/azure/postgresql/server-parameters/param-lock-management
Metrics-related server parameters on Azure PostgreSQLhttps://learn.microsoft.com/en-us/azure/postgresql/server-parameters/param-metrics
Migration-related server parameters on Azure PostgreSQLhttps://learn.microsoft.com/en-us/azure/postgresql/server-parameters/param-migration
Configure PgBouncer parameters and tier support on Azure PostgreSQLhttps://learn.microsoft.com/en-us/azure/postgresql/server-parameters/param-pgbouncer
Preset options server parameters on Azure PostgreSQLhttps://learn.microsoft.com/en-us/azure/postgresql/server-parameters/param-preset-options
Process title server parameters on Azure PostgreSQLhttps://learn.microsoft.com/en-us/azure/postgresql/server-parameters/param-process-title
Genetic query optimizer parameters on Azure PostgreSQLhttps://learn.microsoft.com/en-us/azure/postgresql/server-parameters/param-query-tuning-genetic-query-optimizer
Tune planner cost constants like effective_cache_sizehttps://learn.microsoft.com/en-us/azure/postgresql/server-parameters/param-query-tuning-planner-cost-constants
Planner method configuration parameters on Azure PostgreSQLhttps://learn.microsoft.com/en-us/azure/postgresql/server-parameters/param-query-tuning-planner-method-configuration
Other planner options for query tuning on Azure PostgreSQLhttps://learn.microsoft.com/en-us/azure/postgresql/server-parameters/param-query-tuning-planner-options
Replication master server parameters on Azure PostgreSQLhttps://learn.microsoft.com/en-us/azure/postgresql/server-parameters/param-replication-master-server
Understand primary server replication parameters availabilityhttps://learn.microsoft.com/en-us/azure/postgresql/server-parameters/param-replication-primary-server
Standby server replication parameters on Azure PostgreSQLhttps://learn.microsoft.com/en-us/azure/postgresql/server-parameters/param-replication-standby-servers
Subscriber replication parameters on Azure PostgreSQLhttps://learn.microsoft.com/en-us/azure/postgresql/server-parameters/param-replication-subscribers
Control what to log via reporting and logging parametershttps://learn.microsoft.com/en-us/azure/postgresql/server-parameters/param-reporting-logging-what-log
Configure PostgreSQL logging timing parameters in Azurehttps://learn.microsoft.com/en-us/azure/postgresql/server-parameters/param-reporting-logging-when-log
Configure PostgreSQL log destination parameters in Azurehttps://learn.microsoft.com/en-us/azure/postgresql/server-parameters/param-reporting-logging-where-log
Tune asynchronous behavior parameters for Azure PostgreSQLhttps://learn.microsoft.com/en-us/azure/postgresql/server-parameters/param-resource-usage-asynchronous-behavior
Configure background writer parameters on Azure PostgreSQLhttps://learn.microsoft.com/en-us/azure/postgresql/server-parameters/param-resource-usage-background-writer
Adjust cost-based vacuum delay on Azure PostgreSQLhttps://learn.microsoft.com/en-us/azure/postgresql/server-parameters/param-resource-usage-cost-based-vacuum-delay
Configure disk-related resource usage for Azure PostgreSQLhttps://learn.microsoft.com/en-us/azure/postgresql/server-parameters/param-resource-usage-disk
Configure kernel resource usage for Azure PostgreSQLhttps://learn.microsoft.com/en-us/azure/postgresql/server-parameters/param-resource-usage-kernel-resources
Configure memory and huge pages for Azure PostgreSQLhttps://learn.microsoft.com/en-us/azure/postgresql/server-parameters/param-resource-usage-memory
Configure cumulative query and index stats in Azure PostgreSQLhttps://learn.microsoft.com/en-us/azure/postgresql/server-parameters/param-statistics-cumulative-query-index-statistics
Configure monitoring statistics parameters for Azure PostgreSQLhttps://learn.microsoft.com/en-us/azure/postgresql/server-parameters/param-statistics-monitoring
Understand query and index stats collector parameters by versionhttps://learn.microsoft.com/en-us/azure/postgresql/server-parameters/param-statistics-query-index-statistics-collector
Set compatibility parameters for other clients on Azure PostgreSQLhttps://learn.microsoft.com/en-us/azure/postgresql/server-parameters/param-version-platform-compatibility-platforms-clients
Configure compatibility with previous PostgreSQL versions in Azurehttps://learn.microsoft.com/en-us/azure/postgresql/server-parameters/param-version-platform-compatibility-postgresql-versions
Check archive recovery parameters availability by Azure PostgreSQL versionhttps://learn.microsoft.com/en-us/azure/postgresql/server-parameters/param-write-ahead-log-archive-recovery
Configure WAL archiving parameters on Azure PostgreSQLhttps://learn.microsoft.com/en-us/azure/postgresql/server-parameters/param-write-ahead-log-archiving
Tune WAL checkpoint parameters for Azure PostgreSQLhttps://learn.microsoft.com/en-us/azure/postgresql/server-parameters/param-write-ahead-log-checkpoints
Check WAL recovery parameters availability across Azure PostgreSQL versionshttps://learn.microsoft.com/en-us/azure/postgresql/server-parameters/param-write-ahead-log-recovery
Check WAL recovery target parameters availability by versionhttps://learn.microsoft.com/en-us/azure/postgresql/server-parameters/param-write-ahead-log-recovery-target
Configure WAL settings and buffers on Azure PostgreSQLhttps://learn.microsoft.com/en-us/azure/postgresql/server-parameters/param-write-ahead-log-settings
主题链接
配置并规划Azure PostgreSQL的定期维护https://learn.microsoft.com/en-us/azure/postgresql/configure-maintain/concepts-maintenance
了解Azure PostgreSQL的大版本升级行为https://learn.microsoft.com/en-us/azure/postgresql/configure-maintain/concepts-major-version-upgrade
应用Azure PostgreSQL灵活服务器的服务器配置概念https://learn.microsoft.com/en-us/azure/postgresql/configure-maintain/concepts-servers
查看Azure灵活服务器支持的PostgreSQL版本https://learn.microsoft.com/en-us/azure/postgresql/configure-maintain/concepts-supported-versions
为Azure PostgreSQL灵活服务器规划维护窗口https://learn.microsoft.com/en-us/azure/postgresql/configure-maintain/how-to-configure-scheduled-maintenance
使用ARM模板部署PostgreSQL弹性集群https://learn.microsoft.com/en-us/azure/postgresql/elastic-clusters/quickstart-create-elastic-cluster-arm-template
使用Bicep模板部署PostgreSQL弹性集群https://learn.microsoft.com/en-us/azure/postgresql/elastic-clusters/quickstart-create-elastic-cluster-bicep
配置已停用的azure_local_ai扩展以实现数据库内嵌入https://learn.microsoft.com/en-us/azure/postgresql/extensions/azure-local-ai
在Azure上允许并列入PostgreSQL扩展白名单https://learn.microsoft.com/en-us/azure/postgresql/extensions/how-to-allow-extensions
为PostgreSQL数据导入/导出配置Azure Storage扩展https://learn.microsoft.com/en-us/azure/postgresql/extensions/how-to-configure-azure-storage-extension
在Azure灵活服务器上创建PostgreSQL扩展https://learn.microsoft.com/en-us/azure/postgresql/extensions/how-to-create-extensions
在Azure灵活服务器上删除PostgreSQL扩展https://learn.microsoft.com/en-us/azure/postgresql/extensions/how-to-drop-extensions
为Azure PostgreSQL配置shared_preload_librarieshttps://learn.microsoft.com/en-us/azure/postgresql/extensions/how-to-load-libraries
在Azure灵活服务器上更新PostgreSQL扩展https://learn.microsoft.com/en-us/azure/postgresql/extensions/how-to-update-extensions
在PostgreSQL中配置并使用DiskANN向量索引https://learn.microsoft.com/en-us/azure/postgresql/extensions/how-to-use-pgdiskann
在PostgreSQL中启用并使用pgvector进行向量搜索https://learn.microsoft.com/en-us/azure/postgresql/extensions/how-to-use-pgvector
在Azure上查看已安装的PostgreSQL扩展与版本https://learn.microsoft.com/en-us/azure/postgresql/extensions/how-to-view-installed-extensions
为Azure PostgreSQL灵活服务器配置高可用https://learn.microsoft.com/en-us/azure/postgresql/high-availability/how-to-configure-high-availability
为Azure PostgreSQL配置迁移服务器参数https://learn.microsoft.com/en-us/azure/postgresql/migrate/migration-service/concepts-migration-server-parameters
为PostgreSQL迁移服务配置网络场景https://learn.microsoft.com/en-us/azure/postgresql/migrate/migration-service/how-to-network-setup-migration-service
配置并访问Azure PostgreSQL的服务器日志https://learn.microsoft.com/en-us/azure/postgresql/monitor/concepts-logging
为PostgreSQL配置Azure Monitor工作簿https://learn.microsoft.com/en-us/azure/postgresql/monitor/concepts-workbooks
在Azure中为PostgreSQL设置指标警报https://learn.microsoft.com/en-us/azure/postgresql/monitor/how-to-alert-on-metrics
配置并访问PostgreSQL诊断日志https://learn.microsoft.com/en-us/azure/postgresql/monitor/how-to-configure-and-access-logs
为PostgreSQL配置自主调优参数https://learn.microsoft.com/en-us/azure/postgresql/monitor/how-to-configure-autonomous-tuning
配置并下载PostgreSQL与升级日志https://learn.microsoft.com/en-us/azure/postgresql/monitor/how-to-configure-server-logs
使用Azure CLI管理智能调优设置https://learn.microsoft.com/en-us/azure/postgresql/monitor/how-to-enable-intelligent-performance-cli
通过Azure门户配置智能调优https://learn.microsoft.com/en-us/azure/postgresql/monitor/how-to-enable-intelligent-performance-portal
通过CLI列出并更改PostgreSQL服务器配置https://learn.microsoft.com/en-us/azure/postgresql/samples/sample-change-server-configuration
通过CLI扩容PostgreSQL服务器的计算与存储https://learn.microsoft.com/en-us/azure/postgresql/samples/sample-scale-server-up-or-down
通过CLI启用并下载PostgreSQL服务器日志https://learn.microsoft.com/en-us/azure/postgresql/samples/sample-server-logs
了解Azure PostgreSQL灵活服务器的服务器参数https://learn.microsoft.com/en-us/azure/postgresql/server-parameters/concepts-server-parameters
列出Azure PostgreSQL灵活服务器的所有服务器参数https://learn.microsoft.com/en-us/azure/postgresql/server-parameters/how-to-server-parameters-list-all
列出Azure PostgreSQL中默认值已修改的参数https://learn.microsoft.com/en-us/azure/postgresql/server-parameters/how-to-server-parameters-list-modified
列出Azure PostgreSQL上的只读动态参数https://learn.microsoft.com/en-us/azure/postgresql/server-parameters/how-to-server-parameters-list-read-only
列出Azure PostgreSQL上的可读写动态参数https://learn.microsoft.com/en-us/azure/postgresql/server-parameters/how-to-server-parameters-list-read-write-dynamic
列出Azure PostgreSQL上的可读写静态参数https://learn.microsoft.com/en-us/azure/postgresql/server-parameters/how-to-server-parameters-list-read-write-static
将所有Azure PostgreSQL参数恢复为默认值https://learn.microsoft.com/en-us/azure/postgresql/server-parameters/how-to-server-parameters-revert-all-default
将单个Azure PostgreSQL参数恢复为默认值https://learn.microsoft.com/en-us/azure/postgresql/server-parameters/how-to-server-parameters-revert-one-default
安全地设置Azure PostgreSQL服务器参数值https://learn.microsoft.com/en-us/azure/postgresql/server-parameters/how-to-server-parameters-set-value
在Azure PostgreSQL上配置自动清理参数https://learn.microsoft.com/en-us/azure/postgresql/server-parameters/param-autovacuum
在Azure PostgreSQL上配置客户端连接默认选项https://learn.microsoft.com/en-us/azure/postgresql/server-parameters/param-client-connection-defaults-defaults
在Azure PostgreSQL上设置区域设置与格式默认值https://learn.microsoft.com/en-us/azure/postgresql/server-parameters/param-client-connection-defaults-locale-formatting
通过客户端默认值预加载共享库https://learn.microsoft.com/en-us/azure/postgresql/server-parameters/param-client-connection-defaults-shared-library-preloading
控制Azure PostgreSQL上的语句行为默认值https://learn.microsoft.com/en-us/azure/postgresql/server-parameters/param-client-connection-defaults-statement-behavior
调优Azure PostgreSQL的连接设置与max_connectionshttps://learn.microsoft.com/en-us/azure/postgresql/server-parameters/param-connections-authentication-connection-settings
为Azure PostgreSQL连接配置TCP设置https://learn.microsoft.com/en-us/azure/postgresql/server-parameters/param-connections-authentication-tcp-settings
使用自定义服务器选项如azure_storage.blob_block_size_mbhttps://learn.microsoft.com/en-us/azure/postgresql/server-parameters/param-customized-options
Azure PostgreSQL上的开发者选项服务器参数https://learn.microsoft.com/en-us/azure/postgresql/server-parameters/param-developer-options
在Azure PostgreSQL上配置错误处理参数https://learn.microsoft.com/en-us/azure/postgresql/server-parameters/param-error-handling
Azure PostgreSQL上的文件位置服务器参数https://learn.microsoft.com/en-us/azure/postgresql/server-parameters/param-file-locations
Azure PostgreSQL上的智能调优服务器参数https://learn.microsoft.com/en-us/azure/postgresql/server-parameters/param-intelligent-tuning
Azure PostgreSQL上的锁管理服务器参数https://learn.microsoft.com/en-us/azure/postgresql/server-parameters/param-lock-management
Azure PostgreSQL上的指标相关服务器参数https://learn.microsoft.com/en-us/azure/postgresql/server-parameters/param-metrics
Azure PostgreSQL上的迁移相关服务器参数https://learn.microsoft.com/en-us/azure/postgresql/server-parameters/param-migration
在Azure PostgreSQL上配置PgBouncer参数与层级支持https://learn.microsoft.com/en-us/azure/postgresql/server-parameters/param-pgbouncer
Azure PostgreSQL上的预设选项服务器参数https://learn.microsoft.com/en-us/azure/postgresql/server-parameters/param-preset-options
Azure PostgreSQL上的进程标题服务器参数https://learn.microsoft.com/en-us/azure/postgresql/server-parameters/param-process-title
Azure PostgreSQL上的遗传查询优化器参数https://learn.microsoft.com/en-us/azure/postgresql/server-parameters/param-query-tuning-genetic-query-optimizer
调优规划器成本常数如effective_cache_sizehttps://learn.microsoft.com/en-us/azure/postgresql/server-parameters/param-query-tuning-planner-cost-constants
Azure PostgreSQL上的规划器方法配置参数https://learn.microsoft.com/en-us/azure/postgresql/server-parameters/param-query-tuning-planner-method-configuration
Azure PostgreSQL上查询调优的其他规划器选项https://learn.microsoft.com/en-us/azure/postgresql/server-parameters/param-query-tuning-planner-options
Azure PostgreSQL上的复制主服务器参数https://learn.microsoft.com/en-us/azure/postgresql/server-parameters/param-replication-master-server
了解主服务器复制参数的可用性https://learn.microsoft.com/en-us/azure/postgresql/server-parameters/param-replication-primary-server
Azure PostgreSQL上的备用服务器复制参数https://learn.microsoft.com/en-us/azure/postgresql/server-parameters/param-replication-standby-servers
Azure PostgreSQL上的订阅者复制参数https://learn.microsoft.com/en-us/azure/postgresql/server-parameters/param-replication-subscribers
通过报告与日志参数控制日志内容https://learn.microsoft.com/en-us/azure/postgresql/server-parameters/param-reporting-logging-what-log
在Azure中配置PostgreSQL日志计时参数https://learn.microsoft.com/en-us/azure/postgresql/server-parameters/param-reporting-logging-when-log
在Azure中配置PostgreSQL日志目标参数https://learn.microsoft.com/en-us/azure/postgresql/server-parameters/param-reporting-logging-where-log
调优Azure PostgreSQL的异步行为参数https://learn.microsoft.com/en-us/azure/postgresql/server-parameters/param-resource-usage-asynchronous-behavior
在Azure PostgreSQL上配置后台写入器参数https://learn.microsoft.com/en-us/azure/postgresql/server-parameters/param-resource-usage-background-writer
在Azure PostgreSQL上调整基于成本的清理延迟https://learn.microsoft.com/en-us/azure/postgresql/server-parameters/param-resource-usage-cost-based-vacuum-delay
为Azure PostgreSQL配置磁盘相关资源使用https://learn.microsoft.com/en-us/azure/postgresql/server-parameters/param-resource-usage-disk
为Azure PostgreSQL配置内核资源使用https://learn.microsoft.com/en-us/azure/postgresql/server-parameters/param-resource-usage-kernel-resources
为Azure PostgreSQL配置内存与大页https://learn.microsoft.com/en-us/azure/postgresql/server-parameters/param-resource-usage-memory
在Azure PostgreSQL上配置累积查询与索引统计https://learn.microsoft.com/en-us/azure/postgresql/server-parameters/param-statistics-cumulative-query-index-statistics
为Azure PostgreSQL配置监控统计参数https://learn.microsoft.com/en-us/azure/postgresql/server-parameters/param-statistics-monitoring
按版本了解查询与索引统计收集器参数https://learn.microsoft.com/en-us/azure/postgresql/server-parameters/param-statistics-query-index-statistics-collector
为Azure PostgreSQL设置其他客户端的兼容性参数https://learn.microsoft.com/en-us/azure/postgresql/server-parameters/param-version-platform-compatibility-platforms-clients
在Azure中配置与旧版PostgreSQL的兼容性https://learn.microsoft.com/en-us/azure/postgresql/server-parameters/param-version-platform-compatibility-postgresql-versions
按Azure PostgreSQL版本检查归档恢复参数的可用性https://learn.microsoft.com/en-us/azure/postgresql/server-parameters/param-write-ahead-log-archive-recovery
在Azure PostgreSQL上配置WAL归档参数https://learn.microsoft.com/en-us/azure/postgresql/server-parameters/param-write-ahead-log-archiving
调优Azure PostgreSQL的WAL检查点参数https://learn.microsoft.com/en-us/azure/postgresql/server-parameters/param-write-ahead-log-checkpoints
跨Azure PostgreSQL版本检查WAL恢复参数的可用性https://learn.microsoft.com/en-us/azure/postgresql/server-parameters/param-write-ahead-log-recovery
按版本检查WAL恢复目标参数的可用性https://learn.microsoft.com/en-us/azure/postgresql/server-parameters/param-write-ahead-log-recovery-target
在Azure PostgreSQL上配置WAL设置与缓冲区https://learn.microsoft.com/en-us/azure/postgresql/server-parameters/param-write-ahead-log-settings

Integrations & Coding Patterns

集成与编码模式

TopicURL
Use semantic operators from Azure AI extension in SQLhttps://learn.microsoft.com/en-us/azure/postgresql/azure-ai/generative-ai-azure-ai-semantic-operators
Invoke Azure Language services from PostgreSQLhttps://learn.microsoft.com/en-us/azure/postgresql/azure-ai/generative-ai-azure-cognitive
Call Azure Machine Learning models from PostgreSQLhttps://learn.microsoft.com/en-us/azure/postgresql/azure-ai/generative-ai-azure-machine-learning
Generate and store Azure OpenAI embeddings in PostgreSQLhttps://learn.microsoft.com/en-us/azure/postgresql/azure-ai/generative-ai-azure-openai
Use Azure AI extension and OpenAI embeddings in PostgreSQLhttps://learn.microsoft.com/en-us/azure/postgresql/azure-ai/generative-ai-azure-overview
Use LangChain with Azure PostgreSQL vector databasehttps://learn.microsoft.com/en-us/azure/postgresql/azure-ai/generative-ai-develop-with-langchain
Integrate Azure PostgreSQL with Microsoft Foundry via MCPhttps://learn.microsoft.com/en-us/azure/postgresql/azure-ai/generative-ai-foundry-integration
Integrate AI orchestration frameworks with Azure PostgreSQLhttps://learn.microsoft.com/en-us/azure/postgresql/azure-ai/generative-ai-frameworks
Connect to Azure PostgreSQL from C# applicationshttps://learn.microsoft.com/en-us/azure/postgresql/connectivity/connect-csharp
Access Azure PostgreSQL using Go database drivershttps://learn.microsoft.com/en-us/azure/postgresql/connectivity/connect-go
Use Java and JDBC with Azure PostgreSQLhttps://learn.microsoft.com/en-us/azure/postgresql/connectivity/connect-java
Connect PHP applications to Azure PostgreSQLhttps://learn.microsoft.com/en-us/azure/postgresql/connectivity/connect-php
Connect and query Azure PostgreSQL using Pythonhttps://learn.microsoft.com/en-us/azure/postgresql/connectivity/connect-python
Manage Azure PostgreSQL servers using .NET SDKhttps://learn.microsoft.com/en-us/azure/postgresql/developer/create-server-dotnet-sdk
Create and manage Azure PostgreSQL via Java SDKhttps://learn.microsoft.com/en-us/azure/postgresql/developer/create-server-java-sdk
Provision Azure PostgreSQL with Python SDKhttps://learn.microsoft.com/en-us/azure/postgresql/developer/create-server-python-sdk
Connect PostgreSQL databases via VS Code extensionhttps://learn.microsoft.com/en-us/azure/postgresql/developer/vs-code-extension/vs-code-connect
Use GitHub Copilot with VS Code PostgreSQL extensionhttps://learn.microsoft.com/en-us/azure/postgresql/developer/vs-code-extension/vs-code-github-copilot
Use Azure Storage extension examples for PostgreSQLhttps://learn.microsoft.com/en-us/azure/postgresql/extensions/quickstart-azure-storage-extension
Reference for Azure Storage extension functions in PostgreSQLhttps://learn.microsoft.com/en-us/azure/postgresql/extensions/reference-azure-storage-extension
Configure Azure Data Factory connector for PostgreSQLhttps://learn.microsoft.com/en-us/azure/postgresql/integration/how-to-connect-data-factory
Use Data Factory copy activity with PostgreSQLhttps://learn.microsoft.com/en-us/azure/postgresql/integration/how-to-data-factory-copy-activity-azure
Run PostgreSQL script activity in Data Factoryhttps://learn.microsoft.com/en-us/azure/postgresql/integration/how-to-data-factory-script-activity-azure
Migrate Oracle schemas to Azure PostgreSQL using Ora2Pghttps://learn.microsoft.com/en-us/azure/postgresql/migrate/how-to-migrate-oracle-ora2pg
Use pg_dump and pg_restore with Azure PostgreSQLhttps://learn.microsoft.com/en-us/azure/postgresql/migrate/how-to-migrate-using-dump-and-restore
Set up Azure CLI integration for PostgreSQL migration servicehttps://learn.microsoft.com/en-us/azure/postgresql/migrate/migration-service/how-to-setup-azure-cli-commands-postgresql
主题链接
在SQL中使用Azure AI扩展的语义运算符https://learn.microsoft.com/en-us/azure/postgresql/azure-ai/generative-ai-azure-ai-semantic-operators
从PostgreSQL调用Azure语言服务https://learn.microsoft.com/en-us/azure/postgresql/azure-ai/generative-ai-azure-cognitive
从PostgreSQL调用Azure机器学习模型https://learn.microsoft.com/en-us/azure/postgresql/azure-ai/generative-ai-azure-machine-learning
在PostgreSQL中生成并存储Azure OpenAI嵌入https://learn.microsoft.com/en-us/azure/postgresql/azure-ai/generative-ai-azure-openai
在PostgreSQL中使用Azure AI扩展与OpenAI嵌入https://learn.microsoft.com/en-us/azure/postgresql/azure-ai/generative-ai-azure-overview
将LangChain与Azure PostgreSQL向量数据库结合使用https://learn.microsoft.com/en-us/azure/postgresql/azure-ai/generative-ai-develop-with-langchain
通过MCP将Azure PostgreSQL与Microsoft Foundry集成https://learn.microsoft.com/en-us/azure/postgresql/azure-ai/generative-ai-foundry-integration
将AI编排框架与Azure PostgreSQL集成https://learn.microsoft.com/en-us/azure/postgresql/azure-ai/generative-ai-frameworks
从C#应用程序连接到Azure PostgreSQLhttps://learn.microsoft.com/en-us/azure/postgresql/connectivity/connect-csharp
使用Go数据库驱动访问Azure PostgreSQLhttps://learn.microsoft.com/en-us/azure/postgresql/connectivity/connect-go
将Java与JDBC和Azure PostgreSQL结合使用https://learn.microsoft.com/en-us/azure/postgresql/connectivity/connect-java
将PHP应用程序连接到Azure PostgreSQLhttps://learn.microsoft.com/en-us/azure/postgresql/connectivity/connect-php
使用Python连接并查询Azure PostgreSQLhttps://learn.microsoft.com/en-us/azure/postgresql/connectivity/connect-python
使用.NET SDK管理Azure PostgreSQL服务器https://learn.microsoft.com/en-us/azure/postgresql/developer/create-server-dotnet-sdk
使用Java SDK创建并管理Azure PostgreSQLhttps://learn.microsoft.com/en-us/azure/postgresql/developer/create-server-java-sdk
使用Python SDK部署Azure PostgreSQLhttps://learn.microsoft.com/en-us/azure/postgresql/developer/create-server-python-sdk
通过VS Code扩展连接PostgreSQL数据库https://learn.microsoft.com/en-us/azure/postgresql/developer/vs-code-extension/vs-code-connect
将GitHub Copilot与VS Code PostgreSQL扩展结合使用https://learn.microsoft.com/en-us/azure/postgresql/developer/vs-code-extension/vs-code-github-copilot
使用PostgreSQL的Azure Storage扩展示例https://learn.microsoft.com/en-us/azure/postgresql/extensions/quickstart-azure-storage-extension
PostgreSQL中Azure Storage扩展函数参考https://learn.microsoft.com/en-us/azure/postgresql/extensions/reference-azure-storage-extension
为PostgreSQL配置Azure Data Factory连接器https://learn.microsoft.com/en-us/azure/postgresql/integration/how-to-connect-data-factory
将Data Factory复制活动与PostgreSQL结合使用https://learn.microsoft.com/en-us/azure/postgresql/integration/how-to-data-factory-copy-activity-azure
在Data Factory中运行PostgreSQL脚本活动https://learn.microsoft.com/en-us/azure/postgresql/integration/how-to-data-factory-script-activity-azure
使用Ora2Pg将Oracle schema迁移到Azure PostgreSQLhttps://learn.microsoft.com/en-us/azure/postgresql/migrate/how-to-migrate-oracle-ora2pg
将pg_dump与pg_restore和Azure PostgreSQL结合使用https://learn.microsoft.com/en-us/azure/postgresql/migrate/how-to-migrate-using-dump-and-restore
为PostgreSQL迁移服务设置Azure CLI集成https://learn.microsoft.com/en-us/azure/postgresql/migrate/migration-service/how-to-setup-azure-cli-commands-postgresql

Deployment

部署

TopicURL
Deploy database updates via Azure Pipelines to Azure PostgreSQLhttps://learn.microsoft.com/en-us/azure/postgresql/configure-maintain/azure-pipelines-deploy-database-task
Use GitHub Actions to deploy changes to Azure PostgreSQLhttps://learn.microsoft.com/en-us/azure/postgresql/configure-maintain/how-to-deploy-github-action
Perform in-place major version upgrades on Azure PostgreSQLhttps://learn.microsoft.com/en-us/azure/postgresql/configure-maintain/how-to-perform-major-version-upgrade
Deploy Azure PostgreSQL flexible server using Bicephttps://learn.microsoft.com/en-us/azure/postgresql/developer/create-server-bicep
Deploy Django on AKS with Azure PostgreSQL backendhttps://learn.microsoft.com/en-us/azure/postgresql/developer/django-aks-database
Deploy Azure Web App and PostgreSQL in same VNethttps://learn.microsoft.com/en-us/azure/postgresql/developer/webapp-server-vnet
Understand PostgreSQL maintenance release rollout behaviorhttps://learn.microsoft.com/en-us/azure/postgresql/release-notes-maintenance/release-notes-maintenance-index
Restore PostgreSQL flexible server to a point in timehttps://learn.microsoft.com/en-us/azure/postgresql/samples/sample-point-in-time-restore
主题链接
通过Azure Pipelines将数据库更新部署到Azure PostgreSQLhttps://learn.microsoft.com/en-us/azure/postgresql/configure-maintain/azure-pipelines-deploy-database-task
使用GitHub Actions将更改部署到Azure PostgreSQLhttps://learn.microsoft.com/en-us/azure/postgresql/configure-maintain/how-to-deploy-github-action
在Azure PostgreSQL上执行原地大版本升级https://learn.microsoft.com/en-us/azure/postgresql/configure-maintain/how-to-perform-major-version-upgrade
使用Bicep部署Azure PostgreSQL灵活服务器https://learn.microsoft.com/en-us/azure/postgresql/developer/create-server-bicep
在AKS上部署Django并使用Azure PostgreSQL作为后端https://learn.microsoft.com/en-us/azure/postgresql/developer/django-aks-database
在同一VNet中部署Azure Web App与PostgreSQLhttps://learn.microsoft.com/en-us/azure/postgresql/developer/webapp-server-vnet
了解PostgreSQL维护版本发布行为https://learn.microsoft.com/en-us/azure/postgresql/release-notes-maintenance/release-notes-maintenance-index
将PostgreSQL灵活服务器恢复到指定时间点https://learn.microsoft.com/en-us/azure/postgresql/samples/sample-point-in-time-restore