Azure Database for PostgreSQL
An Azure managed PostgreSQL database service for app development and deployment.
930 questions
2 answers
Availability zone became unavailable, how can I switch?
We deployed an Azure Database for PostgreSQL flexible server several months ago. A few weeks ago we started getting these messages during automated deployments: Availability zone '1' is not available for subscription '{subscriptionId}' in this region…
asked 2024-04-24T11:20:14.1966667+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, 97%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESB%3C/text%3E%3C/svg%3E)
Sven Bretschneider
0
Reputation points
edited a comment 2024-04-24T13:13:38.5466667+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
14,276
Reputation points Microsoft Employee
1 answer
Issue with connecting ADF to PostgreSQL
Hey, We are building our data factory on Azure and we are trying to connect a new dataset from PostgreSQL source. We took the CRT files and generated a PFX file from it, we import it into azure key vault. Then we went ahead and created the dataset, we…
asked 2024-04-24T06:20:25.3633333+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(131.20000000000002, 24%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EIC%3C/text%3E%3C/svg%3E)
Igal Cohen | CMTrading
0
Reputation points
answered 2024-04-24T06:50:39.2133333+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, 61%, 37%)' 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)
phemanth
8,080
Reputation points Microsoft Vendor
1 answer
One of the answers was accepted by the question author.
How do I pg_dump/pg_dumpall from Azure postgres Flexi to azure files/storage?
HI All, We are in the process of designing a new monitoring platform in Azure which Azure Postgresql Flexi server. From database support/operation perspective can some one help me to understand the following. I am new to Azure How do we use…
asked 2024-04-11T01:47:37.97+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, 85%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESD%3C/text%3E%3C/svg%3E)
subhash-DBA
45
Reputation points
accepted 2024-04-24T01:40:35.7133333+00:00
subhash-DBA
45
Reputation points
1 answer
Getting permission issue for pg_signal_backend in postgre16 in azure flexible server
Hi,We recently commisioned a new flexible server using latest postgresql 16 and at the same time created an Microsoft entra administrator for our server.After that we created a database 'Test' using our Microsoft entra administrator.Then when we intended…
asked 2024-04-22T13:28:02.0766667+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(156.8, 73%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESJ%3C/text%3E%3C/svg%3E)
Saksham Joshi
5
Reputation points
answered 2024-04-22T14:06:29.78+00:00
GeethaThatipatri-MSFT
29,007
Reputation points Microsoft Employee
3 answers
Certificates do not conform to algorithm
I am trying to deploy an application that uses PostgreSQL as database. (The application is Keycloak). I have tried deploying it using Azure postgres single server and Azure postgres flexible server. I would prefer to deploy it using flexible server as it…
asked 2023-04-06T11:54:46.88+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(307.2, 66%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EH%3C/text%3E%3C/svg%3E)
Hedgelot
70
Reputation points
answered 2024-04-22T07:17:26.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(220.8, 7.000000000000001%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJG%3C/text%3E%3C/svg%3E)
Julian Gimbel
11
Reputation points Microsoft Employee
1 answer
Postgres Parameter Missing from Parameter List.
I am using Cosmos DB for Postgresql, with 2 worker node + 1 coordinator node. I want to set max_locks_per_transaction parameter for postgresql. I have a partioned table which I then sharded with Citus command, but I am unable to unshard, because I am…
asked 2024-04-18T10:33:49.4066667+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(80, 56.00000000000001%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVA%3C/text%3E%3C/svg%3E)
Vishnu Agarwal
0
Reputation points
commented 2024-04-22T03:44:40.38+00:00
ShaktiSingh-MSFT
14,276
Reputation points Microsoft Employee
1 answer
Need Consistency levels in Azure Cosmos DB for Postgresql (like in NoSQL)
Hi, I came across with a data inconsistency in my Citus cluster, when I did classic money transfer test: init.sql: create table mytbl (id serial primary key, amount int); insert into mytbl(amount) select 0 from generate_series(1, 1234567); select…
asked 2024-04-17T14:14:28.9133333+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, 76%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKM%3C/text%3E%3C/svg%3E)
Konstantin Morozov
0
Reputation points
edited the question 2024-04-21T00:28:08.8466667+00:00
GeethaThatipatri-MSFT
29,007
Reputation points Microsoft Employee
1 answer
I was charged for an unused service and my student account has been disabled a
Hello, I was using the Azure for Students subscription to deploy my Python (Flask) web app as my personal project for learning, and I have created App Service with the MySQL database. I couldn't get it to work so I've abandoned the project, disabling the…
asked 2024-04-18T13:17:46.2933333+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(128, 5%, 22%)' 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)
Tomasz Kalus (tomakal079)
0
Reputation points
edited the question 2024-04-19T09:38:09.5033333+00:00
VenkateshDodda-MSFT
19,631
Reputation points Microsoft Employee
2 answers
AZURE - General Data Protection Regulation (GDPR)
Hello everyone... in MS Azure is there a BAA document to download that specifies that they comply with the European GDPR regulations? We may have European clients and they will most likely ask us if our system complies with the standard. If that is the…
asked 2024-04-11T13:40:45.42+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(310.4, 18%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESP%3C/text%3E%3C/svg%3E)
Sebastian Pacheco
181
Reputation points
commented 2024-04-17T00:43:12.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(60.8, 4%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKM%3C/text%3E%3C/svg%3E)
kobulloc-MSFT
25,731
Reputation points Microsoft Employee
2 answers
Connection Data Base for PostgreSQL flexible server
Hello everyone... is there any way to create an internal connection between the pods of my AKS cluster and the DB? In the single server version I seem to remember that there was a private endpoint. At this moment I am reading something from…
asked 2024-04-03T16:17:50.22+00:00
Sebastian Pacheco
181
Reputation points
commented 2024-04-17T00:42:03.0766667+00:00
kobulloc-MSFT
25,731
Reputation points Microsoft Employee
1 answer
Unable to upgrade postgres version 15 to 16
Hi, I'm trying to upgrade postgres version 15 to 16 but it comes with an error message: { "code": "InternalServerError", "message": "An unexpected error occured while processing the request. Tracking ID:…
asked 2024-04-10T21:24:25.7+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(19.2, 97%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETV%3C/text%3E%3C/svg%3E)
TIen Vo
5
Reputation points
commented 2024-04-16T12:25:39.5766667+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(163.2, 63%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPA%3C/text%3E%3C/svg%3E)
Pankaj Awaghad
0
Reputation points
1 answer
How to see auto_explain output in TEXT format in Azure Database for PostgreSQL flexible server
How to see auto_explain output in TEXT format in Azure Database for PostgreSQL flexible server?
asked 2024-04-14T17:06:16.3866667+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(25.6, 86%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENK%3C/text%3E%3C/svg%3E)
Naveen Kumar Kakarla (Quadrant Resource)
201
Reputation points
commented 2024-04-16T09:56:28.65+00:00
Vinodh247
12,741
Reputation points
1 answer
Got a mail saying: Action Required for Azure Database for PostgreSQL – Flexible Server to update your trusted root store, if you are doing certificate pinning
I just got this in the mail, our applications are asp .net core microservices, we just connect using the basic configurations in appsettings.json. What impact does this update will have in our current setup…
asked 2024-04-16T04:13:00.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(115.19999999999999, 95%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ES%3C/text%3E%3C/svg%3E)
Saurav
20
Reputation points
commented 2024-04-16T06:08:08.1266667+00:00
ShaktiSingh-MSFT
14,276
Reputation points Microsoft Employee
1 answer
Connecting to Azure Database for PostgreSQL using Azure AD
we are trying to connect to azure postgres DB using AD & followed the instructions provided in the below documentation url https://video2.skills-academy.com/en-us/azure/postgresql/howto-configure-sign-in-aad-authentication Getting below error while…
asked 2020-11-11T06:50:39.733+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(121.6, 2%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ER%3C/text%3E%3C/svg%3E)
RamZ
1
Reputation point
answered 2024-04-15T11:24:40.31+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(105.60000000000001, 54%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAC%3C/text%3E%3C/svg%3E)
Armando Cordova
5
Reputation points
0 answers
The Azure Database for PostgreSQL -flexible server metric connections_failed doesn't always have a value
Hello everyone, I have faced an issue regarding Azure Database for PostgreSQL -flexible server metrics, which I hoped someone here can help me solve it. I have an Azure Database for PostgreSQL - flexible server, which has an alert configured on it, so I…
asked 2024-03-11T11:51:20.82+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(214.4, 82%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EZK%3C/text%3E%3C/svg%3E)
Zeinab Khosravi
40
Reputation points
commented 2024-04-11T23:51:19.0066667+00:00
GeethaThatipatri-MSFT
29,007
Reputation points Microsoft Employee
1 answer
Azure Postgres Flexible server: Unable to add azure_storage extension
We are unable to add a the azure_storage extension to a second database. We got it to work on the default postgres database but when trying to add it to a second database with CREATE EXTENSION azure_storage; We get role "azure_storage_admin"…
asked 2024-04-10T15:10:44.06+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(243.2, 26%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPK%3C/text%3E%3C/svg%3E)
Peter Koller
40
Reputation points
answered 2024-04-10T20:44:48.5366667+00:00
GeethaThatipatri-MSFT
29,007
Reputation points Microsoft Employee
1 answer
– “FATAL: ERROR: could not extend file "base/24834/32917": No space left on device
while copying data via ora2pg getting below error message. Please suggest where space need to be added. – “FATAL: ERROR: could not extend file "base/24834/32917": No space left on device
asked 2024-04-10T01:17:54.12+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(80, 45%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EIM%3C/text%3E%3C/svg%3E)
IQBAL, MOHAMMAD
5
Reputation points
answered 2024-04-10T04:27:34.31+00:00
ShaktiSingh-MSFT
14,276
Reputation points Microsoft Employee
2 answers
Postgres HA - zone redundant availability Southeast Asia
Based on the following article https://video2.skills-academy.com/en-us/azure/postgresql/flexible-server/overview#azure-regions the Azure Database for PostgreSQL - Flexible Server in Southeast Asia has a capability of Zone Redundant HA, however when i created…
asked 2024-04-08T03:06:59.1966667+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, 19%, 34%)' 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)
Ricky Kusuma
5
Reputation points
answered 2024-04-08T08:03:46.1166667+00:00
ShaktiSingh-MSFT
14,276
Reputation points Microsoft Employee
4 answers
Problem with pg_dumpall in PostgreSQL Flexible Server
I have an Azure Database for PostgreSQL flexible server (version 12). I'm trying to upgrade using the official docs (the goal is to upgrade to 14). The first step is to dump the roles pg_dumpall -r --host=mySourceServer --port=5432 --username=myUser…
asked 2023-02-10T02:16:00.56+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(224.00000000000003, 44%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAD%3C/text%3E%3C/svg%3E)
Artur Drobinskiy
0
Reputation points
edited a comment 2024-04-05T07:34:07.2266667+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(160, 10%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAM%3C/text%3E%3C/svg%3E)
Azeem, Muhammad
10
Reputation points
1 answer
One of the answers was accepted by the question author.
Is Azure Postgresql Flex server HIPAA COMPLIANT
I want to if Is Azure Postgresql Flex server HIPAA COMPLIANT that I am using to build Datawarehouse.
asked 2024-02-15T18:17:01.92+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, 81%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGJ%3C/text%3E%3C/svg%3E)
Grover, Jyoti
40
Reputation points
accepted 2024-04-04T14:59:50.2166667+00:00
Grover, Jyoti
40
Reputation points