Azure Database for PostgreSQL
An Azure managed PostgreSQL database service for app development and deployment.
1,099 questions
0 answers
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
commented 2024-11-07T16:45:03.74+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
405
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
405
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
![](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,105
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
405
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,105
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
0 answers
Permission Denied in table 'xxx' Issue After Migrating from Single Server to Flexible Server in Azure PostgreSQL
Hello Microsoft Support Team, I am reaching out to request assistance with an issue I encountered after migrating my PostgreSQL database from Single Server to Flexible Server in Azure. After completing the migration, I am unable to execute queries, as I…
asked 2024-10-21T17:04:51.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(316.8, 31%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EWA%3C/text%3E%3C/svg%3E)
Waleed Asad
5
Reputation points
commented 2024-10-30T17:44:36.9166667+00:00
Sai Raghunadh M
1,045
Reputation points Microsoft Vendor
0 answers
Azure Postgresql Scheduled Maintenance stuck
I have a flexible server (Burstable, B1ms, 1 vCores, 2 GiB RAM, 32 GiB storage). I have received 18 health events over the course of two days, relating to Scheduled Maintenance. Attempts to e.g. restart the server have resultet in "Unknown…
asked 2024-10-28T08:22:14.74+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(80, 33%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EB%3C/text%3E%3C/svg%3E)
bho
5
Reputation points
commented 2024-10-30T13:43:19.09+00:00
Vijayalaxmi Kattimani
405
Reputation points Microsoft Vendor
1 answer
One of the answers was accepted by the question author.
Synapse Analytics workspace can not linked services to PostgreSQL Flexible within VNet
Here is my scenario: A database uses Azure Database for PostgreSQL - Flexible Server with Private access (VNet Integration) setting. An Azure Synapse Analytics Workspace with Managed virtual network (Enable) I can not create the linked service to my…
asked 2024-10-23T18:47:00.0266667+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(233.6, 79%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHN%3C/text%3E%3C/svg%3E)
Đỗ Hoàng Minh Hưng
25
Reputation points
accepted 2024-10-29T14:20:00.3566667+00:00
Đỗ Hoàng Minh Hưng
25
Reputation points
0 answers
How to fix Error 603413: Unsupported language(s). in Azure DMS
i try to use Azure DMS (new version) migration from AWS RDS PostgreSQL version 15.6 to Azure Azure Database for PostgreSQL - Flexible Server version 16.4 which when i choose validation and migrate it cannot success and show this errors : Error 603413:…
asked 2024-10-25T11:31:52.5433333+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, 62%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPB%3C/text%3E%3C/svg%3E)
Phatruethai Buaurai
0
Reputation points
commented 2024-10-29T13:25:20.64+00:00
Vijayalaxmi Kattimani
405
Reputation points Microsoft Vendor
0 answers
Azure Postgresql Scheduled Maintenance stuck 2
Details: The service has been stuck in maintenance mode for 3 days now and I am unable to create a ticket without a support plan (it also says until maintenance is done....). The only change I can see that came from the maintenance on my flexible…
asked 2024-10-28T22:11:12.7333333+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(310.4, 73%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EC%3C/text%3E%3C/svg%3E)
Cade
0
Reputation points
commented 2024-10-29T10:49:31.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(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
15,421
Reputation points
1 answer
Connect to Azure PostgresDB from PowerBI
Trying to connect from PowerBI desktop to an instance of Azure Postgresql. I am able to connect from my laptop to the database using PGAdmin4. A colleague also tried to connect. I get an error that says: "Unable to create an encrypted…
asked 2024-10-28T20:20:26.2966667+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, 60%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDB%3C/text%3E%3C/svg%3E)
David Boyd
0
Reputation points
answered 2024-10-29T10:29:32.3+00:00
ShaktiSingh-MSFT
15,421
Reputation points
1 answer
One of the answers was accepted by the question author.
Azure Database for PostgreSQL - Flexible Server - administrator role permission
https://learn.microsoft.com/en-us/azure/postgresql/flexible-server/concepts-security#access-management While you're creating the Azure Database for PostgreSQL - Flexible Server instance, you provide credentials for an administrator role. This…