Azure Database for PostgreSQL
An Azure managed PostgreSQL database service for app development and deployment.
953 questions
1 answer
Issues with Assigning AD Admin Account on Azure PostgreSQL Flexible Servers
Hello, We are encountering multiple issues with assigning other admins using an Azure AD admin account on Azure PostgreSQL Flexible Servers. Case 1: Upgraded Instances We recently upgraded our PostgreSQL instances from version 14 to 15, and then to 16.…
asked 2024-07-23T16:34:29.1433333+00:00
Serpa
151
Reputation points
commented 2024-07-25T07:18:42.43+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,406
Reputation points Microsoft Employee
0 answers
How to get IP range for port opening in order to access azure flexible DB server in office firewall?
Need to access azure flexible postgre DB server from office firewall. For same need IP range for all machines in US EAST zone.
asked 2024-07-25T05:33:26.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(102.4, 30%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVM%3C/text%3E%3C/svg%3E)
Vivek Mistry
0
Reputation points
asked 2024-07-25T05:33:26.6466667+00:00
Vivek Mistry
0
Reputation points
1 answer
Azure Database for PostgreSQL Error: connection failed: could not receive data from server
When trying to connect Azure Data Studio to an Azure Database for Postgresql flexible server, I receive the error: connection failed: could not receive data from server: Socket is not connected (0x00002749/10057) could not send SSL negotiation packet:…
asked 2024-07-23T21:29:30.86+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
commented 2024-07-25T04:58:14.3266667+00:00
ShaktiSingh-MSFT
14,406
Reputation points Microsoft Employee
0 answers
How to connect and query with MySQL server using Azure Machine Learning
Hi, I am currently working on a project where I need to connect to an Azure Database for MySQL using Azure Machine Learning (AML) and Python scripts. However, I want to use AML resources such as Datastore and Dataset for the connection rather than…
![](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(272, 33%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETN%3C/text%3E%3C/svg%3E)
![](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(89.60000000000001, 78%, 18%)' 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)
1 answer
How to geo-restore a private postgres flexible server having private endpoints
Dear community, I have a Postgres Flexible Server with the following characteristics: Public access is disabled A private endpoint has been deployed in a VNet (so it's not a VNet Integration as we used to do until recently) simple availability …
asked 2024-07-23T14:45:44.4566667+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, 0%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJ%3C/text%3E%3C/svg%3E)
JPR
0
Reputation points
commented 2024-07-24T22:49:42.46+00:00
Oury Ba-MSFT
18,021
Reputation points Microsoft Employee
1 answer
postgresql - azuresu wrong backend_type encoding in pg_stat_activity
When I list pg_stat_activity, I see process from azuresu user which has wrong encoded text in backend_type column: select * from pg_stat_activity; datid | datname | pid | leader_pid | usesysid | usename | application_name | client_addr |…
asked 2024-07-23T14:11:19.91+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(112.00000000000001, 4%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGS%3C/text%3E%3C/svg%3E)
Gajzler, Simon
0
Reputation points
commented 2024-07-24T22:24:25.6666667+00:00
Oury Ba-MSFT
18,021
Reputation points Microsoft Employee
0 answers
[Postgres migration] pg_partman ExtensionsValidation error
I'm getting the following error: Error 603405: Unsupported extension(s). The migration service does not support the migration of databases with 'pg_partman' extension(s) on the target server. And I know we have that error listed here. Is there a…
![](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, 4%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EL%3C/text%3E%3C/svg%3E)
4 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
341
Reputation points
commented 2024-07-24T11:13:22.7166667+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(230.39999999999998, 20%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVN%3C/text%3E%3C/svg%3E)
Vanessa Nogueira
0
Reputation points Microsoft Employee
0 answers
Azure Database for PostgreSQL error: FATAL: password authentication failed for user
Hello, For some reason, my Azure Function with System Assigned Managed Identity cannot access my Azure Database for PostgreSQL resource. Error: Failed to create PSQL Client: connection to server at…
asked 2024-07-23T21:38:42.51+00:00
ericOnline
21
Reputation points
commented 2024-07-24T08:55:34.1066667+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(0, 59%, 10%)' 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)
JananiRamesh-MSFT
23,881
Reputation points
2 answers
After Postgresql flexible migration from 14 to 16 admin user can't ALTER other role anymore
Since migrating my flexible server to postgresql version 16 my admin user can't modify roles anymore. With version 16 it's mandatory to have WITH ADMIN OPTION on roles to be able to alter them. My problem is that it wasn't the case on version 14 and my…
asked 2024-05-21T09:38:21.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(259.20000000000005, 44%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDT%3C/text%3E%3C/svg%3E)
Davi, Thomas
0
Reputation points
edited a comment 2024-07-24T08:46:32.17+00:00
Serpa
151
Reputation points
0 answers
Can't login to postgresql database with service principal in Azure security group.
Hi, I'm having a problem with logging to postgresql with service principal. Service principal is the backend web app service principal. Following steps are done to enable login: Azure group with [OID_A] is created and contains one normal user and a…
asked 2024-07-22T13:07:57.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(179.20000000000002, 13%, 27%)' 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)
Teemu Kumpumäki
0
Reputation points
commented 2024-07-24T06:42:07.37+00:00
Teemu Kumpumäki
0
Reputation points
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
ShaktiSingh-MSFT
14,406
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,406
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
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,185
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,021
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