Azure Cosmos DB
An Azure NoSQL database service for app development.
1,591 questions
1 answer
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
commented 2024-08-27T17:42:45.6866667+00:00
Vipal Mehta
20
Reputation points
1 answer
View the size database of Azure Database for PostgreSQL flexible server in the azure portal
I would like know why in the azure portal don't have the view of databases sizes. My suggestion, Microsoft could add a column that shows the size of the databases. This information would be very useful to everyone
asked 2024-08-26T18:45:34.3+00:00
Antonio Elias Soares Ferreira da Silva
25
Reputation points
commented 2024-08-27T17:11:18.6966667+00:00
Oury Ba-MSFT
18,436
Reputation points Microsoft Employee
1 answer
How can I rename Azure Database for PostgreSQL flexible server as it has name
How can I rename Azure Database for PostgreSQL flexible server as it has suffix backup. We are currently using copy of backup database and did lots of development on top of it. What is the best way to rename it so that it does not have backup in the…
asked 2024-08-23T17:29:48.61+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(140.8, 81%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGJ%3C/text%3E%3C/svg%3E)
Grover, Jyoti [ABMUS]
0
Reputation points
commented 2024-08-27T16:30:24.1933333+00:00
Oury Ba-MSFT
18,436
Reputation points Microsoft Employee
2 answers
Error creating a Flexible Postgres Database in Azure
Getting this error when creating the database trough the Azure portal in south central US { "status": "Failed", "error": { "code": "InternalServerError", "message":…
asked 2024-07-30T18:32:19.02+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, 61%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJR%3C/text%3E%3C/svg%3E)
Juan Ribon
0
Reputation points
commented 2024-08-27T14:44:37.9566667+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, 79%, 32%)' 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)
RahulRandive
9,426
Reputation points
1 answer
Azure PostgreSQL Flexible Server Creation Fails with InternalServerError
Hi, I'm not able to provision an Azure PostgreSQL Flexible Server. I got the following error: polling after Create: polling failed: the Azure API returned the following error: │ │ Status: "InternalServerError" │ Code: "" │ Message:…
asked 2024-08-27T14:15:10.72+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, 21%, 20%)' 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)
karim sellami
0
Reputation points
answered 2024-08-27T14:40:28.6133333+00:00
RahulRandive
9,426
Reputation points
0 answers
How can fix LongTermRetentionBackupInternalError
I am trying to make a backup to Azure database Postgres SQL flexible server but it fails and gives me this error LongTermRetentionBackupInternalError I followed https://learn.microsoft.com/en-us/azure/backup/backup-azure-database-postgresql-flex but…
asked 2024-08-13T06:40:28.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(60.8, 2%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EYY%3C/text%3E%3C/svg%3E)
Youssef Yassa
20
Reputation points
edited a comment 2024-08-27T14:18:25.11+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, 12%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKD%3C/text%3E%3C/svg%3E)
Koen de Jaeger | Finalist
0
Reputation points
1 answer
One of the answers was accepted by the question author.
Will Postgres flexible server upgrade support new features
Hi, We have to install private endpoint to connect from ADF to Postgres flexible server. The question is the server was created in 2023 and the support for private endpoint for it only exists since Feb 2024. I wonder if an upgrade of the server will get…
![](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(246.4, 30%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EWY%3C/text%3E%3C/svg%3E)
1 answer
How can i take backup of one public postgress server and restore it on another private postgress flexible server with same region and same network
Both server present in a same network and same location, but source server have 2 region and target server have 1 region This is my version source server details Burstable, 1 vCore(s), 128 GB postgress server - 16.3 this is my target server…
![](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, 51%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EK%3C/text%3E%3C/svg%3E)
0 answers
Improving Postgres Server Backup Solution
What are some ways to improve upon the built-in backup functions of Postgres flexible server to ensure that backups are recoverable in case the server is deleted? It's important to have a separate backup that is protected against accidental deletion,…
asked 2024-08-26T09:52:49.23+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(51.2, 33%, 14%)' 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)
mungi sai meghavardhan
20
Reputation points
commented 2024-08-27T05:49:57.9766667+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,796
Reputation points
0 answers
How can I immediately take ownership of an Azure PostgreSQL table without AZURESU superuser permissions?
A developer created a PostgreSQL table and now has ownership, causing my PGADMIN backup task to fail. They could fix the issue when they return from vacation, but how can I immediately take ownership without AZURESU superuser permissions? Since AZURE…
asked 2024-08-26T17:19:14.6733333+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, 14.000000000000002%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGL%3C/text%3E%3C/svg%3E)
Greg Lowell
0
Reputation points
commented 2024-08-26T22:26:26.39+00:00
Oury Ba-MSFT
18,436
Reputation points Microsoft Employee
0 answers
Request to Enable PostGIS Extension on Azure PostgreSQL Server
I am hosting a PostgreSQL server on Azure and need to use the PostGIS extension for my project. However, when attempting to install the extension with the azure_pg_admin user, I receive the following error: ERROR: extension "postgis" is not…
asked 2024-08-25T05:18:06.2366667+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(204.8, 70%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETT%3C/text%3E%3C/svg%3E)
tugce tay
0
Reputation points
commented 2024-08-26T13:38:15.77+00:00
ShaktiSingh-MSFT
14,796
Reputation points
2 answers
One of the answers was accepted by the question author.
Is the Azure Database for PostgreSQL single server dropped after its migrated to flexible server?
I want to migrate my Azure Database for PostgreSQL single server to flexible server. I was wondering what will happen to the single server database after it is migrated to flexible server? Basically the question is two-fold where I would like to…
asked 2024-08-14T02:50:34.5966667+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, 74%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERP%3C/text%3E%3C/svg%3E)
Ravi Prabhat Dubey
20
Reputation points
accepted 2024-08-26T06:07:22.15+00:00
Ravi Prabhat Dubey
20
Reputation points
1 answer
PostgreSQL Flexible server availability issue
I want to create Azure Database for PostgreSQL Flexible server with High availability Zone redundant (99.99 SLA) but this option is unable to be selected it, only available Disabled (99.9% SLA) and Same zone (99.95% SLA) east us region @Anonymous can…
asked 2024-08-08T00:27:35.79+00:00
Youssef Yassa
20
Reputation points
commented 2024-08-26T05:50:42.4233333+00:00
ShaktiSingh-MSFT
14,796
Reputation points
1 answer
Cannot run a major upgrade on Azure Postgres Flexible Server with pgBouncer
Hi, I am trying to perform a major upgrade on my Azure Database for PostgreSQL flexible server from version 14 to version 16. However I am getting an internal server error from the upgrade process, with no detailed information about the exact cause apart…
asked 2024-08-10T08:28:06.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(128, 28.000000000000004%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETO%3C/text%3E%3C/svg%3E)
Théo Mouchabac
0
Reputation points
commented 2024-08-25T00:00:20.0766667+00:00
Vinodh247
15,701
Reputation points
1 answer
Unable to authenticate using entra id in logical replication mode
Authentication mechanism: Entra ID authentication User type: entra ID user. alter role with replication Connect to the server using command (after logging in): $ psql "host=test.postgres.database.azure.com port=5432 dbname=postgres…
asked 2024-08-23T11:01:30.75+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(121.6, 76%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESV%3C/text%3E%3C/svg%3E)
Shiva Vanamala
5
Reputation points
commented 2024-08-23T20:16:35.6033333+00:00
Shiva Vanamala
5
Reputation points
0 answers
Is there a way to nightly sync one DB with another?
Is there a way to set up a nightly sync between two (Azure-hosted) Postgres databases? I've read about Azure Data Sync for SQL, but from what I can tell it doesn't apply to Postgres DBs. Basically we have a live DB, and a stage DB, and we would like the…
![](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, 81%, 35%)' 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)
5 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
answered 2024-08-23T13:14:22.22+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(224.00000000000003, 28.999999999999996%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EUK%3C/text%3E%3C/svg%3E)
Usman Khawar
0
Reputation points
0 answers
Authentication failure in Azure postgresql database
Hello everyone, I am following these turotials to authenticate with Azure postgresql db with system assigned managed identity. I haven't deployed to code to azure app service, when i try to check the connection locally, I'm getting the error 'Password…
asked 2024-08-22T09:13:22.8333333+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(121.6, 67%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGR%3C/text%3E%3C/svg%3E)
Gokul R Dev
326
Reputation points
edited a comment 2024-08-23T10:04:50.27+00:00
Gokul R Dev
326
Reputation points
0 answers
Azure DB for PostgreSQL flexible server always show connection time out, Is the server running on that host and accepting TCP/IP
I built a Azure Database for PostgreSQL flexible server, and I did select "allow public access to this resource through the internet using a public IP address" and I did select "allow public access from any Azure service within service…
asked 2024-08-21T01:31:36.3266667+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, 26%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJH%3C/text%3E%3C/svg%3E)
Jialin Hua
0
Reputation points
commented 2024-08-22T22:47:12.75+00:00
Oury Ba-MSFT
18,436
Reputation points Microsoft Employee
0 answers
fatal: Authentication failed for 'https://express706323893.scm.azurewebsites.net/express706323893.git/'
alvin [ ~/cna-express ]$ git remote add azure $DEPLOYMENTURL git checkout -b master git commit -a -m "test" git push --set-upstream azure master error: remote azure already exists. fatal: a branch named 'master' already exists On branch…
asked 2024-08-20T05:42:23.6066667+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, 13%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAT%3C/text%3E%3C/svg%3E)
alvin tan
0
Reputation points
edited a comment 2024-08-22T14:45:18.8933333+00:00
GeethaThatipatri-MSFT
29,117
Reputation points Microsoft Employee