Azure Database for PostgreSQL
An Azure managed PostgreSQL database service for app development and deployment.
1,202 questions
0 answers
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
asked 2025-02-18T22:20:07.63+00:00
Dhivyagrace Godwin
0
Reputation points
0 answers
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
0
Reputation points
edited a comment 2025-02-18T21:40:15.42+00:00
Sai Vihari
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' %3ETC%3C/text%3E%3C/svg%3E)
T C B
40
Reputation points Microsoft Vendor
commented 2025-02-18T19:44:58.5+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
0
Reputation points Microsoft Vendor
1 answer
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
0
Reputation points
answered 2025-02-18T14:19:51.06+00:00
Vinodh247
28,136
Reputation points MVP
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
edited a comment 2025-02-18T10:40:51.0466667+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
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-18T09:44:55.2266667+00:00
Kanhaiya Sharma
0
Reputation points
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-18T09:17:11.23+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,330
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
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,330
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
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-17T16:28:49.65+00:00
August Admin
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,202 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.
586 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
0
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
0
Reputation points
commented 2025-02-17T00:34:05.8+00:00
William Kelly
0
Reputation points
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-14T17:48:35.5566667+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
1 answer
azure PostgreSQL flexible server upgrades
we are planning to upgrade my postgresql 13 to 15. in my application is using jdbc. witch is the sutable jar ersion to use the postgresql 15 server.
asked 2025-02-10T14:35:49.09+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(288, 27%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDJ%3C/text%3E%3C/svg%3E)
Dhanushkumar J
0
Reputation points
commented 2025-02-13T07:29:00.4833333+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, 46%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENN%3C/text%3E%3C/svg%3E)
NIKHILA NETHIKUNTA
4,510
Reputation points Microsoft Vendor
2 answers
Creating a Leaderboard with Stored Procedures in an API Application
How can a leaderboard be implemented for an application that uses an API, including creating the necessary stored procedures? I am new to this technology but have some understanding of data access using ADO.NET. What steps can be taken to achieve this?
Azure Database for PostgreSQL
Azure Database for PostgreSQL
An Azure managed PostgreSQL database service for app development and deployment.
1,202 questions
C#
C#
An object-oriented and type-safe programming language that has its roots in the C family of languages and includes support for component-oriented programming.
11,306 questions
ASP.NET API
ASP.NET API
ASP.NET: A set of technologies in the .NET Framework for building web applications and XML web services.API: A software intermediary that allows two applications to interact with each other.
375 questions
asked 2025-02-08T19:15:28.0833333+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(92.8, 0%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESW%3C/text%3E%3C/svg%3E)
Suraj Wakure
0
Reputation points
commented 2025-02-12T12:56:50.0866667+00:00
Mahesh Kurva
2,750
Reputation points Microsoft Vendor
1 answer
How to Sync Azure Postgres from one instance to other instance
Hello Everyone, My requirement, we have Managed Azure PostgreSQL instance running in Prod and we want to replicate the Dev PostgreSQL every day might, through Azure Function, how than be accomplished. I want to use Python for achieving this, any help is…
asked 2025-01-28T03:41:08.23+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, 76%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENJ%3C/text%3E%3C/svg%3E)
Niranjan Jannapureddy
0
Reputation points
edited the question 2025-02-11T20:08:37.0633333+00:00
Ryan Hill
29,671
Reputation points Microsoft Employee
2 answers
The server is currently in 'disabled' state.
Our PostgreSQL server/VM is in a 'disabled' state. because the spending limit in the subscription has been reached. After increasing the limit, all other VMs were re-enabled except the database server. I have tried to resolve this with Azure paid…
asked 2025-01-10T11:08:34.3666667+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(99.2, 53%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECS%3C/text%3E%3C/svg%3E)
Christian Schmittel
0
Reputation points
commented 2025-02-11T07:07:36.63+00:00
Vijayalaxmi Kattimani
1,330
Reputation points Microsoft Vendor
1 answer
Azure Database for PostgreSQL Single Server Metric Data Not Available
Hi, Our Azure Database for PostgreSQL single server resource metric data is not available now. This happen started to 21:03, Fab 05 UTC . Resource status is running. Just metric data is not available. What happen?? is it relate retirement Azure Database…
asked 2025-02-06T00:38:53.81+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(284.8, 94%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
황이 노
0
Reputation points
commented 2025-02-10T05:01:53.9133333+00:00
Vijayalaxmi Kattimani
1,330
Reputation points Microsoft Vendor
0 answers
Postgres Flexible Server Unavailable Due To Schedule Maintence Stuck For Hours
Our postgresql flexible server has been hanging on schedule maintence for several hours now leaving our databases unavailable. This is currently affecting our production environment and we've yet to be able to resolve it. We've attempted to restart…
asked 2025-02-05T19:57:28.8366667+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(208, 32%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EFC%3C/text%3E%3C/svg%3E)
Fitzgerald Callender
0
Reputation points
commented 2025-02-07T11:52:33.4566667+00:00
PratikLad
80
Reputation points Microsoft Vendor