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…
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
![](https://techprofile.blob.core.windows.net/images/ceTxnDfcK06RxIl7TYl8nA.png?8D9C3A)
![](https://techprofile.blob.core.windows.net/images/kjzQAO5Oq0Oj37wdNf6qTQ.png?8D8E42)
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…
![](https://techprofile.blob.core.windows.net/images/kjzQAO5Oq0Oj37wdNf6qTQ.png?8D8E42)
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":…
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:…
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…
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…
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…
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,…
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…
![](https://techprofile.blob.core.windows.net/images/kjzQAO5Oq0Oj37wdNf6qTQ.png?8D8E42)
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…
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…
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…
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…
![](https://techprofile.blob.core.windows.net/images/hAFzqf2_AwAAAAAAAAAAAA.png?8DB62B)
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…
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…
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…
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…
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…
![](https://techprofile.blob.core.windows.net/images/kjzQAO5Oq0Oj37wdNf6qTQ.png?8D8E42)
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…
![](https://techprofile.blob.core.windows.net/images/9CqRWkWyk0WIvV6eSiSD-g.png?8DB6B7)