Azure
A cloud computing platform and infrastructure for building, deploying and managing applications and services through a worldwide network of Microsoft-managed datacenters.
1,014 questions
0 answers
ADX plugin postgresql_request failed to load System.Security.Cryptography.Algorithms
I have an Azure Data Explorer (ADX) instance in combination with a PostgreSQL Flexible Server (16.4) and want to access the SQL table test_adx_meta from ADX. There are no firewall or IP range limitations. I followed the official postgres_request…
Azure
Azure Data Explorer
Azure Data Explorer
An Azure data analytics service for real-time analysis on large volumes of data streaming from sources including applications, websites, and internet of things devices.
532 questions
Azure Database for PostgreSQL
Azure Database for PostgreSQL
An Azure managed PostgreSQL database service for app development and deployment.
1,106 questions
![](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(16, 49%, 11%)' 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)
0 answers
How to fix a malformed backend type returned from an Azure sys query?
A malformed backend_type is returned from an azure_sys query in Azure Flexible PostgreSQL pg_stat_activity table: [ { "state": "idle", "query": "SELECT query_stats.pgms_stats_insert_data", …
asked 2024-11-11T17:03:22.3766667+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(137.6, 80%, 23%)' 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)
Savan Dosanjh
0
Reputation points
commented 2024-11-13T09:38:39.1466667+00:00
Savan Dosanjh
0
Reputation points
0 answers
Performance issues after scaling up Azure Database for PostgreSQL - Flexible Server
We're running Azure Database for PostgreSQL - Flexible Server on General Purpose, D8ds_v5 (8 vCores, 32 GiB RAM) with 2Tb storage. After switching to D16ds_v5 (16 vCores, 64 GiB RAM) with 4Tb storage, the performance decreased significantly. All the…
asked 2024-11-11T21:13:35.8533333+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(268.8, 91%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETS%3C/text%3E%3C/svg%3E)
Tigran Sardaryan
0
Reputation points
commented 2024-11-13T07:11:37.1633333+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' %3ENN%3C/text%3E%3C/svg%3E)
NIKHILA NETHIKUNTA
3,265
Reputation points Microsoft Vendor
0 answers
Internal Server Error while creating DBforPostgreSQL flexibleServers
I keep getting a an unexpected error occured while processing the request to create a new flexible server. Code: InternalServerError
asked 2024-11-12T16:41:19.2233333+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, 3%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESN%3C/text%3E%3C/svg%3E)
Sam Nehmat (Cloud Admin)
0
Reputation points
commented 2024-11-13T02:32:35.9833333+00:00
NIKHILA NETHIKUNTA
3,265
Reputation points Microsoft Vendor
2 answers
Unable to upgrade Postgresql Flexible Server from V14 to V16
Dear Azure Support, I would like to do a major upgrade of Postgres Flexible Server from V14 to V16. I always get the following error message, although I have removed extensions dblink and postgres_fdw. PS C:\Program Files\PowerShell\7> az postgres…
asked 2024-11-08T15:16:50.1133333+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, 65%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMC%3C/text%3E%3C/svg%3E)
Martin Constam
0
Reputation points
edited an answer 2024-11-12T14:53:28.2233333+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(6.4, 10%, 10%)' 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)
Chi Kit Yuen
0
Reputation points
1 answer
ADF - postgres: Read method cannot be called when another read operation is pending
I'm using Azure Data Factory copy data activity to move data from Azure PostgreSQL to OneLake. I'm using a self-hosted integration runtime for that (because of how our VNETs are set up). Here is the error I'm getting: Operation on target…
asked 2024-11-12T09:22:24.8866667+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(153.6, 88%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMR%3C/text%3E%3C/svg%3E)
Mart Roben
0
Reputation points
answered 2024-11-12T10:59:57.2366667+00:00
Amira Bedhiafi
26,491
Reputation points
3 answers
One of the answers was accepted by the question author.
Deploying Azure flexible server hangs
Following this page: https://learn.microsoft.com/en-us/azure/postgresql/flexible-server/tutorial-webapp-server-vnet When creating the actual database, the process hangs. It eventually fails after a couple hours with this: The resource write operation…
asked 2024-11-07T23:45:12.63+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(118.4, 9%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJW%3C/text%3E%3C/svg%3E)
Julian Wood
20
Reputation points
accepted 2024-11-12T03:47:52.51+00:00
Julian Wood
20
Reputation points
1 answer
Impact of azure_pg_admin Role on Query Performance in Azure PostgreSQL Flexible Server
We’re using Azure PostgreSQL Flexible Server (v.13) and noticed a significant performance disparity between users that have the azure_pg_admin role and those that don’t. For example, queries that complete in milliseconds for users with azure_pg_admin…
asked 2024-11-07T12:51:22.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(192, 7.000000000000001%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAM%3C/text%3E%3C/svg%3E)
Azeem, Muhammad
0
Reputation points
answered 2024-11-11T16:57:11.0433333+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(35.2, 49%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVK%3C/text%3E%3C/svg%3E)
Vijayalaxmi Kattimani
415
Reputation points Microsoft Vendor
1 answer
Unable to Provision Azure PostgreSQL Flexible Server in West US 2 with FoundersHub Subscription
We are currently running our PostgreSQL database on an Ubuntu VM and would like to migrate to Azure PostgreSQL Flexible Server. However, when we attempt to create this resource in the West US 2 region, we encounter the following…
asked 2024-11-05T10:17:18.0033333+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(89.60000000000001, 79%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMS%3C/text%3E%3C/svg%3E)
Mustafa Savas
0
Reputation points
commented 2024-11-07T12:50:27.62+00:00
Vijayalaxmi Kattimani
415
Reputation points Microsoft Vendor
2 answers
Auto increment postgres serial type in logic app insert row action ID field
Hi, The insert row action is requiring an ID field but my table in postgres is type serial. Is there anyway to tell the logic app that an ID field does not need to be set on the insert as postgres will auto increment this field?
asked 2022-03-01T00:53:14.293+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(281.6, 28.999999999999996%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELO%3C/text%3E%3C/svg%3E)
Liam O'Dowd
26
Reputation points
answered 2024-11-07T07:13:45.96+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(44.800000000000004, 76%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPA%3C/text%3E%3C/svg%3E)
Power Automate
0
Reputation points
1 answer
PGRouting availability for PostgreSQL 16 Flexible Server
Is there any update on when the PGRouting extension will be available for PostgreSQL16 flexible server please?
asked 2024-10-31T08:09:07.3633333+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(60.8, 50%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECS%3C/text%3E%3C/svg%3E)
Cooling, Steve
20
Reputation points
commented 2024-11-06T19:11:40.05+00:00
Oury Ba-MSFT
19,581
Reputation points Microsoft Employee
1 answer
I want to get permission to create schema in COSMOS DB for postgresql
I am currently working on migrating data from AWS Aurora database to Azure Cosmos db for postgresql. I tried to use airbyte as a tool for that, but when I connect cosmos db as target database in airbyte, I get an error saying that I don't have permission…
asked 2024-11-01T16:28:46.5533333+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(137.6, 89%, 23%)' 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)
paradigmshift
0
Reputation points
commented 2024-11-06T18:08:25.93+00:00
NIKHILA NETHIKUNTA
3,265
Reputation points Microsoft Vendor
2 answers
One of the answers was accepted by the question author.
Azure Database for PostgreSQL - Flexible Server - How to modify table owner
Does anyone know how to modify table owner in Azure Database for PostgreSQL - Flexible Server (postgres v13)？ I have a administrator role account admindemo (member of azure_pg_admin) and another account named 'liquibase for managing tables, functions,…
![](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(304, 45%, 39%)' 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 answer
One of the answers was accepted by the question author.
How to fix FATAL: remaining connection slots are reserved for roles with privileges of the "pg_use_reserved_connections" role on an Azure Database for PostgreSQL flexible server.
Hi. I have a database running on an Azure Database for PostgreSQL flexible server. I have been managing the database using pgAdmin. Now i am not able to access or login as i am getting the following error, FATAL: remaining connection slots are reserved…
asked 2024-10-25T12:37:37.95+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(272, 78%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAM%3C/text%3E%3C/svg%3E)
Abhishek M
20
Reputation points
commented 2024-11-05T16:31:39.1033333+00:00
Abhishek M
20
Reputation points
2 answers
The backup restore is set to 7 days, but I don't see any restore point in the backup and restore menu.
Hello, The backup restore is set to 7 days, but I don't see any restore point in the backup and restore menu. When I try to restore from Overview manu, I get an error: Only 40% of the storage is used and the database is not overloaded. Some one…
asked 2024-10-30T13:01:00.97+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, 34%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMG%3C/text%3E%3C/svg%3E)
Mateusz Gródek
0
Reputation points
commented 2024-11-05T11:27:35.71+00:00
Vijayalaxmi Kattimani
415
Reputation points Microsoft Vendor
1 answer
Azure PostgreSQL storage data incresing
I am using postgresql for development purpose. And its increasing its size automatically even without access or no activity. Every day it increases for about 700mb. When i go to metrics and select used storage it is 2.9gb. And when i select backup…
asked 2024-10-28T16:59:23.1566667+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(192, 42%, 28%)' 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)
sima savke
0
Reputation points
commented 2024-11-05T00:47:11.87+00:00
NIKHILA NETHIKUNTA
3,265
Reputation points Microsoft Vendor
1 answer
One of the answers was accepted by the question author.
How to migrate database users from Azure PostgreSQL single server to flexible server?
Hello team, I was using the migration tool provided in Azure portal to migrate databases from PostgreSQL single server to flexible server.The migration itself was successful and I could see my database and data in the flexible server. The issue I am…
asked 2024-05-06T18:47:09.7233333+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(217.60000000000002, 15%, 31%)' 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)
Pratik
20
Reputation points
commented 2024-11-04T14:02:32.1333333+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(236.8, 75%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPD%3C/text%3E%3C/svg%3E)
Petru Dumuta
11
Reputation points
1 answer
One of the answers was accepted by the question author.
Azure database for Postgres Flexible server - Why creating extension uuid-ossp requires azure_pg_admin role?
My question is with respect to Azure Database for Postgres Flexible server (version PG16). I tried to create extension on current database (logged into database as db owner) however I see an error stating "ERROR: Only members of…
asked 2024-10-30T10:51:45.6933333+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(262.40000000000003, 88%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETS%3C/text%3E%3C/svg%3E)
Tulsiraja Shastry
20
Reputation points
accepted 2024-11-04T04:28:29.03+00:00
Tulsiraja Shastry
20
Reputation points
2 answers
Is it possible to restore a Postgress database to another location than LIVE?
We are using the standard Postgres Backup and need to restore the latest backup to another location so we can compare some changes to the database after our last code changes. Is it possible to restore to another location? Any feedback on how to do…
asked 2024-10-25T16:09:29.94+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(169.60000000000002, 27%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKS%3C/text%3E%3C/svg%3E)
Kenneth Sewell
0
Reputation points
commented 2024-11-01T09:28:54.09+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(198.4, 69%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESR%3C/text%3E%3C/svg%3E)
Sai Raghunadh M
1,045
Reputation points Microsoft Vendor
1 answer
Replicate Azure Cosmos DB for PostgreSQL into different resource group than primary cluster
On it states... https://learn.microsoft.com/en-us/azure/cosmos-db/postgresql/concepts-read-replicas Cross-region replication Read replicas can be created in the region of the primary cluster, or in any other region supported by Azure Cosmos DB for…
asked 2024-10-25T21:38:09.1233333+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(272, 38%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJS%3C/text%3E%3C/svg%3E)
James Sampica
0
Reputation points
commented 2024-11-01T09:09:42.1033333+00:00
Sai Raghunadh M
1,045
Reputation points Microsoft Vendor