Azure Database for PostgreSQL
An Azure managed PostgreSQL database service for app development and deployment.
1,138 questions
1 answer
One of the answers was accepted by the question author.
Azure Cannot delete postgres flexible server
Hello, I cannot delete my resource: Unkown error in Azure and "is busy with another operation" with the az cli.... How I can debug. I can start/stop the resource but I m not able to remove it.
asked 2024-12-03T12:18:18.07+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, 65%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EFD%3C/text%3E%3C/svg%3E)
Fabien Donnet
0
Reputation points
accepted 2024-12-26T16:42:22.6433333+00:00
Fabien Donnet
0
Reputation points
2 answers
Azure Cosmos Postgresql issue with Role creation
Hi, We are using Azure Cosmos Postgresql DB and we are experiencing issues with Role creation. We created a role from console as well as az cli using below command - The command shows succeeded and the role is visible. However the same role is not…
asked 2024-08-23T08:53:50.2166667+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(70.4, 3%, 16%)' 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)
Vipal Mehta
20
Reputation points
answered 2024-12-26T06:31:35.32+00:00
Vipal Mehta
20
Reputation points
1 answer
How to migrate Postgres Database from One Azure Entity to Another Azure Entity
Hi, We have a PostgreSQL flexible server hosted on Azure under the entity (abc.com). Due to some business changes, we need to migrate the PostgreSQL database from entity (abc.com) to entity (xyz.com). Could you please suggest the best ways to perform…
asked 2024-12-18T06:19:36.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(214.4, 34%, 30%)' 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)
Kode Sasikiran
0
Reputation points
commented 2024-12-23T17:53:32.14+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
4,005
Reputation points Microsoft Vendor
1 answer
Azure postgresql server getting stuck
My Azure PostgreSQL managed database server is stuck. I tried connecting to it, but it didn't work. When I attempted to restart the server, I received the error: "The server is currently in 'restarting' state. Please wait for the operation to…
asked 2024-12-23T14:24:57.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(6.4, 73%, 10%)' 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)
MR Subbato
0
Reputation points
edited an answer 2024-12-23T16:13:50.31+00:00
Dillon Silzer
57,556
Reputation points
1 answer
Azure Database for PostgreSQL Metric Storage Percent remains empty
Hi Community, i have a Azure Database for PostgreSQL flexible Server and want to monitor the Metric "Storage Percent". When I configure the According Graph, it remains empty: As far as I found out through googling, this Metric should be Active…
asked 2024-12-19T12:47:56.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(217.60000000000002, 83%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBK%3C/text%3E%3C/svg%3E)
Benjamin Krüger
0
Reputation points
commented 2024-12-23T13:59:30.69+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,605
Reputation points Microsoft Vendor
2 answers
One of the answers was accepted by the question author.
Azure postgres flexible server timescale pgai "ai" extension availability
Hello Does anybody know if there will be a update to timescaledb on azure to make pgai available from timescale? Kind regards Adrian
asked 2024-11-16T20:15:26.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(192, 36%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAR%3C/text%3E%3C/svg%3E)
Adrian Ruchti
20
Reputation points
edited the question 2024-12-23T13:32:34.92+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, 24%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENM%3C/text%3E%3C/svg%3E)
navba-MSFT
26,890
Reputation points Microsoft Employee
1 answer
One of the answers was accepted by the question author.
In PostgresSQL dont work parammetr "Allow public access from any Azure service within Azure to this server" on china region
Hi, I am using Azure Database for PostgreSQL in the China region. I also use Azure DevOps for my CI/CD processes. Currently, I am facing an issue where I cannot perform database migrations or execute scripts for the database through Azure Pipelines (in…
asked 2024-12-18T14:21:24.9466667+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(64, 50%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPK%3C/text%3E%3C/svg%3E)
Petro Kostiuk (EXT)
20
Reputation points
accepted 2024-12-18T19:26:02.5833333+00:00
Petro Kostiuk (EXT)
20
Reputation points
1 answer
PostgresException: 42P01: relation "waitdb" does not exist
Hi, I was having a trouble about 42P01:relation when using postgres sql, Here's the code that i've been using and for my tables here's the table. For my configuration, is there something wrong with it? Thank you for response, since i am new to c#
asked 2024-12-07T06:57:38.4266667+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(297.6, 73%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECL%3C/text%3E%3C/svg%3E)
Clark Leovison Rey
0
Reputation points
commented 2024-12-18T15:42:45.07+00:00
NIKHILA NETHIKUNTA
4,005
Reputation points Microsoft Vendor
1 answer
One of the answers was accepted by the question author.
Azure PostgreSQL Database Backup
The documentation on this page https://zcusa.951200.xyz/en-us/training/modules/backup-restore-azure-sql/2-protect-database-with-backup focuses on Azure SQL Database backups. Does this information also apply to Azure Database for PostgreSQL?…
asked 2024-10-21T18:49:01.0233333+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(28.799999999999997, 70%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESP%3C/text%3E%3C/svg%3E)
Sonal Patel
40
Reputation points
edited the question 2024-12-18T06:12:36.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(256, 17%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ER%3C/text%3E%3C/svg%3E)
RNareddy
1,430
Reputation points Microsoft Vendor
0 answers
I have create Azure postgresql flexible server and trying to delete it, but not able to delete. Getting error as server busy with other operations. How can i resolve and delete this flexible server
resource "azurerm_subnet" "PrivateSubnet1C" { name = "PrivateSubnet1C" resource_group_name = azurerm_resource_group.fua_group.name virtual_network_name = azurerm_virtual_network.fuaVNet.name address_prefixes =…
asked 2024-12-11T04:21:04.89+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(19.2, 9%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAS%3C/text%3E%3C/svg%3E)
Ansar Shaik
0
Reputation points
commented 2024-12-18T01:21:26.0933333+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
1,470
Reputation points Microsoft Vendor
2 answers
One of the answers was accepted by the question author.
Postgre-SQL Flexible Server - pg_cron permissions issue
I am connecting to the postgres database with the psqladminun user who is a member of the azure_pg_admin role. I run the following: CREATE EXTENSION pg_cron; After that I go to schedule a job: SELECT cron.schedule_in_database('part_maint_TEST','0 * * *…
asked 2024-11-20T22:35:13.98+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, 6%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHJ%3C/text%3E%3C/svg%3E)
Herman, Justin
35
Reputation points
commented 2024-12-17T15:12:55.4666667+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, 72%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENJ%3C/text%3E%3C/svg%3E)
Naveena Jaineera
41
Reputation points
1 answer
One of the answers was accepted by the question author.
Issue migrating azure postgress single to flexible server
Hello communiy, I am attempting to migrate a modest single database from Azure Postgres to the new Flex instance. The process took approximately three hours and generated the following error: The error message does not provide any details as to why it…
![](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(297.6, 93%, 38%)' 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)
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
5
Reputation points
commented 2024-12-13T19:18:41.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(156.8, 0%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EES%3C/text%3E%3C/svg%3E)
Eric Swiggum
0
Reputation points
1 answer
How to authenticate a 3rd party tool via Entra ID with read access over pgsql
I am trying to authenticate a 3rd-party tool over Azure database for PostgreSQL - Flexible server using Entra ID only. so I created multiple service principals (access-token based, password-based auth and Certificate-based auth). The access token one,…
asked 2024-12-11T15:41:41.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(278.4, 25%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EEM%3C/text%3E%3C/svg%3E)
Elgaby Mohamed
0
Reputation points
commented 2024-12-13T19:07:55.3066667+00:00
Oury Ba-MSFT
19,831
Reputation points Microsoft Employee
2 answers
Cannot drop admin role which is role grantor because the role grantor cannot be changed.
When I create new role/group in Azure Database for PostgreSQL flexible server 16 under a workload identity admin (admin_wi) and grant the role to another user CREATE ROLE testrole; GRANT testrole TO azure_pg_admin WITH ADMIN OPTION; the role details…
asked 2024-09-25T13:00:52.2566667+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(297.6, 79%, 38%)' 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)
Tomáš Krečmer
25
Reputation points
commented 2024-12-13T08:50:47.6166667+00:00
Tomáš Krečmer
25
Reputation points
0 answers
Error While Migrating from Azure PostgreSQL Single Server to Flexible Server
Hi Community, I’m encountering an issue while migrating from Azure PostgreSQL Single Server to Flexible Server using the Azure Database Migration Service. Error Details During the migration of a database (e.g., database_name), the process failed with…
asked 2024-11-29T14:29:23.0933333+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(76.8, 54%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ES%3C/text%3E%3C/svg%3E)
SoniaD_74
0
Reputation points
edited a comment 2024-12-12T10:27:47.5166667+00:00
Mahesh Kurva
1,470
Reputation points Microsoft Vendor
3 answers
Azure Database for PostgreSQL resource not showing up in Azure portal
We have a postgres database, it is present in the subscription invoices. It is available for applications, but it is not visible in the resource group and is not visible anywhere except in the payment invoices.
asked 2024-11-20T11:49:56.4133333+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, 45%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVS%3C/text%3E%3C/svg%3E)
Vlad Shendykov
0
Reputation points
commented 2024-12-12T07:54:46.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(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
740
Reputation points Microsoft Vendor
1 answer
One of the answers was accepted by the question author.
Azure PostgreSQL Flexible server: Unable to drop roles
We are having some weird issues when trying to remove roles. I am connected as the admin user that is member of azure_pg_admin. When trying to remove a role with DROP ROLE role_to_drop We get the error "Could not drop the role. Only roles with the…
asked 2024-04-10T13:20:19.3+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(243.2, 26%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPK%3C/text%3E%3C/svg%3E)
Peter Koller
45
Reputation points
commented 2024-12-11T16:15:27.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(147.20000000000002, 22%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESK%3C/text%3E%3C/svg%3E)
Stavros Koureas
1
Reputation point
1 answer
Will Single to Flexi postgres migration migrates users too? and if there are any foreign data wrappers?
We have a single server which says auto migration is scheduled. But we are not able to view who scheduled the migration automatically. please help. After single to flexi migration, can we still use single server if there are any issues in target flexi…
asked 2024-11-27T17:52:47.81+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(188.79999999999998, 62%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJV%3C/text%3E%3C/svg%3E)
Jaiyasree Venkataramanan
0
Reputation points
commented 2024-12-11T14:22:06.6266667+00:00
Mahesh Kurva
1,470
Reputation points Microsoft Vendor
1 answer
Does Azure cosmos DB for Postgresql support oracle_fdw extension?
Can you please confirm if Azure Cosmos DB for Postgresql provides oracle_fdw extension to enable creating foreign tables in Postgresql that connects to the Oracle tables or schemas? I know it's been mentioned that oracle_fdw is available for Azure…
asked 2024-12-06T00:25:57.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(265.6, 16%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENC%3C/text%3E%3C/svg%3E)
Nick Chuah
0
Reputation points
commented 2024-12-10T19:24:32.4266667+00:00
NIKHILA NETHIKUNTA
4,005
Reputation points Microsoft Vendor