What is "storage account" during postgresql flexible server restoration process?
Hello, I know that probably I am missing something, but cannot figure out what I am doing wrong. I created a backup for my Postgresql flexible server exactly as described…
while accessing postgress flexible server from aks cluster getting error
while accessing azure postgress server from my aks cluster i am getting error error fetching from postgres, err: pq: no pg_hba.conf entry for host \"4.224.139.13\" this postgress servre is public , while seraching i got a document Check…
![](https://techprofile.blob.core.windows.net/images/ZuCGjNGWaEiWnbswF6AtpA.png?8DA64C)
messages_update_notify () not working after migrating from single server to flexible server
We recently migrated Azure postgres from single server to flexible server . There is a Trigger which are using function messages_update_notify () not working after migrating from single server to flexible server. is NOTIFY deprecated in Azure flexible…
![](https://techprofile.blob.core.windows.net/images/9CqRWkWyk0WIvV6eSiSD-g.png?8DB6B7)
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…
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…
Upgrade linked service for PostgreSQL - Data Factory
Currently I´m using the legacy LS for Postres SQL (SHIR) and the connection is working fine. I need to update the linked service (MS recomend to do it until 31/10/2024) but I´m receiving an error while testing the connection for the new one. Here´s…
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 "
PostgreSQL Entra Authentication via AD Group: get the personal user
I have users who sign in to PostgreSQL via an AAD group as described in the docs…
PostgreSQL flexible with Microsoft Entra authentication enabled - Logical Replication issue
Hi My application is using logical replication with PostgreSQL. Im trying to implement it using PostgreSQL flexible server with Microsoft Entra authentication only enabled. Im creating the admin and im able to connect to the database. Im altering…
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…
MS SQL Server SELECT not showing all fields in tables, how to fix?
We use an Azure Synapse SQL server, which contains a copy of our data from a Postgresql server, and I'm trying to list all the table names and fields in each table and display them in a viz in Power BI. Since I'm doing work in PBI this makes it…
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…
PostgreSQL Private Endpoint - Resource Not Supported
I'm having issues creating a private endpoint to my postgreSQL service. I created a basic Azure Database for PostgreSQL Server instance and spun up a test vm. I enabled the Allow access to Azure services option in connection security. When I go to…
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 ?
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)
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)