azure-database-postgresql
Provides expert guidance for Azure Database for PostgreSQL, covering troubleshooting, best practices, security, and deployment strategies.
Install this skill
Security score
The azure-database-postgresql skill was audited on Mar 7, 2026 and we found 211 security issues across 1 threat category. Review the findings below before installing.
Categories Tested
Security Issues
External URL reference
| 40 | | Troubleshoot PostgreSQL extension management errors on Azure | https://learn.microsoft.com/en-us/azure/postgresql/extensions/errors-extensions | |
External URL reference
| 41 | | Monitor and troubleshoot HA health for Azure PostgreSQL | https://learn.microsoft.com/en-us/azure/postgresql/high-availability/how-to-monitor-high-availability | |
External URL reference
| 42 | | Resolve premigration validation error codes for PostgreSQL migration | https://learn.microsoft.com/en-us/azure/postgresql/migrate/migration-service/troubleshoot-error-codes | |
External URL reference
| 43 | | Interpret and apply autonomous tuning recommendations | https://learn.microsoft.com/en-us/azure/postgresql/monitor/how-to-get-apply-recommendations-from-autonomous-tuning | |
External URL reference
| 44 | | Troubleshoot TLS connection failures in Azure PostgreSQL | https://learn.microsoft.com/en-us/azure/postgresql/security/security-tls-troubleshoot | |
External URL reference
| 45 | | Diagnose transient connectivity errors in Azure PostgreSQL | https://learn.microsoft.com/en-us/azure/postgresql/troubleshoot/concepts-connectivity | |
External URL reference
| 46 | | Monitor and tune autovacuum in Azure PostgreSQL | https://learn.microsoft.com/en-us/azure/postgresql/troubleshoot/how-to-autovacuum-tuning | |
External URL reference
| 47 | | Diagnose and mitigate high CPU in PostgreSQL | https://learn.microsoft.com/en-us/azure/postgresql/troubleshoot/how-to-high-cpu-utilization | |
External URL reference
| 48 | | Troubleshoot high CPU in PostgreSQL elastic clusters | https://learn.microsoft.com/en-us/azure/postgresql/troubleshoot/how-to-high-cpu-utilization-elastic-clusters | |
External URL reference
| 49 | | Investigate and reduce high IOPS in PostgreSQL | https://learn.microsoft.com/en-us/azure/postgresql/troubleshoot/how-to-high-io-utilization | |
External URL reference
| 50 | | Diagnose and fix high memory usage in PostgreSQL | https://learn.microsoft.com/en-us/azure/postgresql/troubleshoot/how-to-high-memory-utilization | |
External URL reference
| 51 | | Diagnose slow queries on Azure PostgreSQL flexible server | https://learn.microsoft.com/en-us/azure/postgresql/troubleshoot/how-to-identify-slow-queries | |
External URL reference
| 52 | | Resolve capacity errors when deploying or scaling Azure PostgreSQL | https://learn.microsoft.com/en-us/azure/postgresql/troubleshoot/how-to-resolve-capacity-errors | |
External URL reference
| 53 | | Troubleshoot Azure CLI errors for PostgreSQL | https://learn.microsoft.com/en-us/azure/postgresql/troubleshoot/how-to-troubleshoot-cli-errors | |
External URL reference
| 54 | | Troubleshoot connection issues to Azure PostgreSQL | https://learn.microsoft.com/en-us/azure/postgresql/troubleshoot/how-to-troubleshoot-common-connection-issues | |
External URL reference
| 55 | | Troubleshoot Azure Storage extension errors in PostgreSQL | https://learn.microsoft.com/en-us/azure/postgresql/troubleshoot/troubleshoot-azure-storage-extension | |
External URL reference
| 56 | | Resolve read replica conflict with recovery errors | https://learn.microsoft.com/en-us/azure/postgresql/troubleshoot/troubleshoot-canceling-statement-due-to-conflict-with-recovery | |
External URL reference
| 57 | | Fix password authentication failed errors in PostgreSQL | https://learn.microsoft.com/en-us/azure/postgresql/troubleshoot/troubleshoot-password-authentication-failed-for-user | |
External URL reference
| 62 | | Optimize Apache AGE graph query performance on Azure | https://learn.microsoft.com/en-us/azure/postgresql/azure-ai/generative-ai-age-performance | |
External URL reference
| 63 | | Use pg_partman to partition large tables on Azure | https://learn.microsoft.com/en-us/azure/postgresql/configure-maintain/how-to-use-pg-partman | |
External URL reference
| 64 | | Apply connection pooling best practices for Azure PostgreSQL | https://learn.microsoft.com/en-us/azure/postgresql/connectivity/concepts-connection-pooling-best-practices | |
External URL reference
| 65 | | Apply Azure-specific considerations for PostgreSQL extensions | https://learn.microsoft.com/en-us/azure/postgresql/extensions/concepts-extensions-considerations | |
External URL reference
| 66 | | Optimize pgvector performance on Azure PostgreSQL | https://learn.microsoft.com/en-us/azure/postgresql/extensions/how-to-optimize-performance-pgvector | |
External URL reference
| 67 | | Use best practices for Oracle-to-Azure PostgreSQL migrations | https://learn.microsoft.com/en-us/azure/postgresql/migrate/best-practices-oracle-to-postgresql | |
External URL reference
| 68 | | Apply best practices for migrating to Azure PostgreSQL | https://learn.microsoft.com/en-us/azure/postgresql/migrate/migration-service/best-practices-migration-service-postgresql | |
External URL reference
| 69 | | Apply best practices for Oracle-to-PostgreSQL schema conversion | https://learn.microsoft.com/en-us/azure/postgresql/migrate/oracle-schema-conversions/schema-conversions-best-practices | |
External URL reference
| 70 | | Apply query store best practices in PostgreSQL | https://learn.microsoft.com/en-us/azure/postgresql/monitor/concepts-query-store-best-practices | |
External URL reference
| 71 | | Apply security best practices to Azure PostgreSQL | https://learn.microsoft.com/en-us/azure/postgresql/security/security-overview | |
External URL reference
| 72 | | Bulk load data into Azure PostgreSQL flexible server | https://learn.microsoft.com/en-us/azure/postgresql/troubleshoot/how-to-bulk-load-data | |
External URL reference
| 73 | | Optimize pg_stat_statements query stats on Azure PostgreSQL | https://learn.microsoft.com/en-us/azure/postgresql/troubleshoot/how-to-optimize-query-stats-collection | |
External URL reference
| 74 | | Use pg_repack to remove bloat on Azure PostgreSQL | https://learn.microsoft.com/en-us/azure/postgresql/troubleshoot/how-to-perform-fullvacuum-pg-repack | |
External URL reference
| 75 | | Tune pg_dump and pg_restore for Azure PostgreSQL | https://learn.microsoft.com/en-us/azure/postgresql/troubleshoot/how-to-pgdump-restore | |
External URL reference
| 80 | | Plan geo-disaster recovery for Azure PostgreSQL flexible server | https://learn.microsoft.com/en-us/azure/postgresql/backup-restore/concepts-geo-disaster-recovery | |
External URL reference
| 81 | | Choose compute tiers for Azure PostgreSQL flexible server | https://learn.microsoft.com/en-us/azure/postgresql/compute-storage/concepts-compute | |
External URL reference
| 82 | | Decide on reserved capacity purchases for Azure PostgreSQL | https://learn.microsoft.com/en-us/azure/postgresql/configure-maintain/concepts-reserved-pricing | |
External URL reference
| 83 | | Decide on extended support for Azure PostgreSQL versions | https://learn.microsoft.com/en-us/azure/postgresql/configure-maintain/extended-support | |
External URL reference
| 84 | | Choose Azure PostgreSQL hosting and deployment options | https://learn.microsoft.com/en-us/azure/postgresql/configure-maintain/overview-postgres-choose-server-options | |
External URL reference
| 85 | | Use pre-migration checklist to size Azure PostgreSQL targets | https://learn.microsoft.com/en-us/azure/postgresql/migrate/best-practices-oracle-to-postgresql-checklist | |
External URL reference
| 86 | | Use premigration validations for Azure PostgreSQL migrations | https://learn.microsoft.com/en-us/azure/postgresql/migrate/migration-service/concepts-premigration-migration-service | |
External URL reference
| 87 | | Plan geo-replication for Azure PostgreSQL flexible server | https://learn.microsoft.com/en-us/azure/postgresql/read-replica/concepts-read-replicas-geo | |
External URL reference
| 88 | | Scale compute tiers for Azure PostgreSQL flexible server | https://learn.microsoft.com/en-us/azure/postgresql/scale/how-to-scale-compute | |
External URL reference
| 93 | | Build recommendation systems with Azure PostgreSQL and OpenAI | https://learn.microsoft.com/en-us/azure/postgresql/azure-ai/generative-ai-recommendation-system | |
External URL reference
| 94 | | Implement semantic search with Azure PostgreSQL and OpenAI | https://learn.microsoft.com/en-us/azure/postgresql/azure-ai/generative-ai-semantic-search | |
External URL reference
| 95 | | Design microservices data architecture with PostgreSQL elastic clusters | https://learn.microsoft.com/en-us/azure/postgresql/configure-maintain/tutorial-microservices | |
External URL reference
| 96 | | Design multitenant apps with Azure PostgreSQL elastic clusters | https://learn.microsoft.com/en-us/azure/postgresql/configure-maintain/tutorial-multitenant-database | |
External URL reference
| 97 | | Design real-time dashboards with PostgreSQL elastic clusters | https://learn.microsoft.com/en-us/azure/postgresql/configure-maintain/tutorial-real-time-dashboard | |
External URL reference
| 98 | | Choose sharding models for Azure PostgreSQL elastic clusters | https://learn.microsoft.com/en-us/azure/postgresql/elastic-clusters/concepts-elastic-clusters-sharding-models | |
External URL reference
| 99 | | Select table types in Azure PostgreSQL elastic clusters | https://learn.microsoft.com/en-us/azure/postgresql/elastic-clusters/concepts-elastic-clusters-table-types | |
External URL reference
| 104 | | Understand backup and restore behavior for Azure PostgreSQL | https://learn.microsoft.com/en-us/azure/postgresql/backup-restore/concepts-backup-restore | |
External URL reference
| 105 | | Recover dropped Azure PostgreSQL flexible servers from backups | https://learn.microsoft.com/en-us/azure/postgresql/backup-restore/how-to-restore-dropped-server | |
External URL reference
| 106 | | Perform geo-restore to paired regions for Azure PostgreSQL | https://learn.microsoft.com/en-us/azure/postgresql/backup-restore/how-to-restore-paired-region | |
External URL reference
| 107 | | Understand storage limits for Azure PostgreSQL flexible server | https://learn.microsoft.com/en-us/azure/postgresql/compute-storage/concepts-storage | |
External URL reference
| 108 | | Use Premium SSD storage with Azure PostgreSQL flexible server | https://learn.microsoft.com/en-us/azure/postgresql/compute-storage/concepts-storage-premium-ssd | |
External URL reference
| 109 | | Configure Premium SSD v2 performance for Azure PostgreSQL | https://learn.microsoft.com/en-us/azure/postgresql/compute-storage/concepts-storage-premium-ssd-v2 | |
External URL reference
| 110 | | Review capacity and functional limits for Azure PostgreSQL | https://learn.microsoft.com/en-us/azure/postgresql/configure-maintain/concepts-limits | |
External URL reference
| 111 | | Request quota increases for Azure PostgreSQL flexible server | https://learn.microsoft.com/en-us/azure/postgresql/configure-maintain/how-to-request-quota-increase | |
External URL reference
| 112 | | Review elastic cluster capacity and functional limits | https://learn.microsoft.com/en-us/azure/postgresql/elastic-clusters/concepts-elastic-clusters-limitations | |
External URL reference
| 113 | | Understand max client connections in PostgreSQL elastic clusters | https://learn.microsoft.com/en-us/azure/postgresql/elastic-clusters/how-to-network-elastic-clusters-default-maximum-connections | |
External URL reference
| 114 | | Review known issues and limitations of PostgreSQL migration service | https://learn.microsoft.com/en-us/azure/postgresql/migrate/migration-service/concepts-known-issues-migration-service | |
External URL reference
| 115 | | Understand limitations of Oracle-to-PostgreSQL schema conversion tool | https://learn.microsoft.com/en-us/azure/postgresql/migrate/oracle-schema-conversions/schema-conversions-limitations | |
External URL reference
| 116 | | Use read replicas in Azure PostgreSQL flexible server | https://learn.microsoft.com/en-us/azure/postgresql/read-replica/concepts-read-replicas | |
External URL reference
| 117 | | Configure storage autogrow thresholds for Azure PostgreSQL | https://learn.microsoft.com/en-us/azure/postgresql/scale/how-to-auto-grow-storage | |
External URL reference
| 118 | | Adjust storage performance for Azure PostgreSQL flexible server | https://learn.microsoft.com/en-us/azure/postgresql/scale/how-to-scale-storage-performance | |
External URL reference
| 119 | | Configure max_replication_slots and slot usage on Azure PostgreSQL | https://learn.microsoft.com/en-us/azure/postgresql/server-parameters/param-replication-sending-servers | |
External URL reference
| 124 | | Enable managed identity for Azure AI extension in PostgreSQL | https://learn.microsoft.com/en-us/azure/postgresql/azure-ai/generative-ai-enable-managed-identity-azure-ai | |
External URL reference
| 125 | | Enable deletion protection for Azure PostgreSQL flexible server | https://learn.microsoft.com/en-us/azure/postgresql/configure-maintain/how-to-enable-deletion-protection | |
External URL reference
| 126 | | Configure private access and VNet for Azure PostgreSQL | https://learn.microsoft.com/en-us/azure/postgresql/connectivity/quickstart-create-connect-server-vnet | |
External URL reference
| 127 | | Secure Data Factory–PostgreSQL connectivity via Private Link | https://learn.microsoft.com/en-us/azure/postgresql/integration/how-to-connect-data-factory-private-endpoint | |
External URL reference
| 128 | | Assign required permissions to run PostgreSQL migrations | https://learn.microsoft.com/en-us/azure/postgresql/migrate/migration-service/concepts-required-user-permissions | |
External URL reference
| 129 | | Create PostgreSQL server and firewall via CLI | https://learn.microsoft.com/en-us/azure/postgresql/samples/sample-create-server-and-firewall-rule | |
External URL reference
| 130 | | Create PostgreSQL VNet rule with Azure CLI | https://learn.microsoft.com/en-us/azure/postgresql/samples/sample-create-server-with-vnet-rule | |
External URL reference
| 131 | | Configure access control and roles for Azure PostgreSQL | https://learn.microsoft.com/en-us/azure/postgresql/security/security-access-control | |
External URL reference
| 132 | | Configure pgaudit-based audit logging in Azure PostgreSQL | https://learn.microsoft.com/en-us/azure/postgresql/security/security-audit | |
External URL reference
| 133 | | Apply Azure Policy to secure Azure PostgreSQL | https://learn.microsoft.com/en-us/azure/postgresql/security/security-azure-policy | |
External URL reference
| 134 | | Review security and compliance certifications for Azure PostgreSQL | https://learn.microsoft.com/en-us/azure/postgresql/security/security-compliance | |
External URL reference
| 135 | | Configure data encryption keys for Azure PostgreSQL | https://learn.microsoft.com/en-us/azure/postgresql/security/security-configure-data-encryption | |
External URL reference
| 136 | | Enable system-assigned managed identity for Azure PostgreSQL | https://learn.microsoft.com/en-us/azure/postgresql/security/security-configure-managed-identities-system-assigned | |
External URL reference
| 137 | | Configure user-assigned managed identities for Azure PostgreSQL | https://learn.microsoft.com/en-us/azure/postgresql/security/security-configure-managed-identities-user-assigned | |
External URL reference
| 138 | | Configure SCRAM authentication for Azure PostgreSQL | https://learn.microsoft.com/en-us/azure/postgresql/security/security-connect-scram | |
External URL reference
| 139 | | Connect to Azure PostgreSQL using managed identities | https://learn.microsoft.com/en-us/azure/postgresql/security/security-connect-with-managed-identity | |
External URL reference
| 140 | | Understand data encryption at rest in Azure PostgreSQL | https://learn.microsoft.com/en-us/azure/postgresql/security/security-data-encryption | |
External URL reference
| 141 | | Use Defender for Cloud with Azure PostgreSQL | https://learn.microsoft.com/en-us/azure/postgresql/security/security-defender-for-cloud | |
External URL reference
| 142 | | Configure Microsoft Entra authentication for Azure PostgreSQL | https://learn.microsoft.com/en-us/azure/postgresql/security/security-entra-configure | |
External URL reference
| 143 | | Configure firewall rules for Azure PostgreSQL public access | https://learn.microsoft.com/en-us/azure/postgresql/security/security-firewall-rules | |
External URL reference
| 144 | | Manage PostgreSQL database users on Azure flexible server | https://learn.microsoft.com/en-us/azure/postgresql/security/security-manage-database-users | |
External URL reference
| 145 | | Use managed identities with Azure PostgreSQL securely | https://learn.microsoft.com/en-us/azure/postgresql/security/security-managed-identity-overview | |
External URL reference
| 146 | | Configure TLS/SSL connections to Azure PostgreSQL | https://learn.microsoft.com/en-us/azure/postgresql/security/security-tls-how-to-connect | |
External URL reference
| 147 | | Update Java client certificates for Azure PostgreSQL TLS | https://learn.microsoft.com/en-us/azure/postgresql/security/security-update-trusted-root-java | |
External URL reference
| 148 | | Configure authentication parameters on Azure PostgreSQL | https://learn.microsoft.com/en-us/azure/postgresql/server-parameters/param-connections-authentication-authentication | |
External URL reference
| 149 | | Manage SSL connection parameters on Azure PostgreSQL | https://learn.microsoft.com/en-us/azure/postgresql/server-parameters/param-connections-authentication-ssl | |
External URL reference
| 150 | | Configure TLS server parameters for Azure PostgreSQL | https://learn.microsoft.com/en-us/azure/postgresql/server-parameters/param-tls | |
External URL reference
| 155 | | Configure and plan scheduled maintenance for Azure PostgreSQL | https://learn.microsoft.com/en-us/azure/postgresql/configure-maintain/concepts-maintenance | |
External URL reference
| 156 | | Understand major version upgrade behavior for Azure PostgreSQL | https://learn.microsoft.com/en-us/azure/postgresql/configure-maintain/concepts-major-version-upgrade | |
External URL reference
| 157 | | Apply server configuration concepts for Azure PostgreSQL flexible server | https://learn.microsoft.com/en-us/azure/postgresql/configure-maintain/concepts-servers | |
External URL reference
| 158 | | Check supported PostgreSQL versions on Azure flexible server | https://learn.microsoft.com/en-us/azure/postgresql/configure-maintain/concepts-supported-versions | |
External URL reference
| 159 | | Schedule maintenance windows for Azure PostgreSQL flexible server | https://learn.microsoft.com/en-us/azure/postgresql/configure-maintain/how-to-configure-scheduled-maintenance | |
External URL reference
| 160 | | Deploy PostgreSQL elastic clusters using ARM templates | https://learn.microsoft.com/en-us/azure/postgresql/elastic-clusters/quickstart-create-elastic-cluster-arm-template | |
External URL reference
| 161 | | Deploy PostgreSQL elastic clusters using Bicep templates | https://learn.microsoft.com/en-us/azure/postgresql/elastic-clusters/quickstart-create-elastic-cluster-bicep | |
External URL reference
| 162 | | Configure retired azure_local_ai extension for in-database embeddings | https://learn.microsoft.com/en-us/azure/postgresql/extensions/azure-local-ai | |
External URL reference
| 163 | | Allow and allowlist PostgreSQL extensions on Azure | https://learn.microsoft.com/en-us/azure/postgresql/extensions/how-to-allow-extensions | |
External URL reference
| 164 | | Configure Azure Storage extension for PostgreSQL data import/export | https://learn.microsoft.com/en-us/azure/postgresql/extensions/how-to-configure-azure-storage-extension | |
External URL reference
| 165 | | Create PostgreSQL extensions on Azure flexible server | https://learn.microsoft.com/en-us/azure/postgresql/extensions/how-to-create-extensions | |
External URL reference
| 166 | | Drop PostgreSQL extensions on Azure flexible server | https://learn.microsoft.com/en-us/azure/postgresql/extensions/how-to-drop-extensions | |
External URL reference
| 167 | | Configure shared_preload_libraries for Azure PostgreSQL | https://learn.microsoft.com/en-us/azure/postgresql/extensions/how-to-load-libraries | |
External URL reference
| 168 | | Update PostgreSQL extensions on Azure flexible server | https://learn.microsoft.com/en-us/azure/postgresql/extensions/how-to-update-extensions | |
External URL reference
| 169 | | Configure and use DiskANN vector indexing in PostgreSQL | https://learn.microsoft.com/en-us/azure/postgresql/extensions/how-to-use-pgdiskann | |
External URL reference
| 170 | | Enable and use pgvector for vector search in PostgreSQL | https://learn.microsoft.com/en-us/azure/postgresql/extensions/how-to-use-pgvector | |
External URL reference
| 171 | | View installed PostgreSQL extensions and versions on Azure | https://learn.microsoft.com/en-us/azure/postgresql/extensions/how-to-view-installed-extensions | |
External URL reference
| 172 | | Configure high availability for Azure PostgreSQL flexible server | https://learn.microsoft.com/en-us/azure/postgresql/high-availability/how-to-configure-high-availability | |
External URL reference
| 173 | | Configure migration server parameters for Azure PostgreSQL | https://learn.microsoft.com/en-us/azure/postgresql/migrate/migration-service/concepts-migration-server-parameters | |
External URL reference
| 174 | | Configure networking scenarios for PostgreSQL migration service | https://learn.microsoft.com/en-us/azure/postgresql/migrate/migration-service/how-to-network-setup-migration-service | |
External URL reference
| 175 | | Configure and access server logs in Azure PostgreSQL | https://learn.microsoft.com/en-us/azure/postgresql/monitor/concepts-logging | |
External URL reference
| 176 | | Configure Azure Monitor workbooks for PostgreSQL | https://learn.microsoft.com/en-us/azure/postgresql/monitor/concepts-workbooks | |
External URL reference
| 177 | | Set up metric alerts for PostgreSQL in Azure | https://learn.microsoft.com/en-us/azure/postgresql/monitor/how-to-alert-on-metrics | |
External URL reference
| 178 | | Configure and access PostgreSQL diagnostic logs | https://learn.microsoft.com/en-us/azure/postgresql/monitor/how-to-configure-and-access-logs | |
External URL reference
| 179 | | Configure autonomous tuning parameters for PostgreSQL | https://learn.microsoft.com/en-us/azure/postgresql/monitor/how-to-configure-autonomous-tuning | |
External URL reference
| 180 | | Configure and download PostgreSQL and upgrade logs | https://learn.microsoft.com/en-us/azure/postgresql/monitor/how-to-configure-server-logs | |
External URL reference
| 181 | | Manage intelligent tuning settings with Azure CLI | https://learn.microsoft.com/en-us/azure/postgresql/monitor/how-to-enable-intelligent-performance-cli | |
External URL reference
| 182 | | Configure intelligent tuning via Azure portal | https://learn.microsoft.com/en-us/azure/postgresql/monitor/how-to-enable-intelligent-performance-portal | |
External URL reference
| 183 | | List and change PostgreSQL server configuration via CLI | https://learn.microsoft.com/en-us/azure/postgresql/samples/sample-change-server-configuration | |
External URL reference
| 184 | | Scale PostgreSQL server compute and storage via CLI | https://learn.microsoft.com/en-us/azure/postgresql/samples/sample-scale-server-up-or-down | |
External URL reference
| 185 | | Enable and download PostgreSQL server logs via CLI | https://learn.microsoft.com/en-us/azure/postgresql/samples/sample-server-logs | |
External URL reference
| 186 | | Understand server parameters for Azure PostgreSQL flexible server | https://learn.microsoft.com/en-us/azure/postgresql/server-parameters/concepts-server-parameters | |
External URL reference
| 187 | | List all server parameters for Azure PostgreSQL flexible server | https://learn.microsoft.com/en-us/azure/postgresql/server-parameters/how-to-server-parameters-list-all | |
External URL reference
| 188 | | List Azure PostgreSQL parameters with modified defaults | https://learn.microsoft.com/en-us/azure/postgresql/server-parameters/how-to-server-parameters-list-modified | |
External URL reference
| 189 | | List read-only dynamic parameters on Azure PostgreSQL | https://learn.microsoft.com/en-us/azure/postgresql/server-parameters/how-to-server-parameters-list-read-only | |
External URL reference
| 190 | | List read-write dynamic parameters on Azure PostgreSQL | https://learn.microsoft.com/en-us/azure/postgresql/server-parameters/how-to-server-parameters-list-read-write-dynamic | |
External URL reference
| 191 | | List read-write static parameters on Azure PostgreSQL | https://learn.microsoft.com/en-us/azure/postgresql/server-parameters/how-to-server-parameters-list-read-write-static | |
External URL reference
| 192 | | Revert all Azure PostgreSQL parameters to defaults | https://learn.microsoft.com/en-us/azure/postgresql/server-parameters/how-to-server-parameters-revert-all-default | |
External URL reference
| 193 | | Revert a single Azure PostgreSQL parameter to default | https://learn.microsoft.com/en-us/azure/postgresql/server-parameters/how-to-server-parameters-revert-one-default | |
External URL reference
| 194 | | Set Azure PostgreSQL server parameter values safely | https://learn.microsoft.com/en-us/azure/postgresql/server-parameters/how-to-server-parameters-set-value | |
External URL reference
| 195 | | Configure autovacuum parameters on Azure PostgreSQL | https://learn.microsoft.com/en-us/azure/postgresql/server-parameters/param-autovacuum | |
External URL reference
| 196 | | Configure client connection default options on Azure PostgreSQL | https://learn.microsoft.com/en-us/azure/postgresql/server-parameters/param-client-connection-defaults-defaults | |
External URL reference
| 197 | | Set locale and formatting defaults on Azure PostgreSQL | https://learn.microsoft.com/en-us/azure/postgresql/server-parameters/param-client-connection-defaults-locale-formatting | |
External URL reference
| 198 | | Preload shared libraries via client defaults on Azure PostgreSQL | https://learn.microsoft.com/en-us/azure/postgresql/server-parameters/param-client-connection-defaults-shared-library-preloading | |
External URL reference
| 199 | | Control statement behavior defaults on Azure PostgreSQL | https://learn.microsoft.com/en-us/azure/postgresql/server-parameters/param-client-connection-defaults-statement-behavior | |
External URL reference
| 200 | | Tune connection settings and max_connections on Azure PostgreSQL | https://learn.microsoft.com/en-us/azure/postgresql/server-parameters/param-connections-authentication-connection-settings | |
External URL reference
| 201 | | Configure TCP settings for Azure PostgreSQL connections | https://learn.microsoft.com/en-us/azure/postgresql/server-parameters/param-connections-authentication-tcp-settings | |
External URL reference
| 202 | | Use customized server options like azure_storage.blob_block_size_mb | https://learn.microsoft.com/en-us/azure/postgresql/server-parameters/param-customized-options | |
External URL reference
| 203 | | Developer options server parameters on Azure PostgreSQL | https://learn.microsoft.com/en-us/azure/postgresql/server-parameters/param-developer-options | |
External URL reference
| 204 | | Configure error handling parameters on Azure PostgreSQL | https://learn.microsoft.com/en-us/azure/postgresql/server-parameters/param-error-handling | |
External URL reference
| 205 | | File location server parameters for Azure PostgreSQL | https://learn.microsoft.com/en-us/azure/postgresql/server-parameters/param-file-locations | |
External URL reference
| 206 | | Intelligent tuning server parameters on Azure PostgreSQL | https://learn.microsoft.com/en-us/azure/postgresql/server-parameters/param-intelligent-tuning | |
External URL reference
| 207 | | Lock management server parameters on Azure PostgreSQL | https://learn.microsoft.com/en-us/azure/postgresql/server-parameters/param-lock-management | |
External URL reference
| 208 | | Metrics-related server parameters on Azure PostgreSQL | https://learn.microsoft.com/en-us/azure/postgresql/server-parameters/param-metrics | |
External URL reference
| 209 | | Migration-related server parameters on Azure PostgreSQL | https://learn.microsoft.com/en-us/azure/postgresql/server-parameters/param-migration | |
External URL reference
| 210 | | Configure PgBouncer parameters and tier support on Azure PostgreSQL | https://learn.microsoft.com/en-us/azure/postgresql/server-parameters/param-pgbouncer | |
External URL reference
| 211 | | Preset options server parameters on Azure PostgreSQL | https://learn.microsoft.com/en-us/azure/postgresql/server-parameters/param-preset-options | |
External URL reference
| 212 | | Process title server parameters on Azure PostgreSQL | https://learn.microsoft.com/en-us/azure/postgresql/server-parameters/param-process-title | |
External URL reference
| 213 | | Genetic query optimizer parameters on Azure PostgreSQL | https://learn.microsoft.com/en-us/azure/postgresql/server-parameters/param-query-tuning-genetic-query-optimizer | |
External URL reference
| 214 | | Tune planner cost constants like effective_cache_size | https://learn.microsoft.com/en-us/azure/postgresql/server-parameters/param-query-tuning-planner-cost-constants | |
External URL reference
| 215 | | Planner method configuration parameters on Azure PostgreSQL | https://learn.microsoft.com/en-us/azure/postgresql/server-parameters/param-query-tuning-planner-method-configuration | |
External URL reference
| 216 | | Other planner options for query tuning on Azure PostgreSQL | https://learn.microsoft.com/en-us/azure/postgresql/server-parameters/param-query-tuning-planner-options | |
External URL reference
| 217 | | Replication master server parameters on Azure PostgreSQL | https://learn.microsoft.com/en-us/azure/postgresql/server-parameters/param-replication-master-server | |
External URL reference
| 218 | | Understand primary server replication parameters availability | https://learn.microsoft.com/en-us/azure/postgresql/server-parameters/param-replication-primary-server | |
External URL reference
| 219 | | Standby server replication parameters on Azure PostgreSQL | https://learn.microsoft.com/en-us/azure/postgresql/server-parameters/param-replication-standby-servers | |
External URL reference
| 220 | | Subscriber replication parameters on Azure PostgreSQL | https://learn.microsoft.com/en-us/azure/postgresql/server-parameters/param-replication-subscribers | |
External URL reference
| 221 | | Control what to log via reporting and logging parameters | https://learn.microsoft.com/en-us/azure/postgresql/server-parameters/param-reporting-logging-what-log | |
External URL reference
| 222 | | Configure PostgreSQL logging timing parameters in Azure | https://learn.microsoft.com/en-us/azure/postgresql/server-parameters/param-reporting-logging-when-log | |
External URL reference
| 223 | | Configure PostgreSQL log destination parameters in Azure | https://learn.microsoft.com/en-us/azure/postgresql/server-parameters/param-reporting-logging-where-log | |
External URL reference
| 224 | | Tune asynchronous behavior parameters for Azure PostgreSQL | https://learn.microsoft.com/en-us/azure/postgresql/server-parameters/param-resource-usage-asynchronous-behavior | |
External URL reference
| 225 | | Configure background writer parameters on Azure PostgreSQL | https://learn.microsoft.com/en-us/azure/postgresql/server-parameters/param-resource-usage-background-writer | |
External URL reference
| 226 | | Adjust cost-based vacuum delay on Azure PostgreSQL | https://learn.microsoft.com/en-us/azure/postgresql/server-parameters/param-resource-usage-cost-based-vacuum-delay | |
External URL reference
| 227 | | Configure disk-related resource usage for Azure PostgreSQL | https://learn.microsoft.com/en-us/azure/postgresql/server-parameters/param-resource-usage-disk | |
External URL reference
| 228 | | Configure kernel resource usage for Azure PostgreSQL | https://learn.microsoft.com/en-us/azure/postgresql/server-parameters/param-resource-usage-kernel-resources | |
External URL reference
| 229 | | Configure memory and huge pages for Azure PostgreSQL | https://learn.microsoft.com/en-us/azure/postgresql/server-parameters/param-resource-usage-memory | |
External URL reference
| 230 | | Configure cumulative query and index stats in Azure PostgreSQL | https://learn.microsoft.com/en-us/azure/postgresql/server-parameters/param-statistics-cumulative-query-index-statistics | |
External URL reference
| 231 | | Configure monitoring statistics parameters for Azure PostgreSQL | https://learn.microsoft.com/en-us/azure/postgresql/server-parameters/param-statistics-monitoring | |
External URL reference
| 232 | | Understand query and index stats collector parameters by version | https://learn.microsoft.com/en-us/azure/postgresql/server-parameters/param-statistics-query-index-statistics-collector | |
External URL reference
| 233 | | Set compatibility parameters for other clients on Azure PostgreSQL | https://learn.microsoft.com/en-us/azure/postgresql/server-parameters/param-version-platform-compatibility-platforms-clients | |
External URL reference
| 234 | | Configure compatibility with previous PostgreSQL versions in Azure | https://learn.microsoft.com/en-us/azure/postgresql/server-parameters/param-version-platform-compatibility-postgresql-versions | |
External URL reference
| 235 | | Check archive recovery parameters availability by Azure PostgreSQL version | https://learn.microsoft.com/en-us/azure/postgresql/server-parameters/param-write-ahead-log-archive-recovery | |
External URL reference
| 236 | | Configure WAL archiving parameters on Azure PostgreSQL | https://learn.microsoft.com/en-us/azure/postgresql/server-parameters/param-write-ahead-log-archiving | |
External URL reference
| 237 | | Tune WAL checkpoint parameters for Azure PostgreSQL | https://learn.microsoft.com/en-us/azure/postgresql/server-parameters/param-write-ahead-log-checkpoints | |
External URL reference
| 238 | | Check WAL recovery parameters availability across Azure PostgreSQL versions | https://learn.microsoft.com/en-us/azure/postgresql/server-parameters/param-write-ahead-log-recovery | |
External URL reference
| 239 | | Check WAL recovery target parameters availability by version | https://learn.microsoft.com/en-us/azure/postgresql/server-parameters/param-write-ahead-log-recovery-target | |
External URL reference
| 240 | | Configure WAL settings and buffers on Azure PostgreSQL | https://learn.microsoft.com/en-us/azure/postgresql/server-parameters/param-write-ahead-log-settings | |
External URL reference
| 245 | | Use semantic operators from Azure AI extension in SQL | https://learn.microsoft.com/en-us/azure/postgresql/azure-ai/generative-ai-azure-ai-semantic-operators | |
External URL reference
| 246 | | Invoke Azure Language services from PostgreSQL | https://learn.microsoft.com/en-us/azure/postgresql/azure-ai/generative-ai-azure-cognitive | |
External URL reference
| 247 | | Call Azure Machine Learning models from PostgreSQL | https://learn.microsoft.com/en-us/azure/postgresql/azure-ai/generative-ai-azure-machine-learning | |
External URL reference
| 248 | | Generate and store Azure OpenAI embeddings in PostgreSQL | https://learn.microsoft.com/en-us/azure/postgresql/azure-ai/generative-ai-azure-openai | |
External URL reference
| 249 | | Use Azure AI extension and OpenAI embeddings in PostgreSQL | https://learn.microsoft.com/en-us/azure/postgresql/azure-ai/generative-ai-azure-overview | |
External URL reference
| 250 | | Use LangChain with Azure PostgreSQL vector database | https://learn.microsoft.com/en-us/azure/postgresql/azure-ai/generative-ai-develop-with-langchain | |
External URL reference
| 251 | | Integrate Azure PostgreSQL with Microsoft Foundry via MCP | https://learn.microsoft.com/en-us/azure/postgresql/azure-ai/generative-ai-foundry-integration | |
External URL reference
| 252 | | Integrate AI orchestration frameworks with Azure PostgreSQL | https://learn.microsoft.com/en-us/azure/postgresql/azure-ai/generative-ai-frameworks | |
External URL reference
| 253 | | Connect to Azure PostgreSQL from C# applications | https://learn.microsoft.com/en-us/azure/postgresql/connectivity/connect-csharp | |
External URL reference
| 254 | | Access Azure PostgreSQL using Go database drivers | https://learn.microsoft.com/en-us/azure/postgresql/connectivity/connect-go | |
External URL reference
| 255 | | Use Java and JDBC with Azure PostgreSQL | https://learn.microsoft.com/en-us/azure/postgresql/connectivity/connect-java | |
External URL reference
| 256 | | Connect PHP applications to Azure PostgreSQL | https://learn.microsoft.com/en-us/azure/postgresql/connectivity/connect-php | |
External URL reference
| 257 | | Connect and query Azure PostgreSQL using Python | https://learn.microsoft.com/en-us/azure/postgresql/connectivity/connect-python | |
External URL reference
| 258 | | Manage Azure PostgreSQL servers using .NET SDK | https://learn.microsoft.com/en-us/azure/postgresql/developer/create-server-dotnet-sdk | |
External URL reference
| 259 | | Create and manage Azure PostgreSQL via Java SDK | https://learn.microsoft.com/en-us/azure/postgresql/developer/create-server-java-sdk | |
External URL reference
| 260 | | Provision Azure PostgreSQL with Python SDK | https://learn.microsoft.com/en-us/azure/postgresql/developer/create-server-python-sdk | |
External URL reference
| 261 | | Connect PostgreSQL databases via VS Code extension | https://learn.microsoft.com/en-us/azure/postgresql/developer/vs-code-extension/vs-code-connect | |
External URL reference
| 262 | | Use GitHub Copilot with VS Code PostgreSQL extension | https://learn.microsoft.com/en-us/azure/postgresql/developer/vs-code-extension/vs-code-github-copilot | |
External URL reference
| 263 | | Use Azure Storage extension examples for PostgreSQL | https://learn.microsoft.com/en-us/azure/postgresql/extensions/quickstart-azure-storage-extension | |
External URL reference
| 264 | | Reference for Azure Storage extension functions in PostgreSQL | https://learn.microsoft.com/en-us/azure/postgresql/extensions/reference-azure-storage-extension | |
External URL reference
| 265 | | Configure Azure Data Factory connector for PostgreSQL | https://learn.microsoft.com/en-us/azure/postgresql/integration/how-to-connect-data-factory | |
External URL reference
| 266 | | Use Data Factory copy activity with PostgreSQL | https://learn.microsoft.com/en-us/azure/postgresql/integration/how-to-data-factory-copy-activity-azure | |
External URL reference
| 267 | | Run PostgreSQL script activity in Data Factory | https://learn.microsoft.com/en-us/azure/postgresql/integration/how-to-data-factory-script-activity-azure | |
External URL reference
| 268 | | Migrate Oracle schemas to Azure PostgreSQL using Ora2Pg | https://learn.microsoft.com/en-us/azure/postgresql/migrate/how-to-migrate-oracle-ora2pg | |
External URL reference
| 269 | | Use pg_dump and pg_restore with Azure PostgreSQL | https://learn.microsoft.com/en-us/azure/postgresql/migrate/how-to-migrate-using-dump-and-restore | |
External URL reference
| 270 | | Set up Azure CLI integration for PostgreSQL migration service | https://learn.microsoft.com/en-us/azure/postgresql/migrate/migration-service/how-to-setup-azure-cli-commands-postgresql | |
External URL reference
| 275 | | Deploy database updates via Azure Pipelines to Azure PostgreSQL | https://learn.microsoft.com/en-us/azure/postgresql/configure-maintain/azure-pipelines-deploy-database-task | |
External URL reference
| 276 | | Use GitHub Actions to deploy changes to Azure PostgreSQL | https://learn.microsoft.com/en-us/azure/postgresql/configure-maintain/how-to-deploy-github-action | |
External URL reference
| 277 | | Perform in-place major version upgrades on Azure PostgreSQL | https://learn.microsoft.com/en-us/azure/postgresql/configure-maintain/how-to-perform-major-version-upgrade | |
External URL reference
| 278 | | Deploy Azure PostgreSQL flexible server using Bicep | https://learn.microsoft.com/en-us/azure/postgresql/developer/create-server-bicep | |
External URL reference
| 279 | | Deploy Django on AKS with Azure PostgreSQL backend | https://learn.microsoft.com/en-us/azure/postgresql/developer/django-aks-database | |
External URL reference
| 280 | | Deploy Azure Web App and PostgreSQL in same VNet | https://learn.microsoft.com/en-us/azure/postgresql/developer/webapp-server-vnet | |
External URL reference
| 281 | | Understand PostgreSQL maintenance release rollout behavior | https://learn.microsoft.com/en-us/azure/postgresql/release-notes-maintenance/release-notes-maintenance-index | |
External URL reference
| 282 | | Restore PostgreSQL flexible server to a point in time | https://learn.microsoft.com/en-us/azure/postgresql/samples/sample-point-in-time-restore | |
Install this skill with one command
/learn @microsoftdocs/azure-database-postgresql