Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
4,695 questions
1 answer
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!
asked 2024-06-13T12:33:24.1+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(201.6, 34%, 29%)' 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)
Sathya Sai Cheetirala
0
Reputation points
answered 2024-07-26T20:20:09.1366667+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, 33%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAP%3C/text%3E%3C/svg%3E)
Andrey Prokopenko
0
Reputation points
2 answers
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…
asked 2024-07-26T18:59:14.97+00:00
GeethaThatipatri-MSFT
29,017
Reputation points Microsoft Employee
edited an answer 2024-07-26T19:10:34.9866667+00:00
GeethaThatipatri-MSFT
29,017
Reputation points Microsoft Employee
1 answer
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…
asked 2024-07-26T18:43:58.77+00:00
GeethaThatipatri-MSFT
29,017
Reputation points Microsoft Employee
answered 2024-07-26T18:45:43.3633333+00:00
GeethaThatipatri-MSFT
29,017
Reputation points Microsoft Employee
1 answer
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…
asked 2024-07-26T18:00:35.7566667+00:00
GeethaThatipatri-MSFT
29,017
Reputation points Microsoft Employee
edited an answer 2024-07-26T18:04:38.91+00:00
GeethaThatipatri-MSFT
29,017
Reputation points Microsoft Employee
1 answer
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
asked 2024-07-26T15:52:13.0133333+00:00
GeethaThatipatri-MSFT
29,017
Reputation points Microsoft Employee
answered 2024-07-26T15:53:09.4366667+00:00
GeethaThatipatri-MSFT
29,017
Reputation points Microsoft Employee
1 answer
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
asked 2024-07-26T15:37:03.71+00:00
GeethaThatipatri-MSFT
29,017
Reputation points Microsoft Employee
edited the question 2024-07-26T15:39:29.0966667+00:00
GeethaThatipatri-MSFT
29,017
Reputation points Microsoft Employee
0 answers
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 ?
asked 2024-07-26T14:02:15.1033333+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(150.4, 59%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECK%3C/text%3E%3C/svg%3E)
Chee Kong Hong
0
Reputation points
asked 2024-07-26T14:02:15.1033333+00:00
Chee Kong Hong
0
Reputation points
0 answers
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…
asked 2024-07-26T04:23:40.0566667+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, 85%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESD%3C/text%3E%3C/svg%3E)
subhash-DBA
45
Reputation points
commented 2024-07-26T08:07:20.19+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
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
![](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
edited a comment 2024-07-26T07:35:09.2433333+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
24,111
Reputation points
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 …
![](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)
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…
asked 2024-07-23T18:52:16.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(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)
LuisC
20
Reputation points
commented 2024-07-26T05:04:44.7766667+00:00
ShaktiSingh-MSFT
14,406
Reputation points Microsoft Employee
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-26T04:14:21.1233333+00:00
ShaktiSingh-MSFT
14,406
Reputation points Microsoft Employee
1 answer
Connecting Azure PostgreSQL from Public SaaS Service
How can I connect my Azure PostgreSQL database from a public SaaS service while ensuring secure access?
asked 2024-07-25T22:13:21.1833333+00:00
GeethaThatipatri-MSFT
29,017
Reputation points Microsoft Employee
edited an answer 2024-07-25T22:19:03.0566667+00:00
GeethaThatipatri-MSFT
29,017
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
commented 2024-07-25T12:45:56.83+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
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
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
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
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