Content
IOPS postgresql monitoring - meaning of absolute values in graphs
Hi. I have a slight problem understanding the metrics for IOPS. What do the absolute values/percentages in graphs represent? These are the absolute values This is the percentual usage Both graphs are from the same time span and with…


Command to find CPU Spike for PostgreSQL single server.
I am seeking a particular command or query that can furnish me with details about the query responsible for causing 100% CPU usage in Azure Database for PostgreSQL single server. The query store is already enabled on the server and also aware of Query…


Can I have a node in specific geo location
Hi, I am trying to figure out if Azure Citus is a good option for a multi-tenancy scenario where some tenants need to have their data store in specific geo region. This implies that we would have bulk of tenants on one node and some that need their data…


Monitor pgbouncer on Azure PostgreSQL Flexible Server
I'd like to create an Azure alert to monitor the pgBouncer process on PostgreSQL flexible servers and alert if the process is down. I believe port 6432 is used by pgBouncer, so monitoring if that port is up or not might be one way to do it.…


Unable to connect with Azure postgres with Terraform
Getting below error while trying to connect to postgres with terraform. pls help. Error: error detecting capabilities: error PostgreSQL version: dial tcp XX.XXX.XXX.XXX:5432: connectex: A connection attempt failed because the connected party did not…


How to enable extensions for Postgres Flexible Server without using psql client
Currently, enabling an extension for Postgres Flexible Server is done through several steps, of which we need to run the SQL command CREATE EXTENSION <EXTENSION_NAME> after server is started with a psql client. We are thinking of automating the…


Single Server to Flexible Server PostGIS raster bug
We are trying to migrate an Azure Single Server PostgreSQL 9.6 database to Azure Database for PostgreSQL Flexible Server v14 using the Migration tool. The migration keeps failing with no detailed error message, just: Error while processing. Please…
Azure CLI task was failing with ERROR: An error occurred. Pip failed with status code 1.
Hi Team, We are using azure CLI task in our pipeline to connect to our azure postgres flexi server to run scripts. Below is the task we have used. FYI : day before yesterday also the task works fine, but from yesterday onwards I am getting below…


Azure Postgresql Flexible Automatic Failover to another region
We are using Azure Postgresql Flexible server with West Europe as primary region. Is there Automatic failover to North Europe Incase of region outage in primary region? How do we move to Secondary region (North Europe) What is the best approach for…


PostgreSQL 15 Flexible Server
Hi, We are already using Azure Database for PostgreSQL 14- Flexible Server and planning to migrate to postgres 15 , but Flexible server for postgres 15 is not available. Could some one provide the tentative date when flexible server for postgres 15 will…


While I tried to import data into Microsoft SQL data management studio it is showing error
While try to import data via SQL Server 2022 import and export data into Microsoft SQL server management studio it showing this error


Azure PostgreSQL Flexible server - permission denied for table pg_authid
Hello, I am trying to get the object count of all the schema objects in PostgreSQL as part of validation after migrating from Oracle to Azure PostgreSQL. But, when I am executing the select statement, I am getting below error as the admin…


Code="InternalServerError" Message="An unexpected error occured while processing the request.
Hello, I'm trying to create a flexible server using terraform and I'm getting in return this error message: │ Error: creating Flexible Server (Subscription: "<my subscription id>" │ Resource Group Name:…


Add Azure Active Directory Administrators fails
Hi, I constantly failing with Adding Azure Active Directory Administrators (Azure AD Admins) on PostgreSQL Flexible Server. { "status": "Failed", "error": { "code": "DeploymentFailed", …


keeps saying that database "luluBase" does not exist DETAIL: The database subdirectory "pg_tblspc/16386/PG_14_202107181/24825" is missing.
Hello, When an attempt is made to access a postgres database, it throws this error (from wherever the attempt is made): psql: error: connection to server at "lulurestore.postgres.database.azure.com" (52.142.58.184), port 5432 failed: FATAL: …


Where to find Azure SLA documentation?
The Microsoft Azure SLA documentation could be found on the following URL: https://azure.microsoft.com/en-us/support/legal/sla/<productname> Like: https://azure.microsoft.com/en-us/support/legal/sla/postgresql/ But now all these URL's are being…


"An unexpected error occured while processing the request." when trying to create Azure Flexlible Postgresql Server
Recently, we did some changes in our terraform code that resulted in destroying and then re-creating our Flexible Postgres instance. For some reason, terraform is no longer able to create the database for us: ╷ │ Error: creating Flexible…


Azure Postgres SQL >16 TB
Hi Guys, We have a Postgres SQL Geater than 16 TB, i see Azure database postgres SQL supports only 16TB but who do we accommodate if its great than that? Regards, Navin


How to check if my function app is accessing resources in a vnet
Hello, I am trying to create a web app which takes data from an IOT hub and moves the data onto a database which is located on a server secured with a virtual network. To attempt to achieve this, I have created a function app which has public access…


postgres is not connecting to aks intermittently getting timedout
postgres is not connecting to aks intermittently getting timedout while we are trying yo access postgres from aks services and pods can you please us know what can be done to resolve this issue in postgres or aks configurations

