1,506 questions with Azure Database for PostgreSQL tags

Sort by: Updated
0 answers

If I take an on-demand backup of an Azure Database for PostgreSQL instance, will I incur any additional charges for storing that backup? Is there any official Microsoft documentation that explains the cost implications

we are redeploying it for CMK steps. so we are concerned on costing.

Azure Database for PostgreSQL
asked 2025-08-12T09:52:51.4766667+00:00
Shubham Raut 0 Reputation points
commented 2025-08-12T10:10:32.43+00:00
Saraswathi Devadula 10,855 Reputation points Microsoft External Staff Moderator
1 answer One of the answers was accepted by the question author.

PostgreSQL Server Down for Too Long Due to Maintenance

Hello Azure Support Team, We received the following maintenance notification for our Azure Database for PostgreSQL Flexible Server: Operation name: Maintenance Timestamp: Sun Aug 10 2025 11:30:49 GMT+0530 (India Standard Time) Event initiated by:…

Azure Database for PostgreSQL
asked 2025-08-12T01:08:33.3466667+00:00
gopalp 0 Reputation points
accepted 2025-08-12T09:18:45.4166667+00:00
gopalp 0 Reputation points
0 answers

Unable to connec to Azure Database for PostgreSQL flexible server from AWS VPC with site-to-site VPN

I want to connec to Azure Database for PostgreSQL flexible server from AWS VPC. I created site-to-site VPN and the VPN status is all right. But I still cannot connec to the Azure Database for PostgreSQL flexible server from AWS VCP with this VPN. Logs as…

Azure Database for PostgreSQL
asked 2025-08-10T13:10:45.9033333+00:00
Zhan, Kael 0 Reputation points
commented 2025-08-12T06:02:55.35+00:00
Zhan, Kael 0 Reputation points
0 answers

Cannot add azure_storage extension to Flexible Postgres 16.9

When I run the following SQL command: CREATE`` ``EXTENSION`` ``IF`` ``NOT`` ``EXISTS`` azure_storage; I get the following error: ERROR: permission denied to alter restricted role "azure_pg_admin" I can confirm that the extension has been…

Azure Database for PostgreSQL
asked 2025-08-11T10:05:36.7466667+00:00
Conor Nash 0 Reputation points
commented 2025-08-12T05:18:46.4866667+00:00
Saraswathi Devadula 10,855 Reputation points Microsoft External Staff Moderator
1 answer

Azure PostgreSQL Flexible Server restart failed

My PostgreSQL Flexible Server has an unresponsive VM agent causing: Server reports "Ready" state but cannot perform operations All CLI commands fail with "Cannot complete operation while server is in 'Ready' state" Auto-migration…

Azure Database for PostgreSQL
asked 2025-08-10T19:06:36.57+00:00
Mu'awiyah Namadi 0 Reputation points
commented 2025-08-12T05:11:24.8966667+00:00
Saraswathi Devadula 10,855 Reputation points Microsoft External Staff Moderator
1 answer

Cannot restart Flexible Server churchlife — ServerIsNotReady

Hi, I'm in a Database server lockout. I have high CPU utilization & I'm not able to connect to it, restart it, or scale up. It needs a hard restart. Subscription Id: 710df622-dbe6-41d7-8f1a-51a3d1addfab Resource Group: churchlife-prod-rg Name:…

Azure Database for PostgreSQL
asked 2025-08-10T19:34:16.2466667+00:00
Johny Rulan 0 Reputation points
commented 2025-08-12T05:10:52.84+00:00
Saraswathi Devadula 10,855 Reputation points Microsoft External Staff Moderator
0 answers

Após uma atualização a conexão com o banco de dados foi perdida

Olá, comunidade Microsoft, Após o evento de manutenção planejada identificado pelo tracking ID NVSY-TV8 (link do incidente: Portal Azure), estamos enfrentando indisponibilidade de conexão com o Banco de dados. Problemas identificados: Os recursos não…

Azure Database for PostgreSQL
asked 2025-08-11T21:06:31.3033333+00:00
CYTEI Desenvolvedor 0 Reputation points
commented 2025-08-11T21:23:21.58+00:00
Mahesh Kurva 6,850 Reputation points Microsoft External Staff Moderator
0 answers

We are trying to migrate a on-prem postgresql server(12.2) to a flexible server(16)

We are trying to migrate the on-prem postgresql server in master-slave config to a flexible server using the migrate option within the flexible server. I am getting error, permission denied for function pg_replication_origin_oid.. replicate slot was…

Azure Database for PostgreSQL
asked 2025-08-11T15:49:37.9166667+00:00
snehil kaushik 0 Reputation points
commented 2025-08-11T19:34:20.3066667+00:00
Mahesh Kurva 6,850 Reputation points Microsoft External Staff Moderator
0 answers

High Backup Storage Usage: Request for Detailed Breakdown

My Azure Database for PostgreSQL Flexible Server bill shows a significant increase in "Backup Storage LRS Data Stored" costs — from $255.72 in June to $580.90 in July. During this time I did not modify the provisioned storage capacity…

Azure Database for PostgreSQL
asked 2025-08-11T16:15:09.5866667+00:00
JeffreyCMI 41 Reputation points
commented 2025-08-11T16:46:31.21+00:00
Mahesh Kurva 6,850 Reputation points Microsoft External Staff Moderator
1 answer One of the answers was accepted by the question author.

Scheduled maintenance has been stuck for 6 days

I can't connect to my PostgreSQL flexible server. There is a resource health alert for a scheduled maintenance. "Unavailable (Planned) The scheduled maintenance for your Azure Database for PostgreSQL - Flexible server is taking longer than…

