Azure Database for PostgreSQL
An Azure managed PostgreSQL database service for app development and deployment.
1,098 questions
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
0
Reputation points
commented 2024-11-05T16:31:39.1033333+00:00
Abhishek M
0
Reputation points
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
answered 2024-11-05T12:40:09.9333333+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
160
Reputation points Microsoft Vendor
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
160
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
![](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
2,950
Reputation points Microsoft Vendor
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-05T00:43:35.56+00:00
NIKHILA NETHIKUNTA
2,950
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
895
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
895
Reputation points Microsoft Vendor
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
answered 2024-10-31T10:20:00.1133333+00:00
Vinodh247
22,951
Reputation points MVP
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
895
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
160
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
160
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,341
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,341
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…
1 answer
Issue with postgre sql
I am currently experiencing high latency with PostgreSQL queries during peak load times in our production environment. Here are the details: PostgreSQL Version: 13.3, Database Size: Approximately 500 GB During peak hours, response times for certain…
asked 2024-10-24T14:47:53.2933333+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(256, 27%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERM%3C/text%3E%3C/svg%3E)
Rubens Max
100
Reputation points
commented 2024-10-29T08:48:03.0533333+00:00
Vijayalaxmi Kattimani
160
Reputation points Microsoft Vendor
1 answer
how can create a visual basic 2017 sql database and table not over module, please
I would to create a database in visual basic 2017, sqlexpress, programmatically, code. I am looking for an example code. But I do not need "Module, or class. Because I can't handle this I just need a code from Button Click it is all. Thank you in…
Visual Studio
Visual Studio
A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.
5,187 questions
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,970 questions
Azure Database for PostgreSQL
Azure Database for PostgreSQL
An Azure managed PostgreSQL database service for app development and deployment.
1,098 questions
asked 2024-10-24T10:02:53.48+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, 41%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EM%3C/text%3E%3C/svg%3E)
MannySo
25
Reputation points
commented 2024-10-28T10:21:56.4933333+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(252.8, 60%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMK%3C/text%3E%3C/svg%3E)
Mahesh Kurva
725
Reputation points Microsoft Vendor