Microsoft Q&A

Azure Database for PostgreSQL

505 questions

An Azure managed PostgreSQL database service for app development and deployment.

Browse all Azure tags

505 questions with Azure Database for PostgreSQL tags

Sort by: Updated
Updated Created Answers
0 answers

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…

Azure Database for PostgreSQL
asked 2023-03-16T14:24:36.54+00:00
Ľubomíra Trnavská 0 Reputation points
commented 2023-03-22T22:22:57.7033333+00:00
Oury Ba-MSFT 10,251 Reputation points Microsoft Employee
1 answer

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…

Azure Database for PostgreSQL
asked 2023-03-22T11:26:48.86+00:00
KT 0 Reputation points
edited an answer 2023-03-22T19:44:11.34+00:00
Oury Ba-MSFT 10,251 Reputation points Microsoft Employee
1 answer

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…

Azure Database for PostgreSQL
asked 2023-03-20T20:39:42.22+00:00
93316825 0 Reputation points
commented 2023-03-22T14:38:45.09+00:00
GeethaThatipatri-MSFT 16,401 Reputation points Microsoft Employee
3 answers One of the answers was accepted by the question author.

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.…

Azure Database for PostgreSQL
asked 2022-09-27T13:22:51.83+00:00
psvo 21 Reputation points
edited the question 2023-03-22T14:12:24.0666667+00:00
GeethaThatipatri-MSFT 16,401 Reputation points Microsoft Employee
0 answers

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…

Azure Database for PostgreSQL
asked 2023-03-09T09:13:15.38+00:00
Nitin Naidu (Consultant) 21 Reputation points
commented 2023-03-21T14:47:29.4166667+00:00
GeethaThatipatri-MSFT 16,401 Reputation points Microsoft Employee
0 answers

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…

Azure Database for PostgreSQL
asked 2023-03-15T07:44:27.1966667+00:00
Koh, Hong D. (MBLQ 91) 0 Reputation points
commented 2023-03-21T06:37:43.6566667+00:00
ShaktiSingh-MSFT 5,681 Reputation points Microsoft Employee
0 answers

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 Database Migration service
Azure Database for PostgreSQL
asked 2023-03-09T06:40:49.6766667+00:00
WHS One 1 Reputation point
commented 2023-03-20T07:22:31.05+00:00
WHS One 1 Reputation point
3 answers

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 Database for PostgreSQL
asked 2023-03-17T04:52:27.7166667+00:00
Prudhvi Tavva 6 Reputation points
answered 2023-03-20T05:51:34.81+00:00
ShaktiSingh-MSFT 5,681 Reputation points Microsoft Employee
2 answers

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…

Azure Database for PostgreSQL
asked 2023-03-10T12:07:58.1733333+00:00
Mohan Kumar S 0 Reputation points
commented 2023-03-16T11:16:13.5633333+00:00
ShaktiSingh-MSFT 5,681 Reputation points Microsoft Employee
1 answer One of the answers was accepted by the question author.

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…

Azure Database for PostgreSQL
asked 2023-02-14T07:34:17.38+00:00
Kumari, Mrinal 25 Reputation points
commented 2023-03-15T10:34:46.1133333+00:00
Stavros Koureas 1 Reputation point
1 answer

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 Database for PostgreSQL
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
1,947 questions
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
9,057 questions
SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,053 questions
asked 2023-03-13T18:16:52.37+00:00
Sumayya A S 0 Reputation points
answered 2023-03-14T06:45:52.9166667+00:00
Olaf Helper 27,051 Reputation points
4 answers

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…

Azure Database for PostgreSQL
asked 2023-03-08T13:01:17.2433333+00:00
Sivakesava Naidu, Kuchi 0 Reputation points
commented 2023-03-13T15:01:07.0566667+00:00
GeethaThatipatri-MSFT 16,401 Reputation points Microsoft Employee
0 answers

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:…

Azure Database for PostgreSQL
asked 2022-08-25T19:24:51.887+00:00
Nolfi, Simone (Consultant) 11 Reputation points
commented 2023-03-10T23:39:10.1433333+00:00
Oury Ba-MSFT 10,251 Reputation points Microsoft Employee
1 answer One of the answers was accepted by the question author.

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", …

Azure Database for PostgreSQL
asked 2023-03-06T13:39:19.1066667+00:00
Solnar, David 76 Reputation points
accepted 2023-03-10T10:09:27.2233333+00:00
Solnar, David 76 Reputation points
0 answers

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: …

Azure Database for PostgreSQL
asked 2023-03-03T00:13:28.42+00:00
Umar Ahmad 0 Reputation points
commented 2023-03-09T18:18:52.3933333+00:00
Oury Ba-MSFT 10,251 Reputation points Microsoft Employee
2 answers

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…

Azure Database for PostgreSQL
asked 2023-03-06T12:11:08.5366667+00:00
Jan Baggen 0 Reputation points
commented 2023-03-08T20:48:30.2166667+00:00
GeethaThatipatri-MSFT 16,401 Reputation points Microsoft Employee
1 answer One of the answers was accepted by the question author.

"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 Database for PostgreSQL
asked 2022-11-02T20:09:34.297+00:00
Sławomir Nowak 26 Reputation points
edited a comment 2023-03-08T18:53:01.2366667+00:00
Oury Ba-MSFT 10,251 Reputation points Microsoft Employee
3 answers

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

Azure Database for PostgreSQL
asked 2023-03-02T15:00:14.1833333+00:00
Navin Dondapati 836 Reputation points
edited a comment 2023-03-08T15:38:48.6466667+00:00
GeethaThatipatri-MSFT 16,401 Reputation points Microsoft Employee
2 answers

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…

Azure Database for PostgreSQL
Azure Virtual Network
Azure Virtual Network
An Azure networking service that is used to provision private networks and optionally to connect to on-premises datacenters.
1,268 questions
Azure Functions
Azure Functions
An Azure service that provides an event-driven serverless compute platform.
2,784 questions
asked 2023-03-07T04:52:18.2466667+00:00
John Fahey 0 Reputation points
answered 2023-03-08T13:20:04.17+00:00
MughundhanRaveendran-MSFT 12,126 Reputation points Microsoft Employee
1 answer

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

Azure Database for PostgreSQL
Azure Kubernetes Service (AKS)
Azure Kubernetes Service (AKS)
An Azure service that provides serverless Kubernetes, an integrated continuous integration and continuous delivery experience, and enterprise-grade security and governance.
1,196 questions
asked 2023-03-05T07:15:08.4666667+00:00
Dilipkumar Nomula 0 Reputation points
commented 2023-03-07T18:00:01.93+00:00
GeethaThatipatri-MSFT 16,401 Reputation points Microsoft Employee