Azure Database for PostgreSQL
An Azure managed PostgreSQL database service for app development and deployment.
904 questions
0 answers
Get " https://management.azure.com/subscriptions/0444938f-8b72/resourceGroups/rg-prd-backend-db-psql/providers/Microsoft.DBforPostgreSQL/flexibleServers/psql--001?api-version=2023-06-01-preview" : context deadline exceeded
I have deployed Azure postgreSQL flexible server with version 16.2 using Terraform. It was working fine, since last week, post the HA is had an issue due to Azure policy we lost the connection to the DB server from Azure portal. We can see the db…
asked 2024-06-13T10:28:56.7366667+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, 47%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETD%3C/text%3E%3C/svg%3E)
Thennarasu Duraikannu
0
Reputation points
asked 2024-06-13T10:28:56.7366667+00:00
Thennarasu Duraikannu
0
Reputation points
1 answer
How to Handle Point-in-Time Restore with Azure PostgreSQL and Terraform?
Hello, I'm using an Azure PostgreSQL database and need to perform a point-in-time restore (PITR) as part of a disaster recovery drill. I can successfully restore the database to a new server and update my application to point to this new server. However,…
asked 2024-05-22T12:49:03.72+00:00
Kamal Rathnayake
26
Reputation points MVP
commented 2024-06-13T09:37:08.3266667+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(166.4, 20%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EM%3C/text%3E%3C/svg%3E)
MChogo
25
Reputation points
1 answer
Can I change to owner of a database in Azure Database for PostgreSQL flexible server?
I have a database created with the migration tool in the Azure Database for PostgreSQL flexible server. The migration tool sets the database owner as the server admin, and I want to change the owner to a different role. How do I do this? ALTER DATABASE…
asked 2024-06-12T19:41:39.73+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(76.8, 23%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKK%3C/text%3E%3C/svg%3E)
Kristine Kisman
0
Reputation points
answered 2024-06-12T22:39:30.09+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
5,306
Reputation points
2 answers
One of the answers was accepted by the question author.
Not able to Insert Image data for two images Postgresql
[HttpPost] [ValidateAntiForgeryToken] public async Task<IActionResult> Create([Bind("Sno,No,Topic,QuestionTitle,Opt1,Opt2,Opt3,Opt4,Answer,Time,Correct,Solution,Imagedata,Imagesol")] Question question, IFormFile…
asked 2024-06-11T19:37:32.6+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, 77%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EML%3C/text%3E%3C/svg%3E)
Maui Learner
520
Reputation points
accepted 2024-06-12T06:25:14.9933333+00:00
Maui Learner
520
Reputation points
1 answer
One of the answers was accepted by the question author.
Azure Database for PostgreSQL flexible server stuck in restart state
Hi, our Azure Database for PostgreSQL flexible server is stuck in restarting state. We noticed to late that storage is utilized 100% and now we can’t increase the instance or do any modifications. We can't even delete it, it just states that it is in…
![](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, 24%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJV%3C/text%3E%3C/svg%3E)
0 answers
Connection String to Grant Web App running .NET code access to PostgreSQL Flexible Server via Managed Identity
Hi, I need to deploy a webApp running .NET Code and Azure Database for PostgreSQL flexible server. Our policy is to grant webApps/functionApps access to SQL Server/MySql Server/PostgreSQL Server via Managed Identity. While, I can see connection strings…
Microsoft Identity Manager
Microsoft Identity Manager
A family of Microsoft products that manage a user's digital identity using identity synchronization, certificate management, and user provisioning.
632 questions
.NET
.NET
Microsoft Technologies based on the .NET software framework.
3,521 questions
Azure Database for PostgreSQL
Azure Database for PostgreSQL
An Azure managed PostgreSQL database service for app development and deployment.
904 questions
Azure App Service
Azure App Service
Azure App Service is a service used to create and deploy scalable, mission-critical web apps.
7,135 questions
1 answer
One of the answers was accepted by the question author.
Migrate PostgreSQL production database from AWS RDS to Azure PostgreSQL Flexible Server
We have moved our web apps from AWS ec2 instances to azure web apps but our database is still running on AWS RDS it’s a high traffic application and we cannot afford any downtime . any suggestion how can we move our production PostgreSQL db to azure…
![](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(92.8, 76%, 18%)' 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)
1 answer
Connecting Azure Database for PostgreSQL and Data Factory
Hello, I'd want to connect my Azure Database for PostgreSQL (from now on referred as DB) to use it as a dataset in Data Factory (from now on referred as ADF). My DB is in a private network in a resource group (rg_1) my ADF is public and is in a…
asked 2024-06-10T11:31:09.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(182.40000000000003, 65%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELB%3C/text%3E%3C/svg%3E)
Laura Balbi
0
Reputation points
commented 2024-06-11T09:18:58.1366667+00:00
Amira Bedhiafi
17,786
Reputation points
2 answers
Azure data factory
Dear Team, I need to copy a data from a single table to multiple tables with mapping of columns in azure data factory by connecting with a PostgreSQL server. only one source table and I need to send that source data to the multiple sink tables by…
asked 2024-05-28T07:10:35.32+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-06-10T08:29:07.41+00:00
PRADEEPCHEEKATLA-MSFT
82,041
Reputation points Microsoft Employee
1 answer
Reading credentials from azure failed: DefaultAzureCredential failed to retrieve a token from the included credentials.
0 I'm trying read azure default credentials but fails with following error DefaultAzureCredential failed to retrieve a token from the included credentials. 04:54:12.161 lrr-data-service-perf-green-x Attempted credentials: EnvironmentCredential:…
asked 2024-05-28T06:16:03.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(275.2, 6%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EYM%3C/text%3E%3C/svg%3E)
Yedukondalu Mammu
0
Reputation points
commented 2024-06-06T23:15:49.1166667+00:00
Oury Ba-MSFT
16,986
Reputation points Microsoft Employee
1 answer
Postgresql flexible server parameter set up is failing with server busy error
Hi, I am trying to deploy Azure Postgresql flexible server through Bicep and GHA pipelines, the deployment is failing in configuration step with the following error, i am trying to deploy pg 16 version. can someone please help with this…
asked 2024-05-31T04:21:03.9433333+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(169.60000000000002, 79%, 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)
Manikandan M
0
Reputation points
commented 2024-06-06T05:19:34.7133333+00:00
Manikandan M
0
Reputation points
1 answer
Deleting active connections in Azure Postgresql
I would like to delete active connections in my Azure SQL Database for Postgres. I have logged into the database as admin and tried: SELECT pg_terminate_backend(pid) FROM pg_stat_activity WHERE datname = 'postgres' AND pid <>…
asked 2022-02-17T19:49:54.363+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(166.4, 86%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EK%3C/text%3E%3C/svg%3E)
Kopl
166
Reputation points
commented 2024-06-05T17:40:34.3533333+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, 24%, 28%)' 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)
Manuel Alejandro De La Torre Santillan
0
Reputation points
2 answers
Azure Postgresql how to create a CAST
Hello, I am currently in the process of configuring a database within Azure Database for PostgreSQL flexible server. However when i try to create two CAST objects i get the following error: ERROR: must be owner of type integer or type…
asked 2023-09-20T14:27:04.6333333+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, 80%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELV%3C/text%3E%3C/svg%3E)
Laurens van der Stoep (NL)
35
Reputation points
commented 2024-06-05T10:56:24.22+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(240, 34%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELA%3C/text%3E%3C/svg%3E)
Lazar, Alexandru
0
Reputation points
4 answers
create sp to populate table from one db to another
Hi, how to create Store procedure to populate data from one database table to another database table and do we need to refresh or it will auto sync
asked 2024-05-21T02:56:37.6+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, 13%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVS%3C/text%3E%3C/svg%3E)
Vineet S
205
Reputation points
commented 2024-06-04T14:28:23.0166667+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,186
Reputation points Microsoft Employee
2 answers
Trying to create an Azure Database for PostgreSQL flexible server with same server name which was deleted
I am trying to create an Azure Database for PostgreSQL flexible server with same server name which was deleted using terraform but running into the below error. Tried creating using Azure Portal and no luck there as getting the same error there…
asked 2024-06-01T07:01:10.1633333+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(51.2, 28.999999999999996%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELJ%3C/text%3E%3C/svg%3E)
Likith Jutur
0
Reputation points
commented 2024-06-04T04:00:13.2033333+00:00
ShaktiSingh-MSFT
14,186
Reputation points Microsoft Employee
1 answer
After Postgresql flexible migration from 14 to 16 admin user can't ALTER other role anymore
Since migrating my flexible server to postgresql version 16 my admin user can't modify roles anymore. With version 16 it's mandatory to have WITH ADMIN OPTION on roles to be able to alter them. My problem is that it wasn't the case on version 14 and my…
asked 2024-05-21T09:38:21.5333333+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, 44%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDT%3C/text%3E%3C/svg%3E)
Davi, Thomas
0
Reputation points
commented 2024-06-03T19:27:22.47+00:00
GeethaThatipatri-MSFT
28,462
Reputation points Microsoft Employee
2 answers
Flexible PostgreSQL server not responsive for unknown reason
Our web server suddenly started to fail to connect to our PostgreSQL flexible server, and the portal is stuck with the message 'The server is currently in 'restarting' state. Please wait for the operation to complete. You can refresh to check status.…
asked 2024-05-28T13:37:10.3866667+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, 38%, 29%)' 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)
paxbun
0
Reputation points
commented 2024-06-03T16:20:50.13+00:00
Oury Ba-MSFT
16,986
Reputation points Microsoft Employee
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
Sina Salam
5,306
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
28,462
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
8,921
Reputation points Microsoft Employee