Azure Database for PostgreSQL
An Azure managed PostgreSQL database service for app development and deployment.
866 questions
3 answers
Azure backup vault for Postgresql Flexi instance
HI , Question on the long term backup for Azure postgresql flexi - as per the doc below https://learn.microsoft.com/en-us/azure/backup/backup-azure-database-postgresql-flex I observed that, after the successful backup, I see the backup files in object…
asked 2024-05-01T13:43:38.7333333+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, 85%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESD%3C/text%3E%3C/svg%3E)
subhash-DBA
20
Reputation points
commented 2024-05-03T16:07:05.1233333+00:00
Oury Ba-MSFT
16,471
Reputation points Microsoft Employee
0 answers
How i can access a PostgreSQL server DB in a VNet in Azure thorugh python runbook inside an Automation Account ?
Hello team, I have a problem statement, i have an automation account in azure in which i have a python runbook in that runbook i have a script to make a connection to postgreSQL DB server and do some transactions in the DB but the problem is now i have…
Azure
Azure
A cloud computing platform and infrastructure for building, deploying and managing applications and services through a worldwide network of Microsoft-managed datacenters.
974 questions
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,160 questions
Azure Automation
Azure Automation
An Azure service that is used to automate, configure, and install updates across hybrid environments.
1,126 questions
Azure Database for PostgreSQL
Azure Database for PostgreSQL
An Azure managed PostgreSQL database service for app development and deployment.
866 questions
asked 2024-05-03T13:04:21.4433333+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(176, 12%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKP%3C/text%3E%3C/svg%3E)
Koushik Purva Mahendra
25
Reputation points
asked 2024-05-03T13:04:21.4433333+00:00
Koushik Purva Mahendra
25
Reputation points
0 answers
How to create private endpoint for postgres SQL flexible server?
I am unable to create a private endpoint for my postgres SQL flexible server My bicep file is like this // Parameters param location string //param env string param nameAffix string param administratorLogin string // existing resource name params param…
asked 2024-05-03T02:54:55.9833333+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(204.8, 12%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKW%3C/text%3E%3C/svg%3E)
Kenny Wong (HK)
0
Reputation points
commented 2024-05-03T05:26:32.9+00:00
Deepanshu katara
4,985
Reputation points
2 answers
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…
asked 2024-04-10T14:26:01.65+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, 46%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMH%3C/text%3E%3C/svg%3E)
Mane Hambardzumyan
0
Reputation points
commented 2024-05-02T22:20:18.3133333+00:00
GeethaThatipatri-MSFT
27,642
Reputation points Microsoft Employee
0 answers
How to enable Azure Postgresql flexible server to have both High Availability and Storage Auto-grow scaling?
Based on the documentation, Azure Postgresql flexible server supports both High Availability and auto-growth storage, but it seems that I cannot select High Availability if I have auto-growth and vice versa. Why?
asked 2024-05-02T08:52:08.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(262.40000000000003, 83%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EL%3C/text%3E%3C/svg%3E)
Lippy
20
Reputation points
commented 2024-05-02T10:36:06.4933333+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
13,436
Reputation points Microsoft Employee
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)
25
Reputation points
accepted 2024-05-02T09:34:32.8666667+00:00
Anuj, Singh (Cognizant)
25
Reputation points
2 answers
Azure Postgresql Flexi instance - How to check the table creation date and time
HI Can someone help me to find the tables/objects create date/time in Azure postgresql flexi instance ? we used to use this one , select * from pg_stat_file( pg_relation_filepath('alert') ) in on-prem but that's not working in azure with admin user due…
asked 2024-04-24T02:29:38.51+00:00
subhash-DBA
20
Reputation points
commented 2024-05-01T13:38:32.0433333+00:00
subhash-DBA
20
Reputation points
2 answers
One of the answers was accepted by the question author.
Subject: Updating Extension Versions Without Superuser Privileges in Azure Database for PostgreSQL - Flexible Server
Hello, I am working with Azure Database for PostgreSQL - Flexible Server and am trying to update the vector extension from version 0.4.1 to 0.5.1. However, I've encountered a couple of issues due to the lack of superuser privileges, which are not…
asked 2023-12-15T09:55:18.3766667+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(0, 90%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJ2%3C/text%3E%3C/svg%3E)
JipyeongChoi-2795
25
Reputation points
accepted 2024-05-01T05:19:22.9033333+00:00
JipyeongChoi-2795
25
Reputation points
1 answer
How can I change location in Azure Database for PostgreSQL flexible server?
How can I change location in Azure Database for PostgreSQL flexible server? source location - East US Destination location - East US 2
asked 2024-04-30T10:15:10.5266667+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(252.8, 19%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESA%3C/text%3E%3C/svg%3E)
Sonam Agrawal
0
Reputation points
answered 2024-04-30T17:54:01.7966667+00:00
GeethaThatipatri-MSFT
27,642
Reputation points Microsoft Employee
1 answer
One of the answers was accepted by the question author.
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…
asked 2024-04-10T15:49:08.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(243.2, 26%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPK%3C/text%3E%3C/svg%3E)
Peter Koller
40
Reputation points
accepted 2024-04-30T09:53:44.9366667+00:00
Peter Koller
40
Reputation points
1 answer
One of the answers was accepted by the question author.
Azure PostgreSQL Flexible server: Unable to drop roles
We are having some weird issues when trying to remove roles. I am connected as the admin user that is member of azure_pg_admin. When trying to remove a role with DROP ROLE role_to_drop We get the error "Could not drop the role. Only roles with the…
asked 2024-04-10T13:20:19.3+00:00
Peter Koller
40
Reputation points
accepted 2024-04-30T09:53:19.7266667+00:00
Peter Koller
40
Reputation points
1 answer
Private enpoint options missing from PostgreSQL Flexible Server
I'm trying to set up a private endpoint for a public facing PostgreSQL flexible server, but the option is missing from the Networking tab of my database. I have other databases that have this option and I've successfully set up links to virtual networks…
asked 2024-04-25T17:18:03.29+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(192, 91%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJ%3C/text%3E%3C/svg%3E)
James
10
Reputation points
answered 2024-04-29T16:06:48.3233333+00:00
GeethaThatipatri-MSFT
27,642
Reputation points Microsoft Employee
1 answer
Slowness issue in database
Database is migrated from Oracle to Postgresql. In pg database insert query is running longer and taking 3Hours to complete where as same insert query is taking 30 sec at oracle platform.
asked 2024-04-26T11:33:46.1733333+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(80, 45%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EIM%3C/text%3E%3C/svg%3E)
IQBAL, MOHAMMAD
0
Reputation points
answered 2024-04-29T08:12:27.2233333+00:00
ShaktiSingh-MSFT
13,436
Reputation points Microsoft Employee
2 answers
One of the answers was accepted by the question author.
what is the best Partitioning Strategy in Azure Database for Postgresql
what is the best Partitioning Strategy in Azure Database for Postgresql
asked 2024-04-26T12:46:34.47+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, 86%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENK%3C/text%3E%3C/svg%3E)
Naveen Kumar Kakarla (Quadrant Resource)
161
Reputation points
answered 2024-04-26T17:07:28.93+00:00
Oury Ba-MSFT
16,471
Reputation points Microsoft Employee
1 answer
Setting up trigger using SUPERUSER on Azure Database for PostgreSQL - Flexible Server
I manage a PostgreSQL database for my organisation which is set up on an Azure Database for PostgreSQL - Flexible Server. My issue is that other users need to be able to CREATE objects in the database, however when they do that they are automatically…
asked 2024-04-25T11:16:56.9333333+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, 91%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKM%3C/text%3E%3C/svg%3E)
Kia Mack
0
Reputation points
commented 2024-04-26T16:00:08.58+00:00
GeethaThatipatri-MSFT
27,642
Reputation points Microsoft Employee
1 answer
Connect from python Function app with managed identity to Azure Database for PostgreSQL- Flexible Server
Hi Everyone I have a python function app which is connecting to PostgreSQL- Flexible Server. I have used password authentication to connect the server. Now, I have to use managed identity to connect the server. I came across 2 different and not sure…
![](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(252.8, 35%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ES%3C/text%3E%3C/svg%3E)
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…
asked 2024-04-17T11:08:26.95+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(140.8, 21%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMS%3C/text%3E%3C/svg%3E)
Michiteru Sugitani
50
Reputation points
commented 2024-04-25T16:42:47.4+00:00
GeethaThatipatri-MSFT
27,642
Reputation points Microsoft Employee
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…
asked 2024-04-18T15:24:54.75+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(64, 87%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EXL%3C/text%3E%3C/svg%3E)
Xiaoyun Liao
40
Reputation points
commented 2024-04-25T14:33:46.31+00:00
Xiaoyun Liao
40
Reputation points
2 answers
Azure database for PostgreSQL Flexible Server - RPO
Hi, Propose to use Azure database for PostgreSQL Flexi Server (HA+ Read Replica) for our one of the business-critical application. I have gone through the article.…
asked 2024-03-12T16:20:43.8633333+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(32, 37%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMT%3C/text%3E%3C/svg%3E)
Maheswaran T
0
Reputation points
answered 2024-04-25T11:28:45.2166667+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(60.8, 68%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAK%3C/text%3E%3C/svg%3E)
Alicja Kucharczyk
180
Reputation points Microsoft Employee
1 answer
One of the answers was accepted by the question author.
Why does filled disk space not release immediatly (only during night) after dropping partitions of a table from Postgres database in Azure server?
I am making some experiments with partitions. I inserted about 20GB of data into a table with partitions, then I dropped the partitions. I wanted to check how fast I could insert data into the table and drop its partitions to release space in the disk to…
asked 2024-04-23T09:04:56.3566667+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, 59%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDD%3C/text%3E%3C/svg%3E)
Diogo dos Santos
20
Reputation points
accepted 2024-04-25T10:49:12.7966667+00:00
Diogo dos Santos
20
Reputation points