Azure Database for PostgreSQL
asked 2025-08-05T21:29:03.0533333+00:00
Francesco 20 Reputation points
accepted 2025-08-11T12:54:11.5766667+00:00
Francesco 20 Reputation points
1 answer One of the answers was accepted by the question author.

Azure Database for PostgreSQL flexible server stuck on UpgradingMajorVersion

Hi, I've been upgrading our databases to the latest version 17 from 16.8 and one of them stuck on UpgradingMajorVersion status. It's still running for more than 18 hours despite the fact that I cancelled the deployment task. Could you please provide…

Azure Database for PostgreSQL
asked 2025-08-07T09:21:42.8666667+00:00
Sebastian 40 Reputation points
accepted 2025-08-11T08:47:58.28+00:00
Sebastian 40 Reputation points
0 answers

Resource name not available while it previously was

I am trying to create a postgres server with the name db-psql-data-stack-sb-01 I had initially deployed a postgres server with this name in December last year. Then, a similar issue to this occurred:…

Azure Database for PostgreSQL
asked 2025-08-11T06:55:31.2666667+00:00
Rens Oostenbach 0 Reputation points
commented 2025-08-11T07:20:17.06+00:00
Saraswathi Devadula 10,855 Reputation points Microsoft External Staff Moderator
1 answer

Azure Cosmos for PostgresDB provisioning error when specifying authConfig

I'm seeing an issue when trying to provision a Cosmos for PostgresDB instance using terraform/arm templates. I can provision this configuration successfully, but if I uncomment the 'authConfig' block it fails with a "500 - Internal Server…

Azure Database for PostgreSQL
asked 2024-12-31T10:53:33.0433333+00:00
PGT 0 Reputation points
commented 2025-08-09T19:35:27.83+00:00
George Kosmidis 0 Reputation points MVP
1 answer One of the answers was accepted by the question author.

Message: Restart and stop operations are only supported on servers that are in 'Ready' state. Server 'xxx' is in 'Ready' state.

Hi, I have a Azure PostgreSQL Flexible database, and at 11:30 pm GMT+2 it lost connection to our app service, we cannot restart the database as it gives the following error: Message: Restart and stop operations are only supported on servers that are in…

Azure Database for PostgreSQL
asked 2025-07-09T07:48:03.0633333+00:00
Matthew Ethan Tam 20 Reputation points
commented 2025-08-10T19:09:00.49+00:00
Mu'awiyah Namadi 0 Reputation points
1 answer

How to update postgres 11 to postgres17?

I am trying to upgrade my Azure Postgres flexserver from 11 to 17 but I am seeing errors in the upgrade deployment regarding password. I have check my Authentication and it appears to be correct but I would like to make sure I have the right steps.…

Azure Database for PostgreSQL
asked 2025-07-24T01:48:59.5966667+00:00
Cordellia Yokum 0 Reputation points
commented 2025-08-10T12:43:38.9166667+00:00
Nadir Jaffer 0 Reputation points
1 answer

What is PostgreSQL 16.10?

Azure Portal shows I have PostgreSQL 16.10 on a newly created Azure PostgreSQL flexible server. This is not a PostgreSQL version that exists. What’s in it and where can I find more information? This version behaves significantly different from 16.9 when…

Azure Database for PostgreSQL
asked 2025-07-29T14:46:47.2433333+00:00
Daniel B 0 Reputation points
edited an answer 2025-08-08T06:33:06.0566667+00:00
Mahesh Kurva 6,850 Reputation points Microsoft External Staff Moderator
1 answer One of the answers was accepted by the question author.

Postgres flex DB suddenly stopped reporting some metrics (but not all)

I am managing multiple postgres flex DBs across a variety of resources groups. One of them (just one) has suddenly stopped providing any CPU, Memory, and Storage metrics, though it still reports DB connections, throughput, and availability. The DB also…

Azure Database for PostgreSQL
asked 2025-08-05T08:56:03.11+00:00
Michael Schilder 40 Reputation points
accepted 2025-08-06T10:17:47.69+00:00
Michael Schilder 40 Reputation points
0 answers

PostgreSQL server disappeared from Portal, but the database is still up and running.

One of our PostgreSQL flexible servers have disappeared from view in Azure Portal. The database is still up and running, because I can connect to and query it. It is still visible when running az postgres flexible-server list, and the displayed info…

Azure Database for PostgreSQL
asked 2025-08-07T07:03:08.3866667+00:00
Stefan 0 Reputation points
commented 2025-08-07T07:11:03.1066667+00:00
Mahesh Kurva 6,850 Reputation points Microsoft External Staff Moderator
0 answers

Azure Database for PostgreSQL flexible server metrics are missing

The CPU/RAM/Storage metrics from PostgreSQL have been missing since August 3. Other metrics are available. I tried to restart the server - it didn't help. Any suggestions?

Azure Database for PostgreSQL
asked 2025-08-07T18:16:20.5933333+00:00
Mantas Smelevičius 0 Reputation points
commented 2025-08-08T02:02:03.6433333+00:00
Mahesh Kurva 6,850 Reputation points Microsoft External Staff Moderator
1 answer One of the answers was accepted by the question author.

Azure postgres flexible server zone redundancy unavailable for one tenant but available for another tenant

When i use my personal account with pay as you go mode, and try to create azure postgres flexible server in region eastus, I cannot see option for zone redundancy and page says the region does not support zone redundancy. The same when I use with another…

Azure Database for PostgreSQL
asked 2025-08-08T07:57:04.88+00:00
Vishnu Mullenkandy 40 Reputation points
accepted 2025-08-08T14:37:34.1866667+00:00
Vishnu Mullenkandy 40 Reputation points