847 questions with Azure Database for PostgreSQL tags

Sort by: Updated
3 answers One of the answers was accepted by the question author.

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…

Azure Database for PostgreSQL
asked 2023-08-11T08:12:39.71+00:00
Pitawat 331 Reputation points
commented 2024-04-22T10:08:04.14+00:00
Marco Araujo 0 Reputation points
3 answers

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…

Azure Database for PostgreSQL
Azure App Service
Azure App Service
Azure App Service is a service used to create and deploy scalable, mission-critical web apps.
6,838 questions
asked 2023-04-06T11:54:46.88+00:00
Hedgelot 65 Reputation points
answered 2024-04-22T07:17:26.23+00:00
Julian Gimbel 6 Reputation points Microsoft Employee
1 answer

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…

Azure Cosmos DB
Azure Cosmos DB
An Azure NoSQL database service for app development.
1,439 questions
Azure Database for PostgreSQL
asked 2024-04-18T10:33:49.4066667+00:00
Vishnu Agarwal 0 Reputation points
commented 2024-04-22T03:44:40.38+00:00
ShaktiSingh-MSFT 13,271 Reputation points Microsoft Employee
1 answer

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 Cosmos DB
Azure Cosmos DB
An Azure NoSQL database service for app development.
1,439 questions
Azure Database for PostgreSQL
asked 2024-04-17T14:14:28.9133333+00:00
Konstantin Morozov 0 Reputation points
edited the question 2024-04-21T00:28:08.8466667+00:00
GeethaThatipatri-MSFT 27,017 Reputation points Microsoft Employee
2 answers

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…

Azure Database for PostgreSQL
asked 2023-09-20T14:27:04.6333333+00:00
Laurens van der Stoep (NL) 35 Reputation points
answered 2024-04-19T16:19:59.39+00:00
Javier Andres Veliz Miranda 0 Reputation points
0 answers

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…

Azure Database for PostgreSQL
asked 2024-04-18T15:24:54.75+00:00
Xiaoyun Liao 40 Reputation points
commented 2024-04-19T13:52:56.26+00:00
Xiaoyun Liao 40 Reputation points
1 answer

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 Cost Management
Azure Cost Management
A Microsoft offering that enables tracking of cloud usage and expenditures for Azure and other cloud providers.
2,012 questions
Azure Database for PostgreSQL
asked 2024-04-18T13:17:46.2933333+00:00
Tomasz Kalus (tomakal079) 0 Reputation points
edited the question 2024-04-19T09:38:09.5033333+00:00
VenkateshDodda-MSFT 18,056 Reputation points Microsoft Employee
1 answer

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…

Azure Database for PostgreSQL
asked 2024-04-17T11:08:26.95+00:00
Michiteru Sugitani 50 Reputation points
commented 2024-04-18T14:06:41.7866667+00:00
GeethaThatipatri-MSFT 27,017 Reputation points Microsoft Employee
1 answer

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…

Azure Database for PostgreSQL
asked 2024-04-10T15:49:08.4833333+00:00
Peter Koller 0 Reputation points
edited an answer 2024-04-17T16:51:50.58+00:00
GeethaThatipatri-MSFT 27,017 Reputation points Microsoft Employee
0 answers

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 Database for PostgreSQL
asked 2024-04-13T22:14:22.9666667+00:00
Armando Cordova 0 Reputation points
commented 2024-04-17T15:24:58.4+00:00
GeethaThatipatri-MSFT 27,017 Reputation points Microsoft Employee
2 answers

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…

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,851 questions
Azure Database for PostgreSQL
asked 2024-04-11T13:40:45.42+00:00
Sebastian Pacheco 116 Reputation points
commented 2024-04-17T00:43:12.76+00:00
kobulloc-MSFT 23,336 Reputation points Microsoft Employee
2 answers

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…

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,851 questions
Azure Database for PostgreSQL
asked 2024-04-03T16:17:50.22+00:00
Sebastian Pacheco 116 Reputation points
commented 2024-04-17T00:42:03.0766667+00:00
kobulloc-MSFT 23,336 Reputation points Microsoft Employee
1 answer

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

