Azure Database for PostgreSQL
An Azure managed PostgreSQL database service for app development and deployment.
865 questions
2 answers
Why is my Django Web App with Azure Database for Postgresql slow?
In the past week we have set up a Django web app on Azure App Service which connects to an Azure Database for Postgresql. However, it seems to be very slow for even the most basic API calls (we use Django Rest Framework). Basic API calls take at least 2…
asked 2020-12-30T13:50:37.153+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, 74%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EON%3C/text%3E%3C/svg%3E)
Octopi Nederland B.V
1
Reputation point
answered 2022-12-12T18:25:16.563+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(6.4, 74%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHI%3C/text%3E%3C/svg%3E)
huxaiphaer idris
6
Reputation points
2 answers
albumid is not defind using kedogrid
I am working with kendogrid I am trying to fill data in kendogrid and i search lot of solution link on google I spend more and more hours but not find solution I am tried need help please see my what I tried till now: I am tried and tried but…
ASP.NET
ASP.NET
A set of technologies in the .NET Framework for building web applications and XML web services.
3,266 questions
Azure Database for PostgreSQL
Azure Database for PostgreSQL
An Azure managed PostgreSQL database service for app development and deployment.
865 questions
C#
C#
An object-oriented and type-safe programming language that has its roots in the C family of languages and includes support for component-oriented programming.
10,272 questions
asked 2022-12-07T15:18:22.79+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(44.800000000000004, 2%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERP%3C/text%3E%3C/svg%3E)
Rahul Patil
26
Reputation points
commented 2022-12-10T13:04:58.517+00:00
AgaveJoe
26,136
Reputation points
1 answer
One of the answers was accepted by the question author.
Incompatibilities to consider while migrating data from azure sql to azure database for postgres
I observed there are few things to consider before migrating data from azure sql to azure database for postgres like Data Types Syntax Would like to more incompatibilities to consider or review before migration. Thank you
asked 2022-12-07T05:10:37.19+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(272, 24%, 36%)' 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)
Satya Sri
46
Reputation points
commented 2022-12-08T19:37:35.023+00:00
GeethaThatipatri-MSFT
27,642
Reputation points Microsoft Employee
1 answer
Azure data studio on Mac can't start extensions
Hi everyone, My ADS on mac shows the underneath message on open. I tried to connect to my postgres server but it load indefinetly. Am I missing something? KR
asked 2022-11-30T10:48:34.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(246.4, 7.000000000000001%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPR%3C/text%3E%3C/svg%3E)
pascalle rovers
11
Reputation points
commented 2022-12-08T11:38:10.643+00:00
pascalle rovers
11
Reputation points
1 answer
Update extension PostgreSQL flexible server
I am running PostgreSQL 13.5 on Azure Database for PostgreSQL flexible server and would like to update my extension PostGIS from version 3.1.1 to 3.2.0. On the official Microsoft website I can see they added support for version 3.2.0 link. However, I…
asked 2022-11-29T12:07:24.087+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(112.00000000000001, 35%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EZP%3C/text%3E%3C/svg%3E)
Zitman, PA (Pieter)
1
Reputation point
commented 2022-12-07T08:11:44.287+00:00
GeethaThatipatri-MSFT
27,642
Reputation points Microsoft Employee
1 answer
One of the answers was accepted by the question author.
Azure SQL to Postgres Migration
Hello, I have all my tables in Azure SQL. Initially we decided to go ahead with Azure SQL, because of some reasons we decided to move to Postgres Instead of azure SQL. I would like to transfer the data from Azure SQL to PostgresSQL. I am new to…
1 answer
Peformance issue with postgres fdw in azure postgres flexible server
Hi team, We have a application which uses two databases. Database A and Database B. Both databases are present in azure Postgresql flexible server. We are migrating on-prem oracle database to azure cloud Postgresql. In our application, we have a…
asked 2022-11-24T06:33:09.217+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, 21%, 21%)' 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)
Mani Mahesh Sivakumar
56
Reputation points
answered 2022-12-06T17:18:47.757+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, 27%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EG%3C/text%3E%3C/svg%3E)
gennady
1
Reputation point Microsoft Employee
0 answers
Access flexible postgresql database from data factory
Hello Microsoft-Community, we are trying to build some pipelines in Azure Data Factory that uses one of our postgresql databases as a source. This database is located in a virtual subnet. In addition, this subnet is delegated to…
asked 2022-11-16T14:02:03+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(44.800000000000004, 79%, 14%)' 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)
Dominik Rieder (Ext.)
1
Reputation point
commented 2022-12-05T10:13:54.333+00:00
PRADEEPCHEEKATLA-MSFT
77,676
Reputation points Microsoft Employee
0 answers
Fetch hardware details(disk type) of a Azure Postgresql instance
How to know the disk type of a database instance i.e is it SSD/HDD?
asked 2022-11-29T11:32:12.707+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(137.6, 5%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETS%3C/text%3E%3C/svg%3E)
Tasleema Shaik Mohammed
71
Reputation points
commented 2022-12-02T05:43:03.987+00:00
Tasleema Shaik Mohammed
71
Reputation points
1 answer
One of the answers was accepted by the question author.
When will "Query Performance Insight" be available for PostgreSQL 14 flexible server?
I see "Query Performance Insight" should be available only for PostgreSQL up to 11. https://learn.microsoft.com/en-us/azure/postgresql/single-server/concepts-query-performance-insight Is there a plan to make it available also for…
asked 2022-11-26T12:17:47.813+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, 97%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELG%3C/text%3E%3C/svg%3E)
Ladislav Gallay
146
Reputation points
commented 2022-11-29T17:26:29.61+00:00
GeethaThatipatri-MSFT
27,642
Reputation points Microsoft Employee
0 answers
Solution for malware protection on Azure Database for PostgreSQL Flexible server
Hi, I'm looking for a solution for malware protection to meet some Compliance. I found that Postgres Single Server supports Microsoft Defender for cloud but with Flexible Server I am using it does not. Does anyone have any advice? Should I…
![](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, 4%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKA%3C/text%3E%3C/svg%3E)
1 answer
How to track full SQL query (not normalized) with pg_stat_statement?
Is there a way how to enable tracking of full queries without normalized parameters? For example when I execute: SELECT * FROM users WHERE name = 'Martin' I see in the statement logs: SELECT * FROM users WHERE name = $1 I would like…
asked 2022-11-26T12:19:51.787+00:00
Ladislav Gallay
146
Reputation points
answered 2022-11-28T06:53:06.93+00:00
Ladislav Gallay
146
Reputation points
0 answers
private connection
Hello, I have a psql database and vm setup in the same vnet/subnet. I am trying to connect to the database from the vm but getting an error "The public network access on this server is disabled. To connect to this server, use the Private…
asked 2022-11-27T13:28:39.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(192, 67%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENA%3C/text%3E%3C/svg%3E)
Niren Adhikary (NAD)
146
Reputation points
commented 2022-11-28T05:22:06.277+00:00
Niren Adhikary (NAD)
146
Reputation points
0 answers
Cannot create database for PostgreSQL
hi, ive been trying to create a database for PostgreSQL but Azure keeps loading and nothing seems to be coming up. i have also tried creating other databases but all of them do not seem to be working too. i wonder if anyone is having the same…
asked 2022-11-21T03:56:23.773+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, 39%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EC%3C/text%3E%3C/svg%3E)
cx
1
Reputation point
commented 2022-11-24T05:29:08.177+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.
work_mem and maintenance_work_mem limits for managed postgres on Gen5 instance
There is a limit on work_mem and maintenance_work_mem parameters for server configurations, which is setting the max values to 2097171, although there is much larger amount memory available on the machine. Why is there a limit on these configs?
asked 2021-09-24T01:01:08.17+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(54.400000000000006, 39%, 15%)' 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)
Deniz Durmus
21
Reputation points
commented 2022-11-24T05:06:48.497+00:00
ShaktiSingh-MSFT
13,436
Reputation points Microsoft Employee
1 answer
One of the answers was accepted by the question author.
Inserting or updating data on views created on distributed tables on Hyperscale citus
Our database design has multiple views on tables and insert /update are done on views. On opensource citus when we try to update / insert data on views created on distributed tables , it throws an error saying " ERROR: cannot modify views when the…
asked 2022-11-23T08:18:45.487+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, 96%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHN%3C/text%3E%3C/svg%3E)
Honey Nadackal
126
Reputation points
accepted 2022-11-23T17:14:09.15+00:00
Honey Nadackal
126
Reputation points
1 answer
Connecting from AzureCLI/PowerShell to a PostgreSQL database that is part of a Webapp gives DNS error
So I have created a Webapp with a Postgres flexible server behind it. This works nicely as they are in the same VNet. However, I see no way to connect to the database directly from my local Azure CLI/PowerShell (or from a Cloud Shell for that matter) as…
asked 2022-11-18T11:48:54.747+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(102.4, 70%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EH%3C/text%3E%3C/svg%3E)
hquad
6
Reputation points
commented 2022-11-23T17:13:52.127+00:00
GeethaThatipatri-MSFT
27,642
Reputation points Microsoft Employee
1 answer
Cannot create a new Azure Database for PostgreSQL Flexible Server
Hey! I'm trying to create a new PostgreSQL flexible server in an existing ressource group. I tried using the CLI and via the Portal, but always get the same error. Checking the existence of the resource group 'production'... Resource group…
asked 2022-11-02T15:59:47.307+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, 71%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EQ%3C/text%3E%3C/svg%3E)
Quentin
1
Reputation point
commented 2022-11-22T00:59:03.163+00:00
GeethaThatipatri-MSFT
27,642
Reputation points Microsoft Employee
1 answer
pldbgapi query
The 'pldbgapi' extension which we try to use in order to do debugging is not exist in the supported list.So, the question is:Is there any other extension which is supported and we can use it in order to do debugging ? If not, what is alternative way…
asked 2022-08-17T15:13:35.42+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, 42%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3END%3C/text%3E%3C/svg%3E)
Nick Diaz
281
Reputation points
commented 2022-11-19T00:30:00.82+00:00
Oury Ba-MSFT
16,391
Reputation points Microsoft Employee
1 answer
One of the answers was accepted by the question author.
ora2pg - subtype error
Hi Folks, Am encountering an weird issue. a table is defined with 2 UDT columns on which 1 UDT is subtype. During ora2pg direct load into PG as encountering the issue as attached. No data is getting loaded.
asked 2022-10-17T10:52:41.797+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(108.80000000000001, 43%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EET%3C/text%3E%3C/svg%3E)
Elango Thiagarajan (NCS)
21
Reputation points
commented 2022-11-18T14:58:21.843+00:00
GeethaThatipatri-MSFT
27,642
Reputation points Microsoft Employee