953 questions with Azure Database for PostgreSQL tags

Sort by: Updated
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.…

Azure Database for PostgreSQL
Microsoft Entra ID
Microsoft Entra ID
A Microsoft Entra identity service that provides identity management and access control capabilities. Replaces Azure Active Directory.
20,608 questions
asked 2024-07-23T16:34:29.1433333+00:00
Serpa 151 Reputation points
commented 2024-07-25T07:18:42.43+00:00
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.

Azure Database for PostgreSQL
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:…

Azure Database for PostgreSQL
asked 2024-07-23T21:29:30.86+00:00
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…

Azure Machine Learning
Azure Machine Learning
An Azure machine learning service for building and deploying models.
2,723 questions
Azure Storage Accounts
Azure Storage Accounts
Globally unique resources that provide access to data management services and serve as the parent namespace for the services.
2,939 questions
Azure Database for MySQL
Azure Database for MySQL
An Azure managed MySQL database service for app development and deployment.
765 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
10,180 questions
Azure Database for PostgreSQL
asked 2024-07-23T07:30:11.6466667+00:00
Tú Nguyễn 70 Reputation points
commented 2024-07-25T03:17:57.96+00:00
dupammi 8,035 Reputation points Microsoft Vendor
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 …

Azure Database for PostgreSQL
asked 2024-07-23T14:45:44.4566667+00:00
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 |…

Azure Database for PostgreSQL
asked 2024-07-23T14:11:19.91+00:00
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…

Azure Database Migration service
Azure Database for PostgreSQL
asked 2024-07-23T18:52:16.6466667+00:00
LuisC 20 Reputation points
edited a comment 2024-07-24T15:07:46.2666667+00:00
LuisC 20 Reputation points
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…

Azure Database for PostgreSQL
asked 2023-08-11T08:12:39.71+00:00
Pitawat 341 Reputation points
commented 2024-07-24T11:13:22.7166667+00:00
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…

Azure Database for PostgreSQL
asked 2024-07-23T21:38:42.51+00:00
ericOnline 21 Reputation points
commented 2024-07-24T08:55:34.1066667+00:00
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…

Azure Database for PostgreSQL
asked 2024-05-21T09:38:21.5333333+00:00
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…

Azure Database for PostgreSQL
asked 2024-07-22T13:07:57.58+00:00
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.

Azure Database for PostgreSQL
asked 2023-05-31T13:08:51.8233333+00:00
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…

Azure Database for PostgreSQL
asked 2024-07-16T08:22:34.9833333+00:00
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…

Azure Database for PostgreSQL
asked 2024-07-22T22:05:23.9266667+00:00
Dino 20 Reputation points
edited a comment 2024-07-23T21:21:19.5266667+00:00
Dino 20 Reputation points
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…

Azure Database for PostgreSQL
asked 2022-07-24T05:21:27.643+00:00
נימרוד ונדר 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.

Azure Database for PostgreSQL
asked 2023-10-02T13:46:13.6666667+00:00
Nayan Chhabhaiya 10 Reputation points
commented 2024-07-23T15:21:06.4733333+00:00
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…

Azure Database for PostgreSQL
asked 2024-07-23T12:02:10.8266667+00:00
Ven, Dirk 0 Reputation points
answered 2024-07-23T12:50:22.24+00:00
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":…

Azure Database for PostgreSQL
asked 2024-07-01T17:50:31.62+00:00
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…

Azure Database for PostgreSQL
asked 2024-06-26T23:13:59.75+00:00
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…

Azure Database for PostgreSQL
asked 2024-04-10T14:26:01.65+00:00
Mane Hambardzumyan 0 Reputation points
answered 2024-07-20T23:04:32.23+00:00
Zuzhao Ye 0 Reputation points