Azure Database for PostgreSQL
An Azure managed PostgreSQL database service for app development and deployment.
866 questions
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…
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-04-13T23:14:01.1166667+00:00
GeethaThatipatri-MSFT
27,642
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…
asked 2024-03-11T11:51:20.82+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(214.4, 82%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EZK%3C/text%3E%3C/svg%3E)
Zeinab Khosravi
40
Reputation points
commented 2024-04-11T23:51:19.0066667+00:00
GeethaThatipatri-MSFT
27,642
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"…
asked 2024-04-10T15:10:44.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(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
answered 2024-04-10T20:44:48.5366667+00:00
GeethaThatipatri-MSFT
27,642
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
asked 2024-04-10T01:17:54.12+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-10T04:27:34.31+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
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…
asked 2024-04-08T03:06:59.1966667+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(256, 19%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERK%3C/text%3E%3C/svg%3E)
Ricky Kusuma
5
Reputation points
answered 2024-04-08T08:03:46.1166667+00:00
ShaktiSingh-MSFT
13,436
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…
asked 2023-02-10T02:16:00.56+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(224.00000000000003, 44%, 31%)' 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)
Artur Drobinskiy
0
Reputation points
edited a comment 2024-04-05T07:34:07.2266667+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(160, 10%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAM%3C/text%3E%3C/svg%3E)
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.
asked 2024-02-15T18:17:01.92+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(256, 81%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGJ%3C/text%3E%3C/svg%3E)
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.
970 questions
Azure Database for PostgreSQL
Azure Database for PostgreSQL
An Azure managed PostgreSQL database service for app development and deployment.
866 questions
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…
asked 2022-07-13T09:44:58.137+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(160, 95%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELM%3C/text%3E%3C/svg%3E)
Luna Marinelli, Mario
6
Reputation points
commented 2024-04-04T07:22:07.7666667+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, 68%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKL%3C/text%3E%3C/svg%3E)
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.
asked 2024-04-01T21:01:22.3633333+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(124.80000000000001, 17%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBJ%3C/text%3E%3C/svg%3E)
Burket, Joseph
20
Reputation points
commented 2024-04-03T17:00:06.78+00:00
Oury Ba-MSFT
16,471
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?
asked 2024-03-23T05:35:12.85+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(118.4, 11%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENW%3C/text%3E%3C/svg%3E)
Nowak, Wawrzyniec
20
Reputation points
edited the question 2024-04-02T23:29:50.7166667+00:00
GeethaThatipatri-MSFT
27,642
Reputation points Microsoft Employee
2 answers
One of the answers was accepted by the question author.
Can you add the postgis extension to an azure flexible server with postgres 16?
Hello, I am trying to upgrade our Azure Database for PostgreSQL flexible server to use postgres 16 and i need to add the postgis extension. At the moment we do this via a pipeline which adds the extension to azure.extension however this now gives the…
asked 2023-12-01T11:17:28.1833333+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(131.20000000000002, 71%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERS%3C/text%3E%3C/svg%3E)
Russell Soper
50
Reputation points
answered 2024-04-02T13:44:26.6966667+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(99.2, 96%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAT%3C/text%3E%3C/svg%3E)
Artieda Trigueros, Jorge
15
Reputation points
1 answer
Cannot connect on 6432 while promoting read replica
I use Azure Flexible Server for PostgreSQL and Read Replica. To the main server I connect on 6432 port since using pgbouncer. Before promoting replica I turn on pgbouncer (using az cli) on replica as well but after promotion I cannot connect on port…
asked 2024-04-02T05:11:50.7466667+00:00
Nowak, Wawrzyniec
20
Reputation points
answered 2024-04-02T06:07:50.84+00:00
ShaktiSingh-MSFT
13,436
Reputation points Microsoft Employee
1 answer
One of the answers was accepted by the question author.
I am trying to provision a Azure Cosmos DB for PostgreSQL Cluster instance using arm template but I don't see a field to set the database name.
I am following this doc - https://learn.microsoft.com/en-us/azure/templates/microsoft.dbforpostgresql/servergroupsv2?pivots=deployment-language-arm-template to provision a Azure Cosmos DB for PostgreSQL Cluster but there is no field to specify the…
asked 2024-04-01T09:18:58.1233333+00:00
Anshul Sharma
20
Reputation points
commented 2024-04-01T16:50:47.6366667+00:00
Anshul Sharma
20
Reputation points
1 answer
Can not RESTART STOP Postgresql flexible server
Can not restart/stop the server InternalServerError) An unexpected error occured while processing the request. Tracking ID: '8dd3b591-1d09-4077-94eb-7d496f686926' Code: InternalServerError
asked 2024-03-28T21:48:43.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(118.4, 11%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELD%3C/text%3E%3C/svg%3E)
LAL, DEEPAK
0
Reputation points
commented 2024-03-29T16:01:02.38+00:00
Oury Ba-MSFT
16,471
Reputation points Microsoft Employee
2 answers
Activate pg_cron
Hello everyone.... we need to run some cron in 2 databases that I have in an instance of "Azure Database for PostgreSQL flexible server". For this, enable "azure.extensions -> pg_cron" from the portal, then it seems that I must…
asked 2024-03-21T13:59:40.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(310.4, 18%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESP%3C/text%3E%3C/svg%3E)
Sebastian Pacheco
116
Reputation points
edited a comment 2024-03-28T11:47:11.71+00:00
GeethaThatipatri-MSFT
27,642
Reputation points Microsoft Employee
1 answer
One of the answers was accepted by the question author.
Is password history enforcing feature available in Azure managed postgres server ?
Hi, We are trying to enable password history enforcing feature for our azure managed postgres server. But we are unable to find it. I would like to know if postgresql has this feature? Appreciate your help. Thank you.
asked 2024-03-27T08:53:56.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(224.00000000000003, 74%, 31%)' 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)
Srikanth Dusa
156
Reputation points
accepted 2024-03-27T18:10:35.01+00:00
Srikanth Dusa
156
Reputation points
1 answer
How to load balance traffic across Azure DB for PostgreSQL Flex Read Replicas
If we have an Azure DB for PostgreSQL Flex, with a number of read replicas and a number of clients (assume a number of VMs), how can the clients load balance the traffic across the different read replicas?
asked 2024-03-21T16:11:56.86+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(67.2, 47%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EI%3C/text%3E%3C/svg%3E)
IonutMandra
0
Reputation points
commented 2024-03-26T21:58:40.8+00:00
Oury Ba-MSFT
16,471
Reputation points Microsoft Employee
2 answers
How to restore Azure database for postgre single server, if it's Redundancy option is configured as Geo-restore
Hello, I have one production Azure database postgre single server which is configured as below Backup Redundancy options: Geo-restore Backup Retention Period: 7days If I want to restore this database using Azure portal which is configured as…
asked 2024-03-21T18:32:42.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(150.4, 15%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHG%3C/text%3E%3C/svg%3E)
Himanshu Garg
0
Reputation points
commented 2024-03-25T17:03:21.6866667+00:00
GeethaThatipatri-MSFT
27,642
Reputation points Microsoft Employee
4 answers
One of the answers was accepted by the question author.
How to install de SPQLODBC drivers to use IB in Windows ARM
I have being trying to install the drivers psqlODBC_x64 to connect BI to our database, but as several trys I didn't have success, any one has any idea how could it be done?
![](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(150.4, 79%, 24%)' 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)