Skip to content
LiveNew tools this week
Submit
AIMarketly
azure-database-postgresql logo

Azure Database for PostgreSQL Skill

azure-database-postgresql

Expert knowledge for Azure Database for PostgreSQL development including troubleshooting, best practices, decision making, architecture & design patterns, limits & quotas, security, configuration, integrations & coding patterns, and deployment. Use when using pgvector, read replicas, Private Link...

MicrosoftDocs/Agent-Skills0installs772stars

SKILL.md

Full skill instructions

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.

How to Use This Skill

IMPORTANT for Agent: Use the Category Index below to locate relevant sections. For categories with line ranges (e.g., L35-L120), use read_file with the specified lines. For categories with file links (e.g., [security.md](security.md)), use read_file on the linked reference file

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.

Category Index

CategoryLinesDescription
TroubleshootingL37-L63Diagnosing and fixing PostgreSQL issues on Azure: connectivity, TLS, HA, performance (CPU/​IOPS/​memory/​slow queries), autovacuum, extensions, migrations, CLI errors, and auth problems.
Best PracticesL64-L80Performance and migration best practices for Azure PostgreSQL: partitioning, pooling, pgvector, query store, bulk load, bloat cleanup, pg_dump/​restore, and Oracle-to-PostgreSQL conversion.
Decision MakingL81-L96Guidance on sizing and scaling compute/​storage, choosing deployment and PostgreSQL versions, planning upgrades, geo-replication, reserved capacity, and pre-migration checks.
Architecture & Design PatternsL97-L107Patterns for using Azure PostgreSQL (often with OpenAI) to build recommendation/​semantic search apps, microservices, multitenancy, real-time dashboards, and sharded/​elastic data architectures.
Limits & QuotasL108-L128Backup/​restore behavior, geo-restore and dropped server recovery, storage types/​limits and performance tuning, quotas and capacity limits, read replicas, and known migration limitations.
SecurityL129-L159Securing Azure Database for PostgreSQL: identity/​auth (Entra, managed identities, SCRAM), network (VNet, Private Link, firewall), TLS/​SSL, encryption, RBAC, auditing, and security policies/​compliance.
ConfigurationL160-L211Configuring Azure Database for PostgreSQL servers: parameters, extensions, HA, networking, logging/​monitoring, tuning (autovacuum, memory, WAL, connections), and scaling via portal, CLI, ARM/​Bicep.
Integrations & Coding PatternsL212-L239Patterns and code samples for integrating Azure PostgreSQL with AI services, SDKs, programming languages, VS Code, Data Factory, storage, and Oracle migrations.
DeploymentL240-L250CI/​CD deployment to Azure PostgreSQL, app integration (AKS/​Django, Web Apps + VNet), flexible server Bicep provisioning, major upgrades, network migration, and point-in-time restore.

Troubleshooting

TopicURL
Run pre-upgrade validation checks for Azure PostgreSQLhttps://learn.microsoft.com/en-us/azure/postgresql/configure-maintain/how-to-run-upgrade-validation-checks
Troubleshoot PostgreSQL extension management errors on Azurehttps://learn.microsoft.com/en-us/azure/postgresql/extensions/errors-extensions
Interpret HA health states for Azure PostgreSQL servershttps://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
Use application conversion reports for validationhttps://learn.microsoft.com/en-us/azure/postgresql/migrate/oracle-conversions-application/app-conversions-reports
Interpret Oracle-to-PostgreSQL schema conversion reportshttps://learn.microsoft.com/en-us/azure/postgresql/migrate/oracle-conversions-schema/schema-conversions-reports
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
Troubleshoot and tune autovacuum on PostgreSQL elastic clustershttps://learn.microsoft.com/en-us/azure/postgresql/troubleshoot/how-to-autovacuum-tuning-elastic-clusters
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
Troubleshoot high memory usage in Azure 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
Diagnose slow-running queries on PostgreSQL elastic clustershttps://learn.microsoft.com/en-us/azure/postgresql/troubleshoot/how-to-identify-slow-queries-elastic-clusters
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

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
Optimize pgvector performance on Azure PostgreSQLhttps://learn.microsoft.com/en-us/azure/postgresql/extensions/how-to-optimize-performance-pgvector
Apply best practices for migrating to Azure PostgreSQLhttps://learn.microsoft.com/en-us/azure/postgresql/migrate/migration-service/best-practices-migration-service-postgresql
Follow best practices for Oracle app conversionhttps://learn.microsoft.com/en-us/azure/postgresql/migrate/oracle-conversions-application/app-conversions-best-practices
Apply best practices for Oracle schema conversionhttps://learn.microsoft.com/en-us/azure/postgresql/migrate/oracle-conversions-schema/schema-conversions-best-practices
Apply Oracle-to-Azure PostgreSQL migration best practiceshttps://learn.microsoft.com/en-us/azure/postgresql/migrate/oracle-migration/best-practices-oracle-to-postgresql
Apply query store best practices in PostgreSQLhttps://learn.microsoft.com/en-us/azure/postgresql/monitor/concepts-query-store-best-practices
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

