Azure Database for PostgreSQL
An Azure managed PostgreSQL database service for app development and deployment.
932 questions
1 answer
Automate postgresql scripts using azure devops
Hi Can you please let me know how we can automate the deployment of postgresql scripts( tables, functions etc) using Azure Devops pipeline. Creation of role for managed identity also. Thanks
asked 2021-07-08T01:53:13.503+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, 35%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAG%3C/text%3E%3C/svg%3E)
Abhay Gupta
71
Reputation points
commented 2021-07-20T00:00:10.68+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, 44%, 29%)' 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)
Saurabh Sharma
23,781
Reputation points Microsoft Employee
1 answer
Find best activity for implemet ML scenario in Azure Data Factory
I'm new to Azure Data Factory. I want to implement the below scenario and I want to know which activity is suitable for this scenario. My data is on the Postgres database. Our data factory an activity copies data from the Postgres database. …
asked 2021-07-09T16:09:29.29+00:00
Mohsen Akhavan
746
Reputation points
commented 2021-07-16T18:35:53.703+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, 26%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHM%3C/text%3E%3C/svg%3E)
HimanshuSinha-msft
19,376
Reputation points Microsoft Employee
2 answers
How to display mutiple values from multiple table using single id?
How to get multiple values from multiple table in matching of Single Id using PostgreSQL query, here is the sample table. CREATE TABLE emp_tbl( emp_id INT PRIMARY KEY NOT NULL, name VARCHAR(50), ); CREATE TABLE sal_tbl( sal_id INT PRIMARY KEY…
asked 2021-07-13T14:31:38.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(256, 89%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMA%3C/text%3E%3C/svg%3E)
muhammed arif
1
Reputation point
commented 2021-07-15T09:47:10.34+00:00
muhammed arif
1
Reputation point
1 answer
How to join multiple table (getting mutiple values like array) using single ID?
How to get multiple values for same ID in row by row for a join multiple table using single ID. Here is sample, DB Postgresql. Table 1 :emp_tbl ID dep_id name dept. 1 10001 name1 xxxx 2 10001 name2 …
asked 2021-07-09T10:19:19.233+00:00
muhammed arif
1
Reputation point
commented 2021-07-15T07:01:04.503+00:00
muhammed arif
1
Reputation point
2 answers
One of the answers was accepted by the question author.
Azure Database for PostgreSQL Support for CMK in Norway
Are there plans to support large server and consequently CMK in Norway regions for Azure Database for PostgreSQL?
asked 2021-07-06T07:28:56.297+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(144, 71%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EME%3C/text%3E%3C/svg%3E)
Marcus Engebretsen
21
Reputation points
commented 2021-07-14T14:37:26.46+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, 97%, 38%)' 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)
Anurag Sharma
17,586
Reputation points
1 answer
pgdump to local machine
Hi, I have canceled my azure subscription and have 90 days to secure my data. I want to do a pgdump from my postges db to my local hard disk. I have found this post: …
asked 2021-07-12T11:14:15.523+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, 63%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELL%3C/text%3E%3C/svg%3E)
Larry Lüer
1
Reputation point
commented 2021-07-14T07:28:48.21+00:00
Anurag Sharma
17,586
Reputation points
1 answer
postgres sql server not visible on azure portal under RG, but able to connect locally
Unable to view postgresql server on azure portal, able to connect it locally but its not visible under my Resource Group, Can't find it in my current subscription. Its costing us a lot and we wish to delete the unused postgresql Server.
asked 2021-07-06T06:17:01.21+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, 81%, 28%)' 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)
Shivangi Devgun
31
Reputation points
commented 2021-07-13T13:55:18.273+00:00
Anurag Sharma
17,586
Reputation points
1 answer
One of the answers was accepted by the question author.
Please provide documentation on how to set a Service Principal as an AD Administrator
Hi Please provide the steps/documentation on how to set service principal as the Azure AD admin for the postgresql server. I am trying to do all this through terraform. Once the service principal is AAD i want to run few create role commands on the…
asked 2021-07-05T12:57:01.887+00:00
Abhay Gupta
71
Reputation points
accepted 2021-07-10T01:44:04.327+00:00
Abhay Gupta
71
Reputation points
2 answers
One of the answers was accepted by the question author.
Azure Database for postgresql with basic tier is not allowed with ARM template
112622-02postgresqlazurejson.txtI am trying to create a ARM for postgresql single server. But continuously getting below error {"code":"DeploymentFailed","message":"At least one resource deployment operation…
asked 2021-07-07T13:50:44.167+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(3.2, 17%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESK%3C/text%3E%3C/svg%3E)
Sumit Kumar
101
Reputation points
accepted 2021-07-09T03:06:01.847+00:00
Sumit Kumar
101
Reputation points
1 answer
Cannot connect to the server [primary domain name] when trying to Authenticate with AD to PostgreSQL
Hi Folks, Im trying to follow this documentation, so I can authenticate to PostgreSQL using AAD https://video2.skills-academy.com/en-us/azure/postgresql/howto-configure-sign-in-aad-authentication I set the DB AD Admin as the authenticating…
asked 2021-06-18T01:13:43.883+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(48, 49%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJD%3C/text%3E%3C/svg%3E)
Jonasta dos Santos
1
Reputation point
commented 2021-07-08T05:58:51.197+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(195.2, 0%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVM%3C/text%3E%3C/svg%3E)
VipulSparsh-MSFT
16,251
Reputation points Microsoft Employee
1 answer
Fetch the data from Rest APi and load into Postgresql table dynamically using azure data factory
I have two API, one is to give the counts of the api and second api gives the data . Using copy activity ,I can fetch the data and load into destination table . API contains body and header which we need to pass in source under copy activity Under…
asked 2021-06-15T10:03:00.787+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(41.6, 14.000000000000002%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMN%3C/text%3E%3C/svg%3E)
Meghana Nikam
1
Reputation point
commented 2021-07-07T22:20:16.127+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(172.8, 70%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMM%3C/text%3E%3C/svg%3E)
MartinJaffer-MSFT
26,051
Reputation points
1 answer
Azure DMA tool for Postgres ?
Whenever we migrate on-premises SQL server to Azure, we use the Azure DMA (data Migration Assistant) Or the DMS The DMA assessment gives if any migration blockers etc . If i have to migrate on-premises Postgres DB into Azure Postgres database…
asked 2021-06-18T10:24:56.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(96, 71%, 19%)' 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)
MS Techie
2,686
Reputation points
commented 2021-07-07T14:51:43.057+00:00
Oury Ba-MSFT
17,631
Reputation points Microsoft Employee
1 answer
'waittimeout' server parameter in azure database for postgresql ?
Team, Do we have 'waittimeout' server parameter in azure database for postgresql (single server) just like how we have on azure mysql PAAS ???? . if so, what is it?? I would like to change this value on azure for an connection related intermittent…
asked 2021-07-05T04:03:31.91+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(208, 87%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESU%3C/text%3E%3C/svg%3E)
sql user
86
Reputation points
commented 2021-07-07T09:51:09.3+00:00
Anurag Sharma
17,586
Reputation points
1 answer
One of the answers was accepted by the question author.
Azure Database for PostgreSQL - tablespaces
Hello, Is it posible to create tablespaces in an Azure Database for PostgreSQL instance? Thanks. Regards
asked 2021-06-28T13:08:39.323+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, 16%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETG%3C/text%3E%3C/svg%3E)
TERCERO GOMES Antonio
21
Reputation points
commented 2021-06-30T06:06:35.32+00:00
TERCERO GOMES Antonio
21
Reputation points
0 answers
Unable to connect to Azure Postgresql, timeout expired. Even restart doesn't help.
Hi all, So in short, it seems my Azure PostgreSQL went into limbo. I've been experiencing issues with connection after psql server encountered several errors below OperationalError: SSL SYSCALL error: EOF detected OperationalError:…
asked 2021-06-22T16:06:48.727+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, 70%, 27%)' 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)
EggDev
1
Reputation point
commented 2021-06-23T15:55:26.657+00:00
Oury Ba-MSFT
17,631
Reputation points Microsoft Employee
1 answer
Alert for Long running/blocking queries for azure database for postgresql
Hello Experts. We have a azure database for postgresql hosted and we would like to have an alert email sent for long running queries and blocking happening on PAAS instance. can you please suggest with queries and steps? . We have already enabled…
1 answer
Azure Postgres Server with AAD authentication
I am trying using Azure Postgres for my application backend and realize that I can't use username and password I normally use. I need to generate the token and then use token as password. reference:…
asked 2021-06-07T17:38:25.887+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, 56.00000000000001%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESG%3C/text%3E%3C/svg%3E)
Shah, Gaurang
1
Reputation point
commented 2021-06-15T19:44:29.13+00:00
Oury Ba-MSFT
17,631
Reputation points Microsoft Employee
1 answer
how to elimilate the cost of azure for postgresql
In https://azure.microsoft.com/en-us/free/students/, I see Azure Database for PostgreSQL NEW DATABASES 750 hours So I use the following command to create azure postgresql: az group create -n postgres -l westus az postgres server create -n…
asked 2021-06-13T04:47:55.567+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(233.6, 89%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECG%3C/text%3E%3C/svg%3E)
chaowen guo
16
Reputation points
commented 2021-06-15T07:03:21.243+00:00
Anurag Sharma
17,586
Reputation points
1 answer
Postgresql 11 archive_mode
Hello, For a project, we need to ensure if the server parameter of a postgresql server in Azure has the right value : archive_mode=true I do not find any reference on this subject. If anyone as a clue, thank you very much ;) BR, Pascal
asked 2021-06-08T10:03:10.353+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, 65%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPM%3C/text%3E%3C/svg%3E)
Pascal Minery
1
Reputation point
commented 2021-06-14T23:18:46.52+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(281.6, 93%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENS%3C/text%3E%3C/svg%3E)
Navtej Singh Saini
4,221
Reputation points Microsoft Employee
0 answers
I can't open a new connection to the database after a success database connection (Azure)
Describe the issue We use Azure Managed PostgreSQL (11). I connect successfuly to the database from spring boot application. While connecting i disable GSS Encryption (gssEncMode=disable) But after approximately 15 minutes all the other connections…
asked 2021-06-02T13:39:43.413+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, 1%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMA%3C/text%3E%3C/svg%3E)
mohammed azeroual
1
Reputation point
commented 2021-06-07T15:23:08.96+00:00
Oury Ba-MSFT
17,631
Reputation points Microsoft Employee