How do I force a maintenance update?
I get the below error message trying to upgrade in-place one of my PostgreSQL Flexible Servers from 17 to 18. It's been saying this for like a month... how do I force it to undergo maintenance so I can upgrade it? Your server must undergo maintenance…
Azure Database for PostgreSQL
Azure Backup for PostgreSQL Flexible Server - Protection Error: PostgreSQLFlexOperationFailedUserError
Problem Description I have configured Azure Backup for a PostgreSQL Flexible Server using Terraform. The PostgreSQL Flexible Server instance is healthy and running without issues, but the backup instance shows a "Protection Error" status with…
Azure Database for PostgreSQL
create a job in gov cloud to restart PostgreSQL service once every 2 weeks in the gov cloud.
Hi. I need to create a job in gov cloud to restart this service once every 2 weeks at a specific day and time. How can I do that? The Automation feature is not available in the gov cloud.
Azure Database for PostgreSQL
How to create a scheduled job to restart an Azure PostgreSQL Flex Service once every 2 weeks?
Hi. The Restart service icon of PostrgreSQL Flex database service is available but I need to create a job to restart this service once every 2 weeks at a specific day and time. How can I do that?
Azure Database for PostgreSQL
Azure Database for PostgreSQL Flexible Server forces default_transaction_read_only = on on every new connection
Azure Database for PostgreSQL Flexible Server default_transaction_read_only and transaction_read_only are automatically set to ON on every new connection. On the Azure Portal, in the server parameters page, default_transaction_read_only is configured as…
Azure Database for PostgreSQL
Postgresql Migration from 17 to 18
Hi Team, We are working on postgrseql (azure), which needs to be migrated from version 17 to version 18. So far no luck. One error was of the below kind: Operation name'audit' Policy action. Upgrade error. Anyone who has faced similar error or who…
Azure Database for PostgreSQL
B1ms Server Stuck: FATAL pg_hba.conf rejects connection despite active Firewall Rules
Issue: Since yesterday Azure PostgreSQL Flexible Server (B1ms tier) is rejecting all connections with FATAL: pg_hba.conf rejects connection, despite Firewall rules being correctly configured in the Portal and CLI. Symptoms: Server: mara (Switzerland…
Azure Database for PostgreSQL
pg_duckdb extension: Cannot create Azure secrets due to FDW permissions on Flexible Server
I'm trying to use the pg_duckdb extension on Azure Flexible database for Postgresql Postgresql version: 17.7 extension: pg_duckdb Goal: I need to query Parquet files from Azure Blob Storage for multiple lower-privilege database users. Using SAS…
Azure Database for PostgreSQL
Azure Database for PostgreSQL flexible server > Migration issue
I'm trying to migrate an onprem PostgreSQL 16 database to an Azure database from PostgreSQL flexible server and I'm having the following problem: However, trying to run the command CREATE EXTENSION postgis_tiger_geocoder; from Dbeaver to destination…
Azure Database for PostgreSQL
In-place major version upgrade for Azure PostgreSQL not available in Germany West Central – is there a rollout timeline?
I’m using Azure Database for PostgreSQL – Flexible Server in the Germany West Central region and noticed that the in-place major version upgrade option is not available in the Azure portal for my server. I understand that feature availability can be…
Azure Database for PostgreSQL
Storage metrics not populating for PostgreSQL Flexible Server - known platform issue
Issue Summary Storage metrics (storage_percent, storage_used, storage_free) have not been collecting data for my PostgreSQL Flexible Server since creation 1+ months ago, despite having identical configuration to a working dev server. Problem…
Azure Database for PostgreSQL
MVU for PostgreSQL to V18 in UK South Region
Hello, With the GA announcement for V18 in all regions at the start of December last year with the note that not all regions were supported for MVU but were being rolled out in 'the next few weeks' could someone tell me the timeline for rollout to the UK…
Azure Database for PostgreSQL
In v18 update for PostgreSQL getting "acquire a new token and try again error" for Entra authentication
Hello, Getting the below error for Entra when I updated to v18 for PostgreSQL. Everything was fine in v17, and the 55-minute token refresh interval was working without any issues. I tried to change to 50-minutes in v18, but it's still the same…
Azure Database for PostgreSQL
Attempt to upgrade Azure Database for PostgreSQL fails pre-check
Trying to upgrade our PostgreSQL server's major version number using the "upgrade" button from within the Portal view of this resource, but it fails the precheck. Copied the error message below. We'd like to upgrade to version 17. Thank you. …
Azure Database for PostgreSQL
Postgres Flexible Instance Storage Upgrade Job Stuck
I tried to upgrade my storage on a dev/test postgres flexible instance from 128 -> 256 gigs. The Activity log shows repeated "Get PostgreSQL server List" with no progress for ~30+ minutes. What should I do?
Azure Database for PostgreSQL
Terraform plan - PostgreSQL Flexible Server: 502 Bad Gateway - ServerUnableToRetriveData
My terraform plan is failing because of a PostgreSQL flexible server returning a 502 error: │ Error: retrieving Database (Subscription: "[MASKED]" │ Resource Group Name: "xxx" │ Flexible Server Name: "xxx" │ Database Name:…
Azure Database for PostgreSQL
PostgreSQL Flexible Server metrics stopped collecting after January 1, 2026
My PostgreSQL Flexible Server stopped generating ALL metrics on January 1, 2026. Last metric data: January 1, 2026 What I've tried: Recreated diagnostic settings multiple times Verified Microsoft.Insights is registered Checked Azure Monitor…
Azure Database for PostgreSQL
pgaadauth.enable_group_sync parameter cannot be enabled on one Flexible Server (France Central)
Hello, I am experiencing an issue with the parameter pgaadauth.enable_group_sync on one Azure Database for PostgreSQL Flexible Server. I have three Flexible Servers in the France Central region. On two of them, the following Azure CLI command works as…
Azure Database for PostgreSQL
Urgent: Unable to Scale Compute (SKU) on Azure Database for PostgreSQL Flexible Server via Portal
Hello, I am requesting urgent assistance regarding a vertical scaling operation for my Azure Database for PostgreSQL Flexible Server instance. I need to upgrade the compute tier. However, I am unable to complete this process through the Azure Portal…
Azure Database for PostgreSQL
Intermittent 502 Bad Gateway / ServerUnableToRetriveData - Postgres Flexible Server - Canada Central
We are encountering a persistent platform-level error specifically in the Canada Central region when managing PostgreSQL Flexible Server databases via the Azure Resource Manager API. The Error: Status: 502 Bad Gateway Error Code:…