Azure Database for PostgreSQL
An Azure managed PostgreSQL database service for app development and deployment.
1,207 questions
0 answers
Postgres Flexible Server stuck in “starting” state for two days
Hello, everyone. I started my Postgres Flexible DB server Wednesday morning, and it remains stuck in the “starting” state. How can a restart this server? The “stop” and “restart” buttons are all greyed out. Can I “self-rescue” by running a…
asked 2025-02-21T11:56:07.9733333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(195.2, 56.00000000000001%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJC%3C/text%3E%3C/svg%3E)
Jonathan Craft
0
Reputation points
commented 2025-02-21T16:16:38.0733333+00:00
Jonathan Craft
0
Reputation points
3 answers
One of the answers was accepted by the question author.
How can you create a resource type: Microsoft.DBForPostgreSQL/serverGroupsv2
Hi, I am currently testing multiple Azure resource types, and am curious as to how this resource type can be created Microsoft.DBForPostgreSQL/serverGroupsv2
asked 2025-02-18T12:12:59.4366667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(176, 16%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKA%3C/text%3E%3C/svg%3E)
Katkar, Anuj
20
Reputation points
accepted 2025-02-21T11:55:11.8233333+00:00
Katkar, Anuj
20
Reputation points
0 answers
Azure Database for PostgreSQL - Flexible Server unavailable twice a day
We are running Azure Database for PostgreSQL - Flexible Server. According to the metrics, the system is not under heavy load at all (memory is constantly at approx. 60%, CPU 12% with no peaks). Database is not available approx. twice a day - this problem…
asked 2025-02-19T21:18:58.1233333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(259.20000000000005, 11%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMG%3C/text%3E%3C/svg%3E)
Martin Gubis
0
Reputation points
commented 2025-02-21T09:45:21.2766667+00:00
Martin Gubis
0
Reputation points
0 answers
Azure postgres flexible server metrics not sent to Amazon Managed Prometheus.
I am trying to export azure postgres flexible server metrics to Amazon Managed Prometheus. Able to view all the metrics for the existing database that were created in 2024. When i create a new database now i can see only azure_active_connections_count…
asked 2025-02-19T07:04:08.9766667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(233.6, 83%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDD%3C/text%3E%3C/svg%3E)
Deepika Deshpande
0
Reputation points
commented 2025-02-21T08:50:49.8666667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(256, 4%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPC%3C/text%3E%3C/svg%3E)
Prasad Chaganti
0
Reputation points Microsoft Vendor
1 answer
Retension policy and compression not supported for apache license
Hi, I'm encountering an error when trying to create a hypertable with the retention policy and compression features. The error message indicates that the 'Apache' license is not supported. Could you please provide a solution for this issue?"
asked 2025-02-11T07:54:40.58+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(304, 50%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMB%3C/text%3E%3C/svg%3E)
Manisha Balid
20
Reputation points
commented 2025-02-21T08:42:25.1133333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(252.8, 60%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMK%3C/text%3E%3C/svg%3E)
Mahesh Kurva
2,750
Reputation points Microsoft Vendor
2 answers
org.postgresql.util.PSQLException: FATAL: Service Principal oid mismatch for role[username]. when connecting azure postgresSQL from azure webapp
I am receiving below error when i try to connect my java application to azure postgresql using azure user created managed identity. INFO: Retrieving Azure AD access token... SLF4J: Failed to load class…
asked 2025-02-14T15:41:00.85+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(169.60000000000002, 31%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKS%3C/text%3E%3C/svg%3E)
Kanhaiya Sharma
0
Reputation points
commented 2025-02-21T08:19:03.9766667+00:00
Mahesh Kurva
2,750
Reputation points Microsoft Vendor
1 answer
A PostgreSQL flexible server backup to a backup vault is stuck, how do I cancel it?
Since more than 3 days a PostgreSQL flexible server backup to a backup vault is running, normally it takes less than 10 minutres. This also causes new backups to fail, because only one backup can be done at a time. I do not see a way to cancel the backup…
asked 2025-02-17T11:28:30.76+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(304, 8%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAA%3C/text%3E%3C/svg%3E)
August Admin
0
Reputation points
commented 2025-02-21T05:26:21.8633333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(220.8, 4%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESM%3C/text%3E%3C/svg%3E)
ShaktiSingh-MSFT
16,246
Reputation points
1 answer
One of the answers was accepted by the question author.
Server admin login name
Is it possible to change the Server admin login name, after the server has been created
asked 2025-02-19T03:14:37.5333333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(262.40000000000003, 33%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHB%3C/text%3E%3C/svg%3E)
Heath Bashford
0
Reputation points
accepted 2025-02-20T21:08:29.87+00:00
Heath Bashford
0
Reputation points
0 answers
PostgreSQL - Flexible server backup jobs failing
How can I troubleshoot jobs on stuck on failed state here: https://learn.microsoft.com/en-us/azure/backup/manage-backup-vault#manage-backup-jobs?
asked 2025-02-18T15:31:31.5666667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(211.20000000000002, 92%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETB%3C/text%3E%3C/svg%3E)
T B
40
Reputation points Microsoft Vendor
commented 2025-02-20T20:10:36.48+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(220.8, 47%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMS%3C/text%3E%3C/svg%3E)
Mallaiah Sangi
80
Reputation points Microsoft Vendor
1 answer
Postgres 16 - 2BP01: role "PROD-infra-dt-sp cannot be dropped because some objects depend on it
When trying to delete the SP role after creating database and schemas, it throws error. However the same command works fine in postgres15. How do we resolve this? az postgres flexible-server ad-admin delete \ --yes \ --resource-group…
asked 2025-02-18T22:20:07.63+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(22.400000000000002, 90%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDG%3C/text%3E%3C/svg%3E)
Dhivyagrace Godwin
0
Reputation points
edited a comment 2025-02-20T19:38:12.46+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(198.4, 69%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESR%3C/text%3E%3C/svg%3E)
Sai Raghunadh M
2,640
Reputation points Microsoft Vendor
1 answer
How can I make my PostgreSQL - Flexible Server restart faster?
One of our users initiated a restart of our Azure Database for PostgreSQL - Flexible Server and it has been restarting for hours. Is there anything that can be done about this? All of our options are grayed out. How do I submit a support request for…
asked 2025-02-19T15:12:35.7966667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(252.8, 66%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EEG%3C/text%3E%3C/svg%3E)
Eric Gerhardt
0
Reputation points
commented 2025-02-20T18:19:18.6233333+00:00
Sai Raghunadh M
2,640
Reputation points Microsoft Vendor
1 answer
One of the answers was accepted by the question author.
Load balancing in Azure Postgres Flexible Server
Does Azure Database for Postgresql Flexible Server support Load Balancing?What are the best practices for the same?
asked 2025-02-17T17:19:55.6466667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(220.8, 90%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESV%3C/text%3E%3C/svg%3E)
Sai Vihari
20
Reputation points
commented 2025-02-20T17:19:40.2033333+00:00
Mallaiah Sangi
80
Reputation points Microsoft Vendor
0 answers
Issues Connecting to PostgreSQL Flexible Server in Azure VPC with Terraform
Deploying a PostgreSQL Flexible Server inside a VPC using Terraform has been successful, but there is an issue with connecting via Point-to-Site VPN. After following the instructions listed here, connection attempts still fail. Attempts to resolve the…
asked 2025-01-28T01:15:27.2633333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(48, 73%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EWK%3C/text%3E%3C/svg%3E)
William Kelly
5
Reputation points
commented 2025-02-19T23:22:31.72+00:00
William Kelly
5
Reputation points
2 answers
One of the answers was accepted by the question author.
Azure database for Postgres Flexible server - Why creating extension uuid-ossp requires azure_pg_admin role?
My question is with respect to Azure Database for Postgres Flexible server (version PG16). I tried to create extension on current database (logged into database as db owner) however I see an error stating "ERROR: Only members of…
asked 2024-10-30T10:51:45.6933333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(262.40000000000003, 88%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETS%3C/text%3E%3C/svg%3E)
Tulsiraja Shastry
20
Reputation points
commented 2025-02-19T14:51:14.6066667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(204.8, 27%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETK%3C/text%3E%3C/svg%3E)
Tom Kapanka
0
Reputation points
1 answer
Metrics for Storage incorrect
The storage metrics for my PostgreSQL Flexible server no longer update. They do not reflect the true size/usage of the storage on the server. I have restarted the database multiple times to no effect.
asked 2025-02-17T10:50:30.4166667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(204.8, 18%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECN%3C/text%3E%3C/svg%3E)
Conor Nash
0
Reputation points
commented 2025-02-19T14:34:07.77+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(300.8, 60%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EP%3C/text%3E%3C/svg%3E)
PratikLad
80
Reputation points Microsoft Vendor
1 answer
Error migrating from single to flex postgres
After 16h in online migration the process failed with the following error: DB004: Failed to fetch the current migrations status. Please reference MigrationId 3691c83d-e8ba-4fca-a612-88fd534ed620, when contacting Microsoft customer support. Parameter…
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(268.8, 28.000000000000004%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJO%3C/text%3E%3C/svg%3E)
1 answer
No backups generated for Azure Flexible Server for PostgresSQL
I have a Felxible Server for Postgresql that I have restored from a backup of another server. I now use this new server for its own purpose, but there are no backups available when I go to 'Backup & Restore' blade. The retention is set for 7 days.…
asked 2025-02-17T10:07:09.38+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(227.2, 40%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERK%3C/text%3E%3C/svg%3E)
Roman Kastusik
0
Reputation points
commented 2025-02-19T05:48:25.8033333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(35.2, 49%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVK%3C/text%3E%3C/svg%3E)
Vijayalaxmi Kattimani
1,480
Reputation points Microsoft Vendor
1 answer
Migration Service: Online migration error with JSON malform error when cutover or insert/update records after initial sync
Hi, Target DB: Azure DB for postgresql Flexible server version 15 Source DB: on-prem PG version 9.5 on centos Below pgcopydb error pops up and job fails when migrating with migration service extension in Azure DB for PG flexible server. Error looks like…
asked 2025-02-12T23:48:40.36+00:00
CHUNSIK KIM
1
Reputation point
commented 2025-02-18T05:45:43.2133333+00:00
Vijayalaxmi Kattimani
1,480
Reputation points Microsoft Vendor
2 answers
Cannot drop admin role which is role grantor because the role grantor cannot be changed.
When I create new role/group in Azure Database for PostgreSQL flexible server 16 under a workload identity admin (admin_wi) and grant the role to another user CREATE ROLE testrole; GRANT testrole TO azure_pg_admin WITH ADMIN OPTION; the role details…
asked 2024-09-25T13:00:52.2566667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(297.6, 79%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETK%3C/text%3E%3C/svg%3E)
Tomáš Krečmer
30
Reputation points
commented 2025-02-17T16:57:49.7966667+00:00
Dhivyagrace Godwin
0
Reputation points
0 answers
How to make sure azure postgresql db data is wiped following NIST-800-88 standards
How do we make sure that the data in our db is wiped according to these standards, both manually and in backups which are deleted?
Azure Database for PostgreSQL
Azure Database for PostgreSQL
An Azure managed PostgreSQL database service for app development and deployment.
1,207 questions
Azure Startups
Azure Startups
Azure: A cloud computing platform and infrastructure for building, deploying and managing applications and services through a worldwide network of Microsoft-managed datacenters.Startups: Companies that are in their initial stages of business and typically developing a business model and seeking financing.
591 questions
asked 2025-02-12T16:49:52.8233333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(140.8, 53%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBR%3C/text%3E%3C/svg%3E)
Benjamin Rosand
0
Reputation points
commented 2025-02-17T00:51:26.5533333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(249.60000000000002, 51%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAP%3C/text%3E%3C/svg%3E)
Adithya Prasad K
5
Reputation points Microsoft Vendor