Azure Database for PostgreSQL
An Azure managed PostgreSQL database service for app development and deployment.
961 questions
2 answers
How to enable Backvault option to PostgreSQL Azure Flexible server.
How to enable Backvault option to PostgreSQL Azure Flexible server.
asked 2023-05-31T13:08:51.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(300.8, 41%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAB%3C/text%3E%3C/svg%3E)
Arjun Bangaru
0
Reputation points
commented 2024-07-24T06:07:09.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(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,481
Reputation points Microsoft Employee
2 answers
After deleting a postgres flexible server the name is still taken
After deleting a postgres flexible server, the server name remains unusable. The name is specific enough to assume no one else is using this name. The server was setup in a Vnet thus creating an automatic private dns zone record. There might be a hint to…
asked 2024-07-16T08:22:34.9833333+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, 79%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJB%3C/text%3E%3C/svg%3E)
Jerome Bollinger
0
Reputation points
edited an answer 2024-07-24T05:02:25.28+00:00
ShaktiSingh-MSFT
14,481
Reputation points Microsoft Employee
1 answer
One of the answers was accepted by the question author.
Can not manage roles in v16 that where created in v15
(There are already some similar questions, but none of them provide an answer.) We have a Postgresql Flexible Server v16, upgraded from v15. We have the admin role "admin" with the azure_pg_admin role, and a large amount of roles created by…
![](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, 57.99999999999999%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ED%3C/text%3E%3C/svg%3E)
2 answers
Azure data studio with postgres cannot connect to server
I am trying to connect to azure data studio to a postgresql database on azure, and the liading spinner loads forever (even for more than a day). This seems wierd to me because I was able to connect without any issues a few days ago using the same…
asked 2022-07-24T05:21:27.643+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(102.4, 4%, 19%)' 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)
נימרוד ונדר
1
Reputation point
answered 2024-07-23T21:05:53.2333333+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, 20%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EE%3C/text%3E%3C/svg%3E)
ericOnline
21
Reputation points
1 answer
Need to know ETA of reservations support for V5 instance series of Azure Database for PostgreSQL flexible server.
We need to know ETA of reservations support for V5 instance series of Azure Database for PostgreSQL flexible server, as we're thinking to upgrading all of our servers to V5 along with taking benefit of reservations for it.
asked 2023-10-02T13:46:13.6666667+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(147.20000000000002, 99%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENC%3C/text%3E%3C/svg%3E)
Nayan Chhabhaiya
10
Reputation points
commented 2024-07-23T15:21:06.4733333+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(246.4, 43%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPF%3C/text%3E%3C/svg%3E)
Pimentel, Frederico
0
Reputation points
1 answer
"Specified server name is already used" when re-creating deleted PostgreSQL flexible server
Hi, Today I've created and deleted a PostreSQL flexible server a couple of times (using the Azure CLI). When I now try to recreate the server I keep receiving the message "Specified server name is already used". However, it doesn't show up…
asked 2024-07-23T12:02:10.8266667+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, 47%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVD%3C/text%3E%3C/svg%3E)
Ven, Dirk
0
Reputation points
answered 2024-07-23T12:50:22.24+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(291.2, 38%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMP%3C/text%3E%3C/svg%3E)
Marcin Policht
18,420
Reputation points MVP
2 answers
Azure for Students Subscription - Unable to create Azure Database for MySQL Flexible Server
I have been attempting to create a Azure Database for MySQL Flexible Server for my assignment but I am unable to do so due to the below error. I have tried multiple regions but I am unable to get a successful deployment. "code":…
asked 2024-07-01T17:50:31.62+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, 6%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMZ%3C/text%3E%3C/svg%3E)
Miguel Zepeda
0
Reputation points
edited the question 2024-07-22T21:38:16.1+00:00
Oury Ba-MSFT
18,026
Reputation points Microsoft Employee
1 answer
Ability to grant admin user ADMIN option in Azure PostgreSQL Flexible Server version 16
I have created a new flexible server at version 16 with 2 admins: Postgres admin called "adminuser" Microsoft Entra admin called "entraadmin" (visible at Security - Authentication on portal) My use case is to transfer ownership…
asked 2024-06-26T23:13:59.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(12.8, 25%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EYT%3C/text%3E%3C/svg%3E)
Yichen Tian
0
Reputation points
commented 2024-07-22T14:32:33.6266667+00:00
Serpa
151
Reputation points
3 answers
Why I can not create WEB App + Database
I can not create Azure WEB APP + Database. I am trying to create Django backed with PostgresSQL with the following parameters: Region UK West Python 3.10 PosgresSQL - Fixable Server (recommended) Azure Cache for Redis - NO Hosting plan - Standart…
asked 2024-04-10T14:26:01.65+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' %3EMH%3C/text%3E%3C/svg%3E)
Mane Hambardzumyan
0
Reputation points
answered 2024-07-20T23:04:32.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(48, 30%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EZY%3C/text%3E%3C/svg%3E)
Zuzhao Ye
0
Reputation points
0 answers
Issue Restoring Backup from Azure Database for PostgreSQL to VM Deployed PostgreSQL
Hello, I've encountered an issue while attempting to restore a backup from an Azure Database for PostgreSQL to a PostgreSQL instance deployed on a VM. Details: Source: Azure Database for PostgreSQL Version: PostgreSQL 14.11 on x86_64-pc-linux-gnu,…
Azure Database for PostgreSQL
Azure Database for PostgreSQL
An Azure managed PostgreSQL database service for app development and deployment.
961 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.
240 questions
asked 2024-07-10T14:19:52.3766667+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, 66%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDK%3C/text%3E%3C/svg%3E)
Dhaval Kedaria
0
Reputation points
commented 2024-07-19T15:36:36.2233333+00:00
GeethaThatipatri-MSFT
29,017
Reputation points Microsoft Employee
1 answer
Postgres Flexible Server - Segmentation Fault
We have a small database running on Azure Postgres Flexible Server. Since May 30th of 2024, we've been running into Segmentation Fault Whenever a particular procedure is called, which has a Temporary table involved When I use a base table instead, it…
asked 2024-07-16T18:48:21.5833333+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, 81%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAR%3C/text%3E%3C/svg%3E)
Anil Raghavan
10
Reputation points
commented 2024-07-19T05:12:02.1633333+00:00
ShaktiSingh-MSFT
14,481
Reputation points Microsoft Employee
2 answers
pg_stat_statements Extension issue in Azure Database for PostgreSQL flexible server
pg_stat_statements extension is enabled in Azure Database for PostgreSQL flexible server, but when I run the command select * from pg_stat_statements it is giving ERROR: relation "pg_stat_statements" does not exist
asked 2024-07-02T16:04:24.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(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-07-15T17:36:27.6733333+00:00
GeethaThatipatri-MSFT
29,017
Reputation points Microsoft Employee
2 answers
How to Shrink Azure Postgres Flexible Storage With Minimal Downtime
Could you help me shrink the storage of an Azure PostgreSQL Flexible Server from 2000GB to a more appropriate because used space is only 300GB? The issue was occurred when the database on auto-grow and the storage consumption suddenly increased from…
asked 2024-07-12T13:13:58.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(6.4, 28.000000000000004%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESS%3C/text%3E%3C/svg%3E)
Sachin Soam
0
Reputation points
commented 2024-07-15T15:58:09.6366667+00:00
Oury Ba-MSFT
18,026
Reputation points Microsoft Employee
1 answer
One of the answers was accepted by the question author.
Azure PostgreSQL flexible server stuck in restart state
I tried to restart my Azure Database for PostgresSQL flexible server now more than two days ago and it is still stuck in the restarting status. I initiated the restart because it wouldn't show me the list of databases so I could manually connect to them…
asked 2024-07-15T10:30:47.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(166.4, 54%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJM%3C/text%3E%3C/svg%3E)
Jespersen, Martin Closter
20
Reputation points
accepted 2024-07-15T10:58:21.8+00:00
Jespersen, Martin Closter
20
Reputation points
1 answer
error fetching from postgres, err: x509: certificate signed by unknown authority
i have i virtual network where in 1 subnet my aks cluster is present and another subnet my private postgress flexible server is present. i am connecting my application from aks cluster to private postgress server through private network using…
asked 2024-07-05T07:21:57.52+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(265.6, 51%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EK%3C/text%3E%3C/svg%3E)
Kishor
0
Reputation points
commented 2024-07-12T06:47:28.5833333+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, 79%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3END%3C/text%3E%3C/svg%3E)
Nikhil Duserla
1,300
Reputation points Microsoft Vendor
1 answer
How do I migrate a PostgreSQL database from Single Server to Flex Server, change the users to Entra authenticated, and then migrate the database again without users?
I want to migrate a PostgreSQL database from Azure Single Server to Azure Flex Server. Then drop all database users from the Azure Flex Server database and add them back in as Entra authenticated users and set their permissions. Then I want to script…
asked 2024-07-09T12:55:41.2066667+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(217.60000000000002, 47%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDW%3C/text%3E%3C/svg%3E)
Daryl Williams
0
Reputation points
answered 2024-07-11T09:24:09.8966667+00:00
ShaktiSingh-MSFT
14,481
Reputation points Microsoft Employee
1 answer
Postgre-SQL Flexible Server - pg_cron permissions and alternative
Hi everyone, a customer is using Azure PGSQL Flexible server to provide database managed services for its internal customers. The internal customers are used to work on-prem with job schedulers like pg__cron or pg__timetable. After migrating their…
asked 2024-07-04T07:36:43.75+00:00
Paul Hernandez
631
Reputation points Microsoft Employee
answered 2024-07-11T09:05:34.2633333+00:00
ShaktiSingh-MSFT
14,481
Reputation points Microsoft Employee
1 answer
My Azure Server Admin has CreateRole rights disabled for Azure Database for Postgresql Flexible server
In the Azure Database for Postgresql, Recently the CreateRole rights have been revoked for the Server Admin user. Due to this, I am not able to create new users or roles in the system. Please help me to enable the create role access for the Azure Server…
asked 2024-07-11T05:01:20.0633333+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, 98%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENH%3C/text%3E%3C/svg%3E)
Nathar Hussain
0
Reputation points
answered 2024-07-11T08:54:58.3466667+00:00
ShaktiSingh-MSFT
14,481
Reputation points Microsoft Employee
1 answer
Azure postgresql flex can i use local AD group synced to Azure AD for access to DB
Azure postgresql flex can i use local AD group synced to Azure AD for access to DB in Azure flex postgres
asked 2024-07-05T19:58:41.36+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, 91%, 21%)' 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)
Mohammed, Shafi
0
Reputation points
commented 2024-07-10T20:00:59.1133333+00:00
Oury Ba-MSFT
18,026
Reputation points Microsoft Employee
0 answers
Cannot connect to Azure DB for PostgresSQL flexible from different vnet
Hi, we cannot connect from an AKS pod running in one VNET to an Azure DB for PostgreSQL flexible server running in a different VNET. We can connect from an AKS pod running in the same VNET. The error is demonstrated by running curl from the pod: curl -v…
asked 2024-07-09T15:20:24.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(185.6, 84%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EWA%3C/text%3E%3C/svg%3E)
Wilde, Andrew
0
Reputation points
commented 2024-07-10T18:50:34.8566667+00:00
Oury Ba-MSFT
18,026
Reputation points Microsoft Employee