890 questions with Azure Database for PostgreSQL tags

Sort by: Updated
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,469 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,996 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,469 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,977 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
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,135 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 19,301 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,895 questions
Azure Database for PostgreSQL
asked 2024-04-11T13:40:45.42+00:00
Sebastian Pacheco 136 Reputation points
commented 2024-04-17T00:43:12.76+00:00
kobulloc-MSFT 24,321 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,895 questions
Azure Database for PostgreSQL
asked 2024-04-03T16:17:50.22+00:00
Sebastian Pacheco 136 Reputation points
commented 2024-04-17T00:42:03.0766667+00:00
kobulloc-MSFT 24,321 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,476 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,996 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,856 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 5 Reputation points
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,977 Reputation points Microsoft Employee
1 answer

Azure Postgres Flexible server: Unable to add azure_storage extension

We are unable to add a the azure_storage extension to a second database. We got it to work on the default postgres database but when trying to add it to a second database with CREATE EXTENSION azure_storage; We get role "azure_storage_admin"…

Azure Database for PostgreSQL
asked 2024-04-10T15:10:44.06+00:00
Peter Koller 40 Reputation points
answered 2024-04-10T20:44:48.5366667+00:00
GeethaThatipatri-MSFT 27,977 Reputation points Microsoft Employee
1 answer

– “FATAL: ERROR: could not extend file "base/24834/32917": No space left on device

while copying data via ora2pg getting below error message. Please suggest where space need to be added. – “FATAL: ERROR:  could not extend file "base/24834/32917": No space left on device

Azure Database for PostgreSQL
asked 2024-04-10T01:17:54.12+00:00
IQBAL, MOHAMMAD 5 Reputation points
answered 2024-04-10T04:27:34.31+00:00
ShaktiSingh-MSFT 13,996 Reputation points Microsoft Employee
2 answers

Postgres HA - zone redundant availability Southeast Asia

Based on the following article https://learn.microsoft.com/en-us/azure/postgresql/flexible-server/overview#azure-regions the Azure Database for PostgreSQL - Flexible Server in Southeast Asia has a capability of Zone Redundant HA, however when i created…

Azure Database for PostgreSQL
asked 2024-04-08T03:06:59.1966667+00:00
Ricky Kusuma 5 Reputation points
answered 2024-04-08T08:03:46.1166667+00:00
ShaktiSingh-MSFT 13,996 Reputation points Microsoft Employee
4 answers

Problem with pg_dumpall in PostgreSQL Flexible Server

I have an Azure Database for PostgreSQL flexible server (version 12). I'm trying to upgrade using the official docs (the goal is to upgrade to 14). The first step is to dump the roles pg_dumpall -r --host=mySourceServer --port=5432 --username=myUser…

Azure Database for PostgreSQL
asked 2023-02-10T02:16:00.56+00:00
Artur Drobinskiy 0 Reputation points
edited a comment 2024-04-05T07:34:07.2266667+00:00
Azeem, Muhammad 10 Reputation points
1 answer One of the answers was accepted by the question author.

Is Azure Postgresql Flex server HIPAA COMPLIANT

I want to if Is Azure Postgresql Flex server HIPAA COMPLIANT that I am using to build Datawarehouse.

Azure Database for PostgreSQL
asked 2024-02-15T18:17:01.92+00:00
Grover, Jyoti 40 Reputation points
accepted 2024-04-04T14:59:50.2166667+00:00
Grover, Jyoti 40 Reputation points
1 answer One of the answers was accepted by the question author.

PostgreSQL Flex - storing Terrabytes of data and setting up scheduled pipelines

is it ok to store and manage Terabytes of data? 2.Azure functions or Azure Data factory and Azure Databricks which one is best business practice to use to schedule pipelines.

Azure
Azure
A cloud computing platform and infrastructure for building, deploying and managing applications and services through a worldwide network of Microsoft-managed datacenters.
1,005 questions
Azure Database for PostgreSQL
asked 2023-12-18T21:29:12.5+00:00
Grover, Jyoti 40 Reputation points
accepted 2024-04-04T14:59:22.8666667+00:00
Grover, Jyoti 40 Reputation points
2 answers

Pgrouting for PostgreSql Azure flexible server does not appear as extension to allow even when is recently supported by Azure

I have running a Postgres 13.6 Azure flexible server database. We have tried to have pgrouting extension working in combination with postgis. Early this year the extension was not supported by Azure to be installed in our database however has…

Azure Database for PostgreSQL
asked 2022-07-13T09:44:58.137+00:00
Luna Marinelli, Mario 6 Reputation points
commented 2024-04-04T07:22:07.7666667+00:00
Kiani Lannoye 5 Reputation points
1 answer One of the answers was accepted by the question author.

Can you change a postgresql flexserver parameter using an Azure policy / remediation ?

Would like to be able to use an Azure policy to audit and change the connection throttling from off to on (for security) for a large number of PostgreSQL flex servers.

Azure Database for PostgreSQL
asked 2024-04-01T21:01:22.3633333+00:00
Burket, Joseph 20 Reputation points
commented 2024-04-03T17:00:06.78+00:00
Oury Ba-MSFT 16,891 Reputation points Microsoft Employee
1 answer One of the answers was accepted by the question author.

PostgreSQL with read replica in same delegated subnet

Hi, as far as I understand I can assign both main PostgreSQL flexible server and its Read Replica to the same delegated subnet. Should I somehow add some configuration or Azure will be smart enough to assign free IPs from the subnet to the Replica?

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.
2,205 questions
Azure Database for PostgreSQL
asked 2024-03-23T05:35:12.85+00:00
Nowak, Wawrzyniec 20 Reputation points
edited the question 2024-04-02T23:29:50.7166667+00:00
GeethaThatipatri-MSFT 27,977 Reputation points Microsoft Employee