Decision Making

TopicURL
Choose compute tiers for Azure PostgreSQL flexible serverhttps://learn.microsoft.com/en-us/azure/postgresql/compute-storage/concepts-compute
Plan Azure PostgreSQL compute and storage for performancehttps://learn.microsoft.com/en-us/azure/postgresql/compute-storage/concepts-optimal-performance
Plan and execute major version upgrades for Azure PostgreSQLhttps://learn.microsoft.com/en-us/azure/postgresql/configure-maintain/concepts-major-version-upgrade
Decide on reserved capacity purchases for Azure PostgreSQLhttps://learn.microsoft.com/en-us/azure/postgresql/configure-maintain/concepts-reserved-pricing
Select supported PostgreSQL versions on Azure Flexible Serverhttps://learn.microsoft.com/en-us/azure/postgresql/configure-maintain/concepts-supported-versions
Apply Azure Database for PostgreSQL version policyhttps://learn.microsoft.com/en-us/azure/postgresql/configure-maintain/concepts-version-policy
Use extended support for Azure PostgreSQL versionshttps://learn.microsoft.com/en-us/azure/postgresql/configure-maintain/extended-support
Select Azure PostgreSQL hosting and deployment optionhttps://learn.microsoft.com/en-us/azure/postgresql/configure-maintain/overview-postgres-choose-server-options
Use premigration validations for Azure PostgreSQL migrationshttps://learn.microsoft.com/en-us/azure/postgresql/migrate/migration-service/concepts-premigration-migration-service
Use pre-migration checklist for Oracle to Azure PostgreSQLhttps://learn.microsoft.com/en-us/azure/postgresql/migrate/oracle-migration/best-practices-oracle-to-postgresql-checklist
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

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

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
Migrate PostgreSQL flexible server SSD to SSDv2 with IOPS limitshttps://learn.microsoft.com/en-us/azure/postgresql/compute-storage/concepts-storage-migrate-ssd-to-ssd-v2
Use Premium SSD storage with Azure PostgreSQL flexible serverhttps://learn.microsoft.com/en-us/azure/postgresql/compute-storage/concepts-storage-premium-ssd
Tune Premium SSD v2 storage performance limitshttps://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 limits for Azure PostgreSQLhttps://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
Review limitations of Oracle application conversionhttps://learn.microsoft.com/en-us/azure/postgresql/migrate/oracle-conversions-application/app-conversions-limitations
Understand limitations of Oracle schema conversion toolhttps://learn.microsoft.com/en-us/azure/postgresql/migrate/oracle-conversions-schema/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

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
Configure authentication parameters in Azure PostgreSQLhttps://learn.microsoft.com/en-us/azure/postgresql/parameters/parameters-connections-authentication-authentication
Manage SSL connection parameters in Azure PostgreSQLhttps://learn.microsoft.com/en-us/azure/postgresql/parameters/parameters-connections-authentication-ssl
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 role-based access for Azure Database for 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 connectivity 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 for Azure PostgreSQL Flexible Serverhttps://learn.microsoft.com/en-us/azure/postgresql/security/security-data-encryption
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
Secure Azure Database for PostgreSQL flexible servershttps://learn.microsoft.com/en-us/azure/postgresql/security/security-overview
Configure TLS requirements for Azure PostgreSQLhttps://learn.microsoft.com/en-us/azure/postgresql/security/security-tls
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

Configuration

