How can I check what database level permissions are assigned to an azure ad security group in Azure postgres flexible server?
I have an azure database flexible server instance and created a role using SELECT * FROM pgaadauth_create_principal('azure ad security group name', false, false) and assigned permissions read, write permissions to it to a database. Now I want to list out…
Why does filled disk space not release immediatly (only during night) after dropping partitions of a table from Postgres database in Azure server?
I am making some experiments with partitions. I inserted about 20GB of data into a table with partitions, then I dropped the partitions. I wanted to check how fast I could insert data into the table and drop its partitions to release space in the disk to…
permission denied for schema _timescaledb_internal on Azure PostgreSQL flexible server
I tried to migrate db from Azure PostgreSQL single server to flexible server using migration tool from Azure portal. But there is an error on validation check because migration tool doesn't support timescaledb extension. Portal message said that…
The recommended certificate didn't work on Azure Database for PostgreSQL Single server in China east 2 region
Hi, I have a question about the Azure Database for PostgreSQL - Single Server (located in China East 2). We recently noticed that there is a warning message in the Azure portal, which is "As a part of routine certificate rotation, the root…
Connect from python Function app with managed identity to Azure Database for PostgreSQL- Flexible Server
Hi Everyone I have a python function app which is connecting to PostgreSQL- Flexible Server. I have used password authentication to connect the server. Now, I have to use managed identity to connect the server. I came across 2 different and not sure…
Postgresql flexible server on azure unplanned failover is not working in a Zoneredundant HA environment.
Hi all, On Azure we have a PostgreSQL-Server with Zone-redundant HA. When we trigger a forced Failover, the Server goes in the "Updating state" and that is the only information which we see about PostgreSQL flexible server on Azure. How we can…
Getting permission issue for pg_signal_backend in postgre16 in azure flexible server
Hi,We recently commisioned a new flexible server using latest postgresql 16 and at the same time created an Microsoft entra administrator for our server.After that we created a database 'Test' using our Microsoft entra administrator.Then when we intended…
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…
Certificates do not conform to algorithm
I am trying to deploy an application that uses PostgreSQL as database. (The application is Keycloak). I have tried deploying it using Azure postgres single server and Azure postgres flexible server. I would prefer to deploy it using flexible server as it…
Postgres Parameter Missing from Parameter List.
I am using Cosmos DB for Postgresql, with 2 worker node + 1 coordinator node. I want to set max_locks_per_transaction parameter for postgresql. I have a partioned table which I then sharded with Citus command, but I am unable to unshard, because I am…
Need Consistency levels in Azure Cosmos DB for Postgresql (like in NoSQL)
Hi, I came across with a data inconsistency in my Citus cluster, when I did classic money transfer test: init.sql: create table mytbl (id serial primary key, amount int); insert into mytbl(amount) select 0 from generate_series(1, 1234567); select…
Azure Postgresql how to create a CAST
Hello, I am currently in the process of configuring a database within Azure Database for PostgreSQL flexible server. However when i try to create two CAST objects i get the following error: ERROR: must be owner of type integer or type…
I was charged for an unused service and my student account has been disabled a
Hello, I was using the Azure for Students subscription to deploy my Python (Flask) web app as my personal project for learning, and I have created App Service with the MySQL database. I couldn't get it to work so I've abandoned the project, disabling the…
Azure PostgreSQL flexible server: Unable to transfer ownership of table
We are using posgres 16.0. When trying to transfer ownership of a table with ALTER TABLE schema.table OWNER TO "new_role" We get error: must be able to SET ROLE "new_role" We are logged in as azure_pg_admin user and have confirmed…
I can;t connect to postgresql: Service Principal oid mismatch for role.
Weird situation, I am able to connect to my postgresql flexible instance and can query the postgresql version, but after making a change on the query, for some reason I can't event connect: Service Principal oid mismatch for role[my_user] I didn't…
AZURE - General Data Protection Regulation (GDPR)
Hello everyone... in MS Azure is there a BAA document to download that specifies that they comply with the European GDPR regulations? We may have European clients and they will most likely ask us if our system complies with the standard. If that is the…
Connection Data Base for PostgreSQL flexible server
Hello everyone... is there any way to create an internal connection between the pods of my AKS cluster and the DB? In the single server version I seem to remember that there was a private endpoint. At this moment I am reading something from…
Unable to upgrade postgres version 15 to 16
Hi, I'm trying to upgrade postgres version 15 to 16 but it comes with an error message: { "code": "InternalServerError", "message": "An unexpected error occured while processing the request. Tracking ID:…
How to see auto_explain output in TEXT format in Azure Database for PostgreSQL flexible server
How to see auto_explain output in TEXT format in Azure Database for PostgreSQL flexible server?
Got a mail saying: Action Required for Azure Database for PostgreSQL – Flexible Server to update your trusted root store, if you are doing certificate pinning
I just got this in the mail, our applications are asp .net core microservices, we just connect using the basic configurations in appsettings.json. What impact does this update will have in our current setup…