Azure Database for PostgreSQL
An Azure managed PostgreSQL database service for app development and deployment.
857 questions
2 answers
Azure database for PostgreSQL Flexible Server - RPO
Hi, Propose to use Azure database for PostgreSQL Flexi Server (HA+ Read Replica) for our one of the business-critical application. I have gone through the article.…
asked 2024-03-12T16:20:43.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(32, 37%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMT%3C/text%3E%3C/svg%3E)
Maheswaran T
0
Reputation points
answered 2024-04-25T11:28:45.2166667+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, 68%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAK%3C/text%3E%3C/svg%3E)
Alicja Kucharczyk
180
Reputation points Microsoft Employee
0 answers
Setting up trigger using SUPERUSER on Azure Database for PostgreSQL - Flexible Server
I manage a PostgreSQL database for my organisation which is set up on an Azure Database for PostgreSQL - Flexible Server. My issue is that other users need to be able to CREATE objects in the database, however when they do that they are automatically…
![](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, 91%, 36%)' 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)
1 answer
One of the answers was accepted by the question author.
Why does filled disk space not release immediatly (only during night) after dropping partitions of a table from Postgres database in Azure server?
I am making some experiments with partitions. I inserted about 20GB of data into a table with partitions, then I dropped the partitions. I wanted to check how fast I could insert data into the table and drop its partitions to release space in the disk to…
asked 2024-04-23T09:04:56.3566667+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(268.8, 59%, 36%)' 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)
Diogo dos Santos
20
Reputation points
accepted 2024-04-25T10:49:12.7966667+00:00
Diogo dos Santos
20
Reputation points
1 answer
Azure Postgresql Flexi instance - How to check the table creation date and time
HI Can someone help me to find the tables/objects create date/time in Azure postgresql flexi instance ? we used to use this one , select * from pg_stat_file( pg_relation_filepath('alert') ) in on-prem but that's not working in azure with admin user due…
asked 2024-04-24T02:29:38.51+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
20
Reputation points
commented 2024-04-25T06:28:28.66+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
13,271
Reputation points Microsoft Employee
1 answer
Connect from python Function app with managed identity to Azure Database for PostgreSQL- Flexible Server
Hi Everyone I have a python function app which is connecting to PostgreSQL- Flexible Server. I have used password authentication to connect the server. Now, I have to use managed identity to connect the server. I came across 2 different and not sure…
![](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, 35%, 34%)' 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)
0 answers
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
commented 2024-04-25T04:59:38.9866667+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
5,730
Reputation points Microsoft Vendor
1 answer
How can I check what database level permissions are assigned to an azure ad security group in Azure postgres flexible server?
I have an azure database flexible server instance and created a role using SELECT * FROM pgaadauth_create_principal('azure ad security group name', false, false) and assigned permissions read, write permissions to it to a database. Now I want to list out…
asked 2024-04-22T17:43:07.6366667+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(12.8, 28.000000000000004%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3E3%3C/text%3E%3C/svg%3E)
36226516
0
Reputation points
commented 2024-04-25T00:02:32.3533333+00:00
Oury Ba-MSFT
16,081
Reputation points Microsoft Employee
1 answer
Availability zone became unavailable, how can I switch?
We deployed an Azure Database for PostgreSQL flexible server several months ago in West Europe with availability zone 1. A few weeks ago we started getting these message during automated deployments: Availability zone '1' is not available for…
asked 2024-04-24T11:15:14.0166667+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
commented 2024-04-24T13:15:59.3366667+00:00
ShaktiSingh-MSFT
13,271
Reputation points Microsoft Employee
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
Sven Bretschneider
0
Reputation points
edited a comment 2024-04-24T13:13:38.5466667+00:00
ShaktiSingh-MSFT
13,271
Reputation points Microsoft Employee
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
subhash-DBA
20
Reputation points
accepted 2024-04-24T01:40:35.7133333+00:00
subhash-DBA
20
Reputation points
1 answer
permission denied for schema _timescaledb_internal on Azure PostgreSQL flexible server
I tried to migrate db from Azure PostgreSQL single server to flexible server using migration tool from Azure portal. But there is an error on validation check because migration tool doesn't support timescaledb extension. Portal message said that…
asked 2024-04-17T11:08:26.95+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, 21%, 23%)' 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)
Michiteru Sugitani
50
Reputation points
commented 2024-04-23T02:24:33.69+00:00
Michiteru Sugitani
50
Reputation points
0 answers
The recommended certificate didn't work on Azure Database for PostgreSQL Single server in China east 2 region
Hi, I have a question about the Azure Database for PostgreSQL - Single Server (located in China East 2). We recently noticed that there is a warning message in the Azure portal, which is "As a part of routine certificate rotation, the root…
asked 2024-04-18T15:24:54.75+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(64, 87%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EXL%3C/text%3E%3C/svg%3E)
Xiaoyun Liao
40
Reputation points
commented 2024-04-22T22:22:50.57+00:00
Oury Ba-MSFT
16,081
Reputation points Microsoft Employee
0 answers
Postgresql flexible server on azure unplanned failover is not working in a Zoneredundant HA environment.
Hi all, On Azure we have a PostgreSQL-Server with Zone-redundant HA. When we trigger a forced Failover, the Server goes in the "Updating state" and that is the only information which we see about PostgreSQL flexible server on Azure. How we can…
asked 2024-04-22T14:27:14.8433333+00:00
Serkan Aytekin
0
Reputation points
commented 2024-04-22T15:30:10.35+00:00
Serkan Aytekin
0
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
0
Reputation points
answered 2024-04-22T14:06:29.78+00:00
GeethaThatipatri-MSFT
27,102
Reputation points Microsoft Employee
3 answers
One of the answers was accepted by the question author.
Why are Reservations not available for Ddsv5 instances on Azure PostgreSQL Flexible Server?
I'm calculating the cost of Azure PostgreSQL Flexible Server which uses Ddsv5 instance and notice that Reservations for this series and Dadsv5 instances are not available. Is there an explanation for this? Reservations are available for the older Ddsv4…
asked 2023-08-11T08:12:39.71+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, 5%, 25%)' 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)
Pitawat
331
Reputation points
commented 2024-04-22T10:08:04.14+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, 0%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMA%3C/text%3E%3C/svg%3E)
Marco Araujo
0
Reputation points
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
65
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
6
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
13,271
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
27,102
Reputation points Microsoft Employee
2 answers
Azure Postgresql how to create a CAST
Hello, I am currently in the process of configuring a database within Azure Database for PostgreSQL flexible server. However when i try to create two CAST objects i get the following error: ERROR: must be owner of type integer or type…
asked 2023-09-20T14:27:04.6333333+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(134.4, 80%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELV%3C/text%3E%3C/svg%3E)
Laurens van der Stoep (NL)
35
Reputation points
answered 2024-04-19T16:19:59.39+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(281.6, 12%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJA%3C/text%3E%3C/svg%3E)
Javier Andres Veliz Miranda
0
Reputation points
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
18,191
Reputation points Microsoft Employee