Azure Database for PostgreSQL
An Azure managed PostgreSQL database service for app development and deployment.
941 questions
2 answers
One of the answers was accepted by the question author.
Do I need to use Azure NAT Gateway for outbound internet access for Azure Container Apps or Azure Database for PostgreSQL?
Hi everyone, I would like to ask whether I need to use Azure NAT Gateway for outbound access to the internet? Insight: I have Hub and Spoke network topology implemented, in the Hub VNET there is an Azure Firewall and Azure VPN Gateway. I've setup Azure…
asked 2024-05-31T16:22:41.7766667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(105.60000000000001, 60%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAD%3C/text%3E%3C/svg%3E)
Alberto Dasilvon
40
Reputation points
answered 2024-05-31T23:02:40.14+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(246.4, 4%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESS%3C/text%3E%3C/svg%3E)
Sina Salam
7,201
Reputation points
1 answer
Missing Query Duration Information in Azure PostgreSQL Logs
We are currently running PostgreSQL as a Flexible Server on Azure and have configured Azure Diagnostics to log queries. However, we are encountering an issue where the duration of the queries is not consistently logged in the Message column or the…
asked 2024-05-31T11:55:04.8166667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(89.60000000000001, 36%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAA%3C/text%3E%3C/svg%3E)
Anand Advani
5
Reputation points
answered 2024-05-31T19:01:27.31+00:00
GeethaThatipatri-MSFT
29,012
Reputation points Microsoft Employee
2 answers
PostgreSQL Flexible Server in restart for extended period
I have a flexible server database that has been restarting for nearly four hours. It usually takes about 10 minutes to cycle the server. It shows some intermittent availability and response to queries, but it still has the status alert and doesn't show…
asked 2024-05-31T18:01:56.62+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(57.599999999999994, 76%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECP%3C/text%3E%3C/svg%3E)
Carl Peterson
0
Reputation points
answered 2024-05-31T18:14:25.0633333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(236.8, 79%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERR%3C/text%3E%3C/svg%3E)
Rahul Randive
9,176
Reputation points Microsoft Employee
2 answers
Connect PowerBI Service to Azure PostgreSQL for Flexible Server via Vnet data gateway
Hi team, Can I connect PowerBI Service to Azure PostgreSQL for Flexible Server via Vnet data gateway. If yes then can you please tell me the steps
asked 2023-05-10T11:35:33.51+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 76%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDP%3C/text%3E%3C/svg%3E)
Dinesh Prajapati
126
Reputation points
commented 2024-05-30T16:21:49.4833333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(220.8, 87%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKN%3C/text%3E%3C/svg%3E)
Konda, Naveen Kumar
0
Reputation points
1 answer
Can't create Azure Database for PostgreSQL in West Europe. Problems between different regions?
As the title says, I can't create an Azure Database for PostgreSQL in West Europe because it gives this error. Nearest one would be France South. My fist question is, is this fixable, or any reason for this that I can change and haven't figured out yet?…
asked 2024-05-16T12:31:23.18+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(227.2, 54%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EII%3C/text%3E%3C/svg%3E)
Iñigo Paños Basterra
20
Reputation points
commented 2024-05-29T19:48:28.21+00:00
GeethaThatipatri-MSFT
29,012
Reputation points Microsoft Employee
2 answers
Can't enable private link with my newly created read replica server
Hi! I have a postgres SQL flexible server that is created in March 2023, I am not able to enable the private link because the server is created too long ago. I just created read replica server, but it has the same issue that I can't find private link…
asked 2024-05-17T23:17:19.1033333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(134.4, 64%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EE%3C/text%3E%3C/svg%3E)
Ecccoyao
0
Reputation points
commented 2024-05-28T16:03:10.7966667+00:00
GeethaThatipatri-MSFT
29,012
Reputation points Microsoft Employee
2 answers
Azure PostgreSQL Flexible Server - Creating Database in pgAdmin tool
Hi, I am using Azure Database for PostgreSQL Flexible Servers, I cannot create database in pgAdmin due to missing privileges for pg_default tablespace. I cannot find that in documentation, could you confirm that creating databases are possible only in…
asked 2024-05-28T12:25:39.03+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(25.6, 61%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKI%3C/text%3E%3C/svg%3E)
Karol IL
0
Reputation points
commented 2024-05-28T15:47:24.7533333+00:00
GeethaThatipatri-MSFT
29,012
Reputation points Microsoft Employee
1 answer
Scheduled Backup doe not stop
Hello, i have a running Backup Job, that does not stop. It's running for over 24h now. I tried to stop it via GUI, which is not possible; also via Powershell / CLI which also failed. The GUI has no "Stop" button. The Powershell / CLI claims…
asked 2024-05-24T05:34:58.8566667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 14.000000000000002%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAF%3C/text%3E%3C/svg%3E)
Andreas Frisch
0
Reputation points
commented 2024-05-27T11:22:47.89+00:00
SadiqhAhmed-MSFT
41,141
Reputation points Microsoft Employee
1 answer
Azure PostgreSQL flexible Server Database Managed Identity connection
Hello, -We have created Azure postgres Flexible server with Microsoft Entra Authentication only deployment as Paas in Azure subscription. -We have added Azure Service Principal into Database admin user via Azure portal. We have created Azure VM and…
asked 2024-05-19T12:23:47.7566667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(38.4, 46%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMR%3C/text%3E%3C/svg%3E)
Maruthuvel Ramachandran
5
Reputation points
answered 2024-05-24T05:23:48.54+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(220.8, 4%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESM%3C/text%3E%3C/svg%3E)
ShaktiSingh-MSFT
14,376
Reputation points Microsoft Employee
1 answer
One of the answers was accepted by the question author.
How can I manage the Virtual Network of an Azure PostgresSQL Flexible server after changing the DB's subscription?
I'm trying to move my cloud resources into a new Subscription. I was able to successfully move an Azure Database for PostgresSQL to a new subscription, however the attached virtual network cannot be changed. Per MSFT documentation, the attached virtual…
asked 2024-05-20T17:40:53.9533333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(70.4, 19%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESC%3C/text%3E%3C/svg%3E)
Steve Christy
45
Reputation points
commented 2024-05-23T17:39:49.4766667+00:00
Oury Ba-MSFT
17,791
Reputation points Microsoft Employee
1 answer
Need to know ETA of reservations support for V5 instance series of Azure Database for PostgreSQL flexible server.
We need to know ETA of reservations support for V5 instance series of Azure Database for PostgreSQL flexible server, as we're thinking to upgrading all of our servers to V5 along with taking benefit of reservations for it.
asked 2023-10-02T13:46:13.6666667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(147.20000000000002, 99%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENC%3C/text%3E%3C/svg%3E)
Nayan Chhabhaiya
5
Reputation points
commented 2024-05-22T20:12:12.2333333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(35.2, 73%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENR%3C/text%3E%3C/svg%3E)
Nygård Ronny
0
Reputation points
1 answer
Failedto load PostgreSQL Flexible serverdatabases
Hi everyone Maybe who knows what is going on?
asked 2024-05-06T10:26:10.36+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(275.2, 64%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAL%3C/text%3E%3C/svg%3E)
Alexander Lapin
60
Reputation points
commented 2024-05-22T09:46:03.12+00:00
Alexander Lapin
60
Reputation points
1 answer
AZURE DATA FACTORY STORED PROCEDURE WITH POSTGRESQL SERVER
Dear Microsoft Support, I have created a stored procedure in a PostgreSQL server and established a linked service for that server in Azure Data Factory (ADF). My goal is to execute this stored procedure within a pipeline in ADF. However, when I attempt…
asked 2024-05-21T05:42:27.17+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(259.20000000000005, 17%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESV%3C/text%3E%3C/svg%3E)
Sai Varma Eswararaju
0
Reputation points
commented 2024-05-22T05:06:12.4833333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(268.8, 8%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EST%3C/text%3E%3C/svg%3E)
Smaran Thoomu
12,615
Reputation points Microsoft Vendor
1 answer
One of the answers was accepted by the question author.
Do you know how to install the 'ODBC Driver 17 for PostgreSQL' on a Azure Databricks cluster?
I am attempting to run postgreSQL stored procedures , through Azure Databricks notebook. We have stored procedure written in Azure Database for PostgreSQL and we want to run postgreSQL stored procedures through Azure Databricks Notebook (using…
asked 2024-04-30T11:06:56.06+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(96, 57.99999999999999%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAS%3C/text%3E%3C/svg%3E)
Anuj, Singh (Cognizant)
50
Reputation points
commented 2024-05-22T04:46:59.1066667+00:00
Anuj, Singh (Cognizant)
50
Reputation points
1 answer
One of the answers was accepted by the question author.
Azure Synapse Analytics | Pipeline | Linked Service to "Azure Database for PostgreSQL" not available in 'Stored Procedure'
Hi everyone, I am trying to create a simple pipeline in Azure Synapse Analytics which should write some files' metadata fields into a Database. To do so, I first created a linked service to a postresql database instance hosted on Azure: I am now trying…
asked 2024-05-21T10:06:49.0933333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(297.6, 21%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELP%3C/text%3E%3C/svg%3E)
Lorenzo Perino
20
Reputation points
accepted 2024-05-21T18:43:34.6533333+00:00
Lorenzo Perino
20
Reputation points
3 answers
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…
asked 2024-04-13T15:44:47.7833333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(105.60000000000001, 54%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAC%3C/text%3E%3C/svg%3E)
Armando Cordova
5
Reputation points
answered 2024-05-21T11:18:27.05+00:00
GeethaThatipatri-MSFT
29,012
Reputation points Microsoft Employee
0 answers
Azure Data Factory managed private endpoint to Azure PostgresSQL flexible server
In my infra I have a Vnet with two subnets: application-subnet delegated-subnet The Azure Data Factory instance is on application-subnet. The Azure PostgreSQL flexible server is in delegated-subnet and is configured with Private Access (VNET…
asked 2023-09-28T13:25:22.0633333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(153.6, 40%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3E_B%3C/text%3E%3C/svg%3E)
_Esteban Bett
30
Reputation points
commented 2024-05-21T08:24:09.8733333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(268.8, 79%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAJ%3C/text%3E%3C/svg%3E)
Andreas Jansen
0
Reputation points
4 answers
Anon extension is not loading in postgresql flexible server version 15.3
I am trying to load "anon" extension for postgresql flexible server (15.3) . ( for "anon" referring this https://postgresql-anonymizer.readthedocs.io/en/latest/ ) however I always get this error . SQL Error [22023]: ERROR:…
asked 2023-09-18T11:34:32.89+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(211.20000000000002, 45%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPP%3C/text%3E%3C/svg%3E)
Prasad Patil
5
Reputation points
answered 2024-05-21T04:20:21.4866667+00:00
ShaktiSingh-MSFT
14,376
Reputation points Microsoft Employee
1 answer
One of the answers was accepted by the question author.
How to migrate database users from Azure PostgreSQL single server to flexible server?
Hello team, I was using the migration tool provided in Azure portal to migrate databases from PostgreSQL single server to flexible server.The migration itself was successful and I could see my database and data in the flexible server. The issue I am…
asked 2024-05-06T18:47:09.7233333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(217.60000000000002, 15%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EP%3C/text%3E%3C/svg%3E)
Pratik
20
Reputation points
commented 2024-05-20T19:32:27.9466667+00:00
Oury Ba-MSFT
17,791
Reputation points Microsoft Employee
1 answer
One of the answers was accepted by the question author.
Using key vault to customize the encryption keys at rest for Azure Database PostgreSQL imply any cost on for encrypt/decrypt operations?
Hi, Based on the pricing for Key Vault, encryption/decryption operations via API are charged. My question is, does this also imply cost for PostgreSQL DBaaS using custom encryption keys stored in Azure Key Vault or the cost for encrypting/decrypting…
Azure Key Vault
Azure Key Vault
An Azure service that is used to manage and protect cryptographic keys and other secrets used by cloud apps and services.
1,184 questions
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,068 questions
Azure Database for PostgreSQL
Azure Database for PostgreSQL
An Azure managed PostgreSQL database service for app development and deployment.
941 questions
asked 2024-05-20T09:07:22.4+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(185.6, 72%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJL%3C/text%3E%3C/svg%3E)
José Luis Rando Calvo
20
Reputation points
accepted 2024-05-20T13:54:12.81+00:00
José Luis Rando Calvo
20
Reputation points