Azure Database for PostgreSQL
asked 2024-04-10T21:24:25.7+00:00
TIen Vo 5 Reputation points
commented 2024-04-16T12:25:39.5766667+00:00
Pankaj Awaghad 0 Reputation points
1 answer

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?

Azure Database for PostgreSQL
asked 2024-04-14T17:06:16.3866667+00:00
commented 2024-04-16T09:56:28.65+00:00
Vinodh247-1375 11,036 Reputation points
1 answer

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…

Azure Database for PostgreSQL
asked 2024-04-16T04:13:00.5533333+00:00
Saurav 20 Reputation points
commented 2024-04-16T06:08:08.1266667+00:00
ShaktiSingh-MSFT 13,271 Reputation points Microsoft Employee
1 answer

Connecting to Azure Database for PostgreSQL using Azure AD

we are trying to connect to azure postgres DB using AD & followed the instructions provided in the below documentation url https://learn.microsoft.com/en-us/azure/postgresql/howto-configure-sign-in-aad-authentication Getting below error while…

Azure Database for PostgreSQL
Microsoft Entra ID
Microsoft Entra ID
A Microsoft Entra identity service that provides identity management and access control capabilities. Replaces Azure Active Directory.
19,403 questions
asked 2020-11-11T06:50:39.733+00:00
RamZ 1 Reputation point
answered 2024-04-15T11:24:40.31+00:00
Armando Cordova 0 Reputation points
1 answer

pgaadauth_create_principal does not exist in my flexible postgresql instance

I am trying to create users that I will later use to log in from my kubernetes service. I have set up 2 admins for this database 1. being a user group on which I am added and the other being a service principal. I tried to use the create_principal…

Azure Database for PostgreSQL
asked 2024-04-13T15:44:47.7833333+00:00
Armando Cordova 0 Reputation points
answered 2024-04-13T23:14:01.1166667+00:00
GeethaThatipatri-MSFT 27,017 Reputation points Microsoft Employee
0 answers

The Azure Database for PostgreSQL -flexible server metric connections_failed doesn't always have a value

Hello everyone, I have faced an issue regarding Azure Database for PostgreSQL -flexible server metrics, which I hoped someone here can help me solve it. I have an Azure Database for PostgreSQL - flexible server, which has an alert configured on it, so I…

Azure Database for PostgreSQL
asked 2024-03-11T11:51:20.82+00:00
Zeinab Khosravi 40 Reputation points
commented 2024-04-11T23:51:19.0066667+00:00
GeethaThatipatri-MSFT 27,017 Reputation points Microsoft Employee
1 answer

Why I can not create WEB App + Database

I can not create Azure WEB APP + Database. I am trying to create Django backed with PostgresSQL with the following parameters: Region UK West Python 3.10 PosgresSQL - Fixable Server (recommended) Azure Cache for Redis - NO Hosting plan - Standart…

Azure Database for PostgreSQL
asked 2024-04-10T14:26:01.65+00:00
Mane Hambardzumyan 0 Reputation points
answered 2024-04-11T15:44:56.32+00:00
Mane Hambardzumyan 0 Reputation points
1 answer

How do I pg_dump/pg_dumpall from Azure postgres Flexi to azure files/storage?

HI All, We are in the process of designing a new monitoring platform in Azure which Azure Postgresql Flexi server. From database support/operation perspective can some one help me to understand the following. I am new to Azure How do we use…

Azure Database for PostgreSQL
asked 2024-04-11T01:47:37.97+00:00
subhash-DBA 0 Reputation points
answered 2024-04-11T13:14:03.6466667+00:00
GeethaThatipatri-MSFT 27,017 Reputation points Microsoft Employee