1,785 questions with Azure Database for PostgreSQL tags

Sort by: Updated
1 answer

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
asked 2026-01-22T17:36:19.1933333+00:00
Kevin Weng 0 Reputation points
edited an answer 2026-01-22T22:28:02.28+00:00
Marcin Policht 73,180 Reputation points MVP Volunteer Moderator
2 answers

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
asked 2026-01-20T12:54:10.57+00:00
Kiarash Azarnia 0 Reputation points
commented 2026-01-22T20:28:58.6833333+00:00
VRISHABHANATH PATIL 4,750 Reputation points Microsoft External Staff Moderator
1 answer

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
asked 2026-01-22T20:08:00.03+00:00
Farshadfar, Tony 0 Reputation points
answered 2026-01-22T20:08:08.6566667+00:00
Q&A Assist
1 answer

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
asked 2026-01-22T18:58:04.5833333+00:00
Farshadfar, Tony 0 Reputation points
answered 2026-01-22T20:04:31.39+00:00
VRISHABHANATH PATIL 4,750 Reputation points Microsoft External Staff Moderator
2 answers One of the answers was accepted by the question author.

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
asked 2026-01-22T03:00:22.12+00:00
dott-nagayama 65 Reputation points
edited the question 2026-01-22T18:42:56.1266667+00:00
Alberto Morillo 35,411 Reputation points MVP Volunteer Moderator
1 answer

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
asked 2026-01-22T11:31:45.65+00:00
Bobby John 0 Reputation points
edited the question 2026-01-22T12:20:36.48+00:00
Manoj Kumar Boyini 4,465 Reputation points Microsoft External Staff Moderator
0 answers

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
asked 2026-01-22T10:46:12.5266667+00:00
Ludovic Manjot 0 Reputation points
commented 2026-01-22T11:14:25.0333333+00:00
Manoj Kumar Boyini 4,465 Reputation points Microsoft External Staff Moderator
1 answer

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
asked 2026-01-08T15:41:15.01+00:00
JeffreyCMI 86 Reputation points
edited a comment 2026-01-22T10:41:00.6466667+00:00
Evert Heylen 0 Reputation points
2 answers

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
asked 2026-01-20T10:10:36.82+00:00
Pasquale Ceglie 0 Reputation points
commented 2026-01-22T08:50:27.1133333+00:00
Manoj Kumar Boyini 4,465 Reputation points Microsoft External Staff Moderator
1 answer One of the answers was accepted by the question author.

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
asked 2026-01-19T08:08:18.0866667+00:00
Gaurav Agrawal 20 Reputation points
accepted 2026-01-22T06:47:59.5366667+00:00
Gaurav Agrawal 20 Reputation points
2 answers

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
asked 2026-01-22T01:30:07.22+00:00
Askardeen Buhari 0 Reputation points
commented 2026-01-22T04:57:28.62+00:00
Pilladi Padma Sai Manisha 2,225 Reputation points Microsoft External Staff Moderator
3 answers

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
asked 2026-01-19T11:07:50.2233333+00:00
Harry Bridge 0 Reputation points
answered 2026-01-22T03:24:38.3133333+00:00
Saraswathi Devadula 13,980 Reputation points Microsoft External Staff Moderator
1 answer One of the answers was accepted by the question author.

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
asked 2026-01-16T11:14:40.8366667+00:00
Jakhongir Mustafaev 60 Reputation points
commented 2026-01-22T02:10:03.8+00:00
Jakhongir Mustafaev 60 Reputation points
1 answer

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
asked 2026-01-21T19:41:29.0166667+00:00
Andrew Reid 20 Reputation points
commented 2026-01-21T20:49:18.52+00:00
Manoj Kumar Boyini 4,465 Reputation points Microsoft External Staff Moderator
2 answers One of the answers was accepted by the question author.

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
asked 2026-01-19T16:48:54.0466667+00:00
Ryan Spurlock 80 Reputation points
accepted 2026-01-21T15:33:44.0066667+00:00
Ryan Spurlock 80 Reputation points
0 answers

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
asked 2026-01-21T11:06:46.68+00:00
Rens Oostenbach 20 Reputation points
commented 2026-01-21T12:29:27.4933333+00:00
Manoj Kumar Boyini 4,465 Reputation points Microsoft External Staff Moderator
4 answers One of the answers was accepted by the question author.

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
asked 2026-01-13T13:49:30.89+00:00
Tripesh Dhoriya 60 Reputation points
answered 2026-01-21T10:03:16.6433333+00:00
Tripesh Dhoriya 60 Reputation points
2 answers One of the answers was accepted by the question author.

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
asked 2026-01-19T14:57:03.9966667+00:00
Soviene KHAMAR 20 Reputation points
accepted 2026-01-21T08:33:28.7266667+00:00
Soviene KHAMAR 20 Reputation points
2 answers

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
asked 2026-01-20T11:49:48.7133333+00:00
Ícaro Sousa 20 Reputation points
commented 2026-01-21T01:11:13.1966667+00:00
Pilladi Padma Sai Manisha 2,225 Reputation points Microsoft External Staff Moderator
1 answer

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:…

Azure Database for PostgreSQL
asked 2026-01-20T09:11:59.9233333+00:00
Daan de Bruin 20 Reputation points
answered 2026-01-20T11:44:27.7433333+00:00
Sina Salam 27,141 Reputation points Volunteer Moderator