Azure Database for PostgreSQL
An Azure managed PostgreSQL database service for app development and deployment.
844 questions
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.
910 questions
Azure Database for PostgreSQL
Azure Database for PostgreSQL
An Azure managed PostgreSQL database service for app development and deployment.
844 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
0
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,076
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,007
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
![](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,271
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,076
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,007
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,076
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,007
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)
1 answer
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
commented 2024-03-20T06:49:06.1133333+00:00
Maheswaran T
0
Reputation points
1 answer
How to fix web app deployment not loading - 504.0 GatewayTimeout
Hello, My web app does not load and instead times out after a few minutes to the 504.0 Gateway Timeout error. I am using the Azure Database for PostgreSQL flexible server and Azure Plan as the subscription and Node as the Runtime stack. Perhaps it is…
![](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(294.40000000000003, 38%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ED%3C/text%3E%3C/svg%3E)
![](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, 80%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDR%3C/text%3E%3C/svg%3E)
1 answer
Alerting on backups events for the managed automated backup
Hi we have a requirement to enable alerts on backup events (success/failed), for the automated backup solutions. Is there any metrics available to enable such alerts? I was following this similar question, and it seems like this was not there last year.…
asked 2024-03-05T11:36:41.38+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, 39%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVT%3C/text%3E%3C/svg%3E)
Vikrant Tyagi
0
Reputation points
commented 2024-03-19T13:23:31.64+00:00
Vikrant Tyagi
0
Reputation points
2 answers
One of the answers was accepted by the question author.
Azure Postgres Flexible - pg_signal_backend
We are attempting to use Azure Postgres Flexible Our application needs to terminate existing existing connection and then drop the database. This requires 'pg_signal_backend' https://www.postgresql.org/docs/current/predefined-roles.html However, this…
asked 2024-03-07T20:19:39.07+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(73.60000000000001, 89%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAP%3C/text%3E%3C/svg%3E)
Aaron Phethean
20
Reputation points
accepted 2024-03-18T15:27:37.74+00:00
Aaron Phethean
20
Reputation points
0 answers
Trigger Not working in PostgreSQL 13.12 (PAAS)
The trigger is not working in Postgres 13 (PAAS) but in the standalone Postgres 13 the triggers are working. The trigger is unable to call the respective function which will perform the insert from one table to another. Not getting any error also. Basic…
asked 2024-03-06T10:59:59.0533333+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(156.8, 88%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESR%3C/text%3E%3C/svg%3E)
Sudhan R, Madhu
0
Reputation points
commented 2024-03-18T05:19:53.8466667+00:00
Sudhan R, Madhu
0
Reputation points