TopicURL
Apply server configuration concepts for Azure PostgreSQL flexible serverhttps://learn.microsoft.com/en-us/azure/postgresql/configure-maintain/concepts-servers
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
Check available PostgreSQL extensions on Azure Flexible Serverhttps://learn.microsoft.com/en-us/azure/postgresql/extensions/concepts-extensions-by-engine
Allow and manage PostgreSQL extensions on Azure Flexible Serverhttps://learn.microsoft.com/en-us/azure/postgresql/extensions/how-to-allow-extensions
Configure Azure Storage extension for PostgreSQL flexible serverhttps://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 on Azure PostgreSQL Flexible Serverhttps://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 parameters for Azure PostgreSQLhttps://learn.microsoft.com/en-us/azure/postgresql/migrate/migration-service/concepts-migration-parameters
Configure networking scenarios for PostgreSQL migration servicehttps://learn.microsoft.com/en-us/azure/postgresql/migrate/migration-service/how-to-network-setup-migration-service
Review and manage schema conversion output artifactshttps://learn.microsoft.com/en-us/azure/postgresql/migrate/oracle-conversions-schema/schema-conversions-review-tasks-artifacts
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 in Azure PostgreSQLhttps://learn.microsoft.com/en-us/azure/postgresql/monitor/how-to-enable-intelligent-performance-portal
Understand configurable parameters in Azure PostgreSQLhttps://learn.microsoft.com/en-us/azure/postgresql/parameters/concepts-parameters
Reset all Azure PostgreSQL parameters to defaultshttps://learn.microsoft.com/en-us/azure/postgresql/parameters/how-to-parameters-revert-all-default
Revert a single Azure PostgreSQL parameter to defaulthttps://learn.microsoft.com/en-us/azure/postgresql/parameters/how-to-parameters-revert-one-default
Set Azure PostgreSQL flexible server parametershttps://learn.microsoft.com/en-us/azure/postgresql/parameters/how-to-parameters-set-value
Configure autonomous tuning parameters in Azure PostgreSQLhttps://learn.microsoft.com/en-us/azure/postgresql/parameters/parameters-autonomous-tuning
Tune autovacuum parameters in Azure PostgreSQLhttps://learn.microsoft.com/en-us/azure/postgresql/parameters/parameters-autovacuum
Configure other client default parameters in Azure PostgreSQLhttps://learn.microsoft.com/en-us/azure/postgresql/parameters/parameters-client-connection-defaults-defaults
Set locale and formatting defaults in Azure PostgreSQLhttps://learn.microsoft.com/en-us/azure/postgresql/parameters/parameters-client-connection-defaults-locale-formatting
Configure shared library preloading in Azure PostgreSQLhttps://learn.microsoft.com/en-us/azure/postgresql/parameters/parameters-client-connection-defaults-shared-library-preloading
Control client statement behavior in Azure PostgreSQLhttps://learn.microsoft.com/en-us/azure/postgresql/parameters/parameters-client-connection-defaults-statement-behavior
Configure connection settings and max_connections in Azure PostgreSQLhttps://learn.microsoft.com/en-us/azure/postgresql/parameters/parameters-connections-authentication-connection-settings
Tune TCP connection settings in Azure PostgreSQLhttps://learn.microsoft.com/en-us/azure/postgresql/parameters/parameters-connections-authentication-tcp-settings
Configure customized PostgreSQL options on Azure flexible serverhttps://learn.microsoft.com/en-us/azure/postgresql/parameters/parameters-customized-options
Configure PgBouncer parameters on Azure PostgreSQL flexible serverhttps://learn.microsoft.com/en-us/azure/postgresql/parameters/parameters-pgbouncer
Tune planner cost constants on Azure PostgreSQL flexible serverhttps://learn.microsoft.com/en-us/azure/postgresql/parameters/parameters-query-tuning-planner-cost-constants
Configure replication sending server slots on Azure PostgreSQLhttps://learn.microsoft.com/en-us/azure/postgresql/parameters/parameters-replication-sending-servers
Configure memory and huge pages for Azure PostgreSQLhttps://learn.microsoft.com/en-us/azure/postgresql/parameters/parameters-resource-usage-memory
Configure WAL checkpoint size on Azure PostgreSQL flexible serverhttps://learn.microsoft.com/en-us/azure/postgresql/parameters/parameters-write-ahead-log-checkpoints
Configure WAL settings parameters for Azure PostgreSQLhttps://learn.microsoft.com/en-us/azure/postgresql/parameters/parameters-write-ahead-log-settings
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

Integrations & Coding Patterns

TopicURL
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
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 to Azure Database for PostgreSQL with 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 Azure Storage extension examples for PostgreSQLhttps://learn.microsoft.com/en-us/azure/postgresql/extensions/quickstart-azure-storage-extension
Use Azure Storage extension function reference for 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
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
Convert Oracle application code to Azure PostgreSQLhttps://learn.microsoft.com/en-us/azure/postgresql/migrate/oracle-conversions-application/app-conversions-tutorial
Run Oracle schema conversion with VS Code PostgreSQLhttps://learn.microsoft.com/en-us/azure/postgresql/migrate/oracle-conversions-schema/schema-conversions-tutorial
Migrate Oracle schemas to Azure PostgreSQL with Ora2Pghttps://learn.microsoft.com/en-us/azure/postgresql/migrate/oracle-migration/how-to-migrate-oracle-ora2pg

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
Migrate Azure PostgreSQL from VNet injection to private endpointshttps://learn.microsoft.com/en-us/azure/postgresql/network/how-to-migrate-vnet-private-endpoint-capable-server
Restore PostgreSQL flexible server to a point in timehttps://learn.microsoft.com/en-us/azure/postgresql/samples/sample-point-in-time-restore