Connect and query to Azure database for PostgresSql from Synapse Analytics
Hi, Is there a way to connect and query Azure Database for PostgresSql from Synapse Analytics.We need near real time data from postgres database to join the CosmosDB data in Synapse Analytics. I would really appreciate for the input. Thanks!
Subnet issue while migrating to Postgres flexible server
What are the limitations and solutions when facing subnet issues while migrating to an Azure Database for PostgreSQL flexible server? PS - Based on common issues that we have seen from customers and other sources, we are posting these questions to help…
![](https://techprofile.blob.core.windows.net/images/9CqRWkWyk0WIvV6eSiSD-g.png?8DB6B7)
![](https://techprofile.blob.core.windows.net/images/9CqRWkWyk0WIvV6eSiSD-g.png?8DB6B7)
Resolving Permission Denied Errors for pg_authid During PostgreSQL Migration to Azure Flexible Server
How can I resolve permission denied errors related to pg_authid and other restricted tables when migrating from a single server to an Azure PostgreSQL Flexible Server? PS - Based on common issues that we have seen from customers and other sources, we are…
![](https://techprofile.blob.core.windows.net/images/9CqRWkWyk0WIvV6eSiSD-g.png?8DB6B7)
![](https://techprofile.blob.core.windows.net/images/9CqRWkWyk0WIvV6eSiSD-g.png?8DB6B7)
Azure superuser role granted a select permission to some roles -pg_stat_statements and pg_buffercache
Why are some of my roles assigned to all tables in my databases where the grantor is azure_superuser, and what can be the causes? The tables pg_stat_statements and pg_buffercache PS - Based on common issues that we have seen from customers and other…
![](https://techprofile.blob.core.windows.net/images/9CqRWkWyk0WIvV6eSiSD-g.png?8DB6B7)
![](https://techprofile.blob.core.windows.net/images/9CqRWkWyk0WIvV6eSiSD-g.png?8DB6B7)
Access Issues with pg_type, pg_enum, pg_namespace in Azure Flexible Server
Why am I unable to modify default columns in pg_type, pg_enum, and pg_namespace tables on Azure Flexible Server? PS - Based on common issues that we have seen from customers and other sources, we are posting these questions to help the Azure community
![](https://techprofile.blob.core.windows.net/images/9CqRWkWyk0WIvV6eSiSD-g.png?8DB6B7)
![](https://techprofile.blob.core.windows.net/images/9CqRWkWyk0WIvV6eSiSD-g.png?8DB6B7)
Vacuum and Analyze Behavior During Force Failover in HA Database
What should be done if Vacuum and Analyze show as NULL in a High Availability (HA) database after a force failover? PS - Based on common issues that we have seen from customers and other sources, we are posting these questions to help the Azure community
![](https://techprofile.blob.core.windows.net/images/9CqRWkWyk0WIvV6eSiSD-g.png?8DB6B7)
![](https://techprofile.blob.core.windows.net/images/9CqRWkWyk0WIvV6eSiSD-g.png?8DB6B7)
Application deployed in Azure Kubernetes Service (AKS) hit Certificates do not conform to algorithm constraints when trying to connect Azure Database for PostgreSQL
Lately I receive news as below : When I trying to start my pod in AKS, it hit error as below when trying to connect to Azure Database for PostgreSQL – Flexible Server : Is there any idea and ways to fix this problem ?
Azure Postgresql Flexi -How to add Microsoft Entra Non admin users via Portal
HI Team We provision the PostgreSQL flexi instance using Terraform or via Azure Portal. While adding the Microsoft Entra admins to PostgreSQL - it defaults add them with 'Create DB' , 'Create Role' and 'azure_pg_admin' roles assigned to it. Is there a…
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…
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 …
[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…
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.…
![](https://techprofile.blob.core.windows.net/images/HY3oKwjtqEayHWip33wClQ.png?8D91E9)
Connecting Azure PostgreSQL from Public SaaS Service
How can I connect my Azure PostgreSQL database from a public SaaS service while ensuring secure access?
![](https://techprofile.blob.core.windows.net/images/9CqRWkWyk0WIvV6eSiSD-g.png?8DB6B7)
![](https://techprofile.blob.core.windows.net/images/9CqRWkWyk0WIvV6eSiSD-g.png?8DB6B7)
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 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:…
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…
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 |…
![](https://techprofile.blob.core.windows.net/images/kjzQAO5Oq0Oj37wdNf6qTQ.png?8D8E42)
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…
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…
![](https://techprofile.blob.core.windows.net/images/HY3oKwjtqEayHWip33wClQ.png?8D91E9)
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…