Issue Restoring Backup from Azure Database for PostgreSQL to VM Deployed PostgreSQL
Hello, I've encountered an issue while attempting to restore a backup from an Azure Database for PostgreSQL to a PostgreSQL instance deployed on a VM. Details: Source: Azure Database for PostgreSQL Version: PostgreSQL 14.11 on x86_64-pc-linux-gnu,…
![](https://techprofile.blob.core.windows.net/images/9CqRWkWyk0WIvV6eSiSD-g.png?8DB6B7)
After deleting a postgres flexible server the name is still taken
After deleting a postgres flexible server, the server name remains unusable. The name is specific enough to assume no one else is using this name. The server was setup in a Vnet thus creating an automatic private dns zone record. There might be a hint to…
Postgres Flexible Server - Segmentation Fault
We have a small database running on Azure Postgres Flexible Server. Since May 30th of 2024, we've been running into Segmentation Fault Whenever a particular procedure is called, which has a Temporary table involved When I use a base table instead, it…
After Postgresql flexible migration from 14 to 16 admin user can't ALTER other role anymore
Since migrating my flexible server to postgresql version 16 my admin user can't modify roles anymore. With version 16 it's mandatory to have WITH ADMIN OPTION on roles to be able to alter them. My problem is that it wasn't the case on version 14 and my…
![](https://techprofile.blob.core.windows.net/images/HY3oKwjtqEayHWip33wClQ.png?8D91E9)
Ability to grant admin user ADMIN option in Azure PostgreSQL Flexible Server version 16
I have created a new flexible server at version 16 with 2 admins: Postgres admin called "adminuser" Microsoft Entra admin called "entraadmin" (visible at Security - Authentication on portal) My use case is to transfer ownership…
![](https://techprofile.blob.core.windows.net/images/9CqRWkWyk0WIvV6eSiSD-g.png?8DB6B7)
pg_stat_statements Extension issue in Azure Database for PostgreSQL flexible server
pg_stat_statements extension is enabled in Azure Database for PostgreSQL flexible server, but when I run the command select * from pg_stat_statements it is giving ERROR: relation "pg_stat_statements" does not exist
![](https://techprofile.blob.core.windows.net/images/9CqRWkWyk0WIvV6eSiSD-g.png?8DB6B7)
How to Shrink Azure Postgres Flexible Storage With Minimal Downtime
Could you help me shrink the storage of an Azure PostgreSQL Flexible Server from 2000GB to a more appropriate because used space is only 300GB? The issue was occurred when the database on auto-grow and the storage consumption suddenly increased from…
![](https://techprofile.blob.core.windows.net/images/kjzQAO5Oq0Oj37wdNf6qTQ.png?8D8E42)
Azure PostgreSQL flexible server stuck in restart state
I tried to restart my Azure Database for PostgresSQL flexible server now more than two days ago and it is still stuck in the restarting status. I initiated the restart because it wouldn't show me the list of databases so I could manually connect to them…
error fetching from postgres, err: x509: certificate signed by unknown authority
i have i virtual network where in 1 subnet my aks cluster is present and another subnet my private postgress flexible server is present. i am connecting my application from aks cluster to private postgress server through private network using…
How do I migrate a PostgreSQL database from Single Server to Flex Server, change the users to Entra authenticated, and then migrate the database again without users?
I want to migrate a PostgreSQL database from Azure Single Server to Azure Flex Server. Then drop all database users from the Azure Flex Server database and add them back in as Entra authenticated users and set their permissions. Then I want to script…
Postgre-SQL Flexible Server - pg_cron permissions and alternative
Hi everyone, a customer is using Azure PGSQL Flexible server to provide database managed services for its internal customers. The internal customers are used to work on-prem with job schedulers like pg__cron or pg__timetable. After migrating their…
![](https://techprofile.blob.core.windows.net/images/0Ll-SHZePUetqUTMg1J81A.png?8D7EDA)
My Azure Server Admin has CreateRole rights disabled for Azure Database for Postgresql Flexible server
In the Azure Database for Postgresql, Recently the CreateRole rights have been revoked for the Server Admin user. Due to this, I am not able to create new users or roles in the system. Please help me to enable the create role access for the Azure Server…
Azure postgresql flex can i use local AD group synced to Azure AD for access to DB
Azure postgresql flex can i use local AD group synced to Azure AD for access to DB in Azure flex postgres
![](https://techprofile.blob.core.windows.net/images/kjzQAO5Oq0Oj37wdNf6qTQ.png?8D8E42)
Cannot connect to Azure DB for PostgresSQL flexible from different vnet
Hi, we cannot connect from an AKS pod running in one VNET to an Azure DB for PostgreSQL flexible server running in a different VNET. We can connect from an AKS pod running in the same VNET. The error is demonstrated by running curl from the pod: curl -v…
![](https://techprofile.blob.core.windows.net/images/kjzQAO5Oq0Oj37wdNf6qTQ.png?8D8E42)
Can you install extensions for Azure Data Studio when you are offline ?
We want to install Azure Data Studio (ADS) onto a server - and add the postgres extension. (The postgres database is local, not in Azure). The server has no internet access. We can download an installer for ADS and install it with no internet…
Create Function with LANGUAGE c gets ERROR: permission denied for language c
We are migrating a database from PostgresSQL single server to flexible server using psql to dump and restore. All those functions with 'language c' would return ERROR: permission denied for language c A sample function like this: CREATE OR…
What happens to Azure Database for PostgreSQL - Single Server Reservations after the retirement announcement?
As I know, Azure Database for PostgreSQL - Single Server is on the retirement path and is scheduled for retirement by March 28, 2025. In case I bought 1-year reservation on May 1, 2024 and the reservation will expire on May 1, 2025 exceed retirement…
![](https://techprofile.blob.core.windows.net/images/vub1NJcKNEmWqsNK_A71uw.png?8DA872)
Error while creating new indexes on Azure database
Hello The migration from on premise to Azure has been done with success with all the metadata and data the 18/06/2024. It included indexes. At this time we had no errors. Now we want to try to create new BTREE indexe on our database but it fails with the…
![](https://techprofile.blob.core.windows.net/images/9CqRWkWyk0WIvV6eSiSD-g.png?8DB6B7)
az account get-access-token command issue
Hi All, We are using below command to get the JWT token for login to Postgres single server. az account get-access-token --resource-type oss-rdbms -o tsv --query accessToken However this command earlier returing the all groups of the lodded in user but…
![](https://techprofile.blob.core.windows.net/images/kjzQAO5Oq0Oj37wdNf6qTQ.png?8D8E42)
azure database for postgres フレキシブルサーバーTLS証明書の更新について
現在azure database for postgres フレキシブルサーバーを利用しているのですが、azureからルートストアに関する証明書の更新について通知がありました。そこでは、クライアント側にて既存で利用しているDigicert グローバル ルート CAと併せて、Microsoft RSA Root Certificate Authority…