Azure Database for PostgreSQL
An Azure managed PostgreSQL database service for app development and deployment.
859 questions
2 answers
failed to upgrade postgresql flexible server
Hello, I have recently migrated our Azure Database for PostgreSQL single server (v 11.18) test environment database to Azure Database for PostgreSQL flexible server (v 11.21). I intentionally kept it at the same major version during the migration, but…
asked 2024-02-19T10:26:28.16+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, 3%, 19%)' 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)
METALDr
0
Reputation points
edited a comment 2024-02-28T05:04:55.34+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,346
Reputation points Microsoft Employee
1 answer
One of the answers was accepted by the question author.
Private Endpoint impossible to create on PostgreSQL flexible server despite preview activated
Hello, On my subscription, I activated the preview feature called "Enable Private Endpoints for PostgreSQL flexible servers". After subscription is validated, I logout/Log on. After, I create a new "Azure Database for PostgreSQL Flexible…
![](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, 27%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EF%3C/text%3E%3C/svg%3E)
1 answer
One of the answers was accepted by the question author.
How to connect with pgAdmin to Azure Database for PostgreSQL flexbile server
I've got my Django app up and running with a PostgreSQL flexible server. The Network connectivity is set to Private access (VNet Integration), which I cannot change. Now I would like to connect with pgAdmin to my database, but it seems to me that the…
asked 2023-10-05T13:38:39.24+00:00
Eelco
85
Reputation points
commented 2024-02-27T03:40:46.9166667+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(294.40000000000003, 23%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMB%3C/text%3E%3C/svg%3E)
Moussavou Boussougou Milandu Keith
15
Reputation points
4 answers
SSH Connection error - deploying a Django web app with PostgreSQL using the Azure portal
Hi, I've been doing the Tutorial: Deploy a Django web app with PostgreSQL using the Azure portal, and all is well until I get to Run Django database migrations. When I try to connect to the SSH, it errors with "ssh://root@172.16.3.3:2222 SSH…
asked 2020-09-23T08:40:10.833+00:00
Dennis Chan
6
Reputation points
commented 2024-02-24T00:34:40.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(252.8, 54%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENI%3C/text%3E%3C/svg%3E)
NodeX iHub
0
Reputation points
1 answer
One of the answers was accepted by the question author.
HTTP response was nil; connection may have been reset
Error: creating Flexible Server (Subscription: "00000000" │ Resource Group Name: "XYG-rg" │ Flexible Server Name: "XYZ-pqsql-flex-db"): performing Create: Put…
asked 2024-02-21T20:49:52.3766667+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, 57.99999999999999%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKV%3C/text%3E%3C/svg%3E)
Kukkala, Venugopal
41
Reputation points
commented 2024-02-22T20:23:51.92+00:00
Oury Ba-MSFT
16,241
Reputation points Microsoft Employee
1 answer
One of the answers was accepted by the question author.
PG_BUFFERCACHE extension not available in PostgreSQL Flexible Server 16
Hello, I am trying to migrate Azure PostgreSQL 11 Single Server to Azure PosgreSQL 16 Flexible Server using the Single to Flex migration tool. However I face an issue during the migration: the tool is telling me that it can't create the pg_buffercache…
asked 2023-11-20T10:59:53.4133333+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, 5%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Alexandre
40
Reputation points
commented 2024-02-22T18:22:51.8966667+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(28.799999999999997, 85%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPC%3C/text%3E%3C/svg%3E)
Peter Ciavarella
0
Reputation points
1 answer
One of the answers was accepted by the question author.
Failed connections in Azure PostgreSQL
Hello Team, We have a azure database for postgresql flexible server. On the metrics screen, we can see that there are a couple of failed connections (PFB the screenshot). But, there is no error message mentioned. How to find out what is the error…
![](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(179.20000000000002, 53%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENC%3C/text%3E%3C/svg%3E)
1 answer
Permission denied for schema cron
Hi there! I am trying to configure the pg_cron extension on our postgresql 16 flexible server, however, I've been stuck for a while now trying to figure out how I am suppose to do anything with the cron schema. I've added pg_cron to the azure.extensions…
asked 2024-02-21T14:56:18.5766667+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, 4%, 15%)' 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)
Patricia Ramos
0
Reputation points
edited the question 2024-02-21T18:41:51.9+00:00
Patricia Ramos
0
Reputation points
1 answer
Azure flexible server for Postgresql support for GP_Standard_D4s_v3 & GP_Standard_D2s_v3 in East US region
Hi, We wanted to create Azure Flexible server for postgresql in East US and East US 2 regions. But we could not find "GP_Standard_D4s_v3 & GP_Standard_D2s_v3" options in East US region. But below link mentions that East US and East US2…
asked 2024-02-17T13:30:02.4233333+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, 28.000000000000004%, 29%)' 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)
Aramvalartha Subramanian
0
Reputation points
commented 2024-02-21T12:59:59.14+00:00
TP
75,736
Reputation points
1 answer
Azure Manage Database
I am using an Azure-managed PostgreSQL database, the database is not able to handle multiple concurrent connections (more than 30 connections). I tried increasing the parameters (max concurrent request = 500), but still getting the error
asked 2024-02-18T05:30:43.0833333+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(92.8, 20%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EIB%3C/text%3E%3C/svg%3E)
ishang baniya
5
Reputation points
commented 2024-02-21T04:47:09.4366667+00:00
ShaktiSingh-MSFT
13,346
Reputation points Microsoft Employee
2 answers
Django, Azure Web Service | What is the best way to backup and restore my data stored in Postgres Flexi Server
I have recently deployed my django applciation in azure app services together with a postgres flexi database server. I would like to know what is the best way to back up and restore my database, is there any best method or best practice that I can adopt,…
asked 2024-02-19T01:09:33.76+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, 30%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMS%3C/text%3E%3C/svg%3E)
Md Shervin
0
Reputation points
commented 2024-02-20T08:13:33.2766667+00:00
ShaktiSingh-MSFT
13,346
Reputation points Microsoft Employee
1 answer
How to configure firewall rule for access from Databricks to Postgres flexible server
We are migrating our databases from Postgres single server to Postgres flexible server ahead of end of support for single servers. We are using Public Access as opposed to Private access in Networking tab of flexible server. This is because we want to…
asked 2024-02-05T23:03:01.0033333+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(0, 90%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESL%3C/text%3E%3C/svg%3E)
Swavek Lorenc
0
Reputation points
commented 2024-02-20T05:18:44.97+00:00
ShaikMaheer-MSFT
37,896
Reputation points Microsoft Employee
3 answers
One of the answers was accepted by the question author.
TimescaleDB on Azure PostgreSQL v16
Is it possible to run TimescaleDB on Azure PostgreSQL v16? I just tried and the options in shared_preload_libraries and azure.extensions are not there. Downgrading to v15 works. I assume it due to TimescaleDB only fairly recently supporting it (v2.13.0…
asked 2024-02-16T15:23:42.6633333+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(307.2, 81%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDS%3C/text%3E%3C/svg%3E)
Daniel Siviter
20
Reputation points
answered 2024-02-16T20:32:32.2633333+00:00
Oury Ba-MSFT
16,241
Reputation points Microsoft Employee
1 answer
AzurePostgresqlでオートスケーリングを行うことができるか
AzurePostgresqlでCPU使用率の上昇に応じてCore数を自動拡張するような機能が利用できるか確認したいです ※ドキュメントではストレージの自動拡張ができることは明記されていますが、Core数に関して記載がなかったため、確認させていただきました。
asked 2024-02-15T06:00:38.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(256, 45%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
日高 満実子
0
Reputation points
answered 2024-02-16T12:37:48.5433333+00:00
Amira Bedhiafi
15,216
Reputation points
2 answers
One of the answers was accepted by the question author.
CREATE SUPERUSER in PaaS offering of Azure Database for Postgres
Hi, i logged into the azure Postgres database , with the admin user credentials , that i gave at the time of creating the Azure Database for Postgres Now when i try to create SUPERUSER , by giving the command CREATE USER TESTER SUPERUSER; …
asked 2020-10-08T16:09:49.957+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,676
Reputation points
edited a comment 2024-02-15T21:34:15.8733333+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, 10%, 33%)' 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)
Matthew Mckenzie
5
Reputation points
1 answer
One of the answers was accepted by the question author.
How to resolve data mapping between parquet file and Azure Database for PostgreSQL ?
I'm trying to copy data into a PostgreSQL database from a parquet file in an Azure Data Lake. The problem is that some of the numeric columns in the parquet file don't have exactly the same type of numeric data in the PG database. longitude, latitude…
asked 2024-02-14T13:56:15.8566667+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, 64%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ES%3C/text%3E%3C/svg%3E)
sliemsoonuef
20
Reputation points
accepted 2024-02-15T13:52:01.1333333+00:00
sliemsoonuef
20
Reputation points
1 answer
Data Factory to Azure Search Index Mapping Issue - StringCollection Fields Not Visible
I am encountering an issue while setting up a pipeline in Azure Data Factory to transfer data from a managed PostgreSQL database to Azure AI Search service. In Azure Data Factory, during the mapping configuration step, fields that are defined as…
asked 2024-02-12T00:57:04.87+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, 14.000000000000002%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ER8%3C/text%3E%3C/svg%3E)
RobPi-8032
0
Reputation points
answered 2024-02-15T03:03:45.77+00:00
brtrach-MSFT
15,251
Reputation points Microsoft Employee
2 answers
One of the answers was accepted by the question author.
Unable to access PostgreSQL database after restore - 'database does not exist' error
The other day I had issues with my database and decided to do a fast restore. Unless I didn't understand something, I had to create a new database resource for that,. In the new resource, if I go in the "Database" menu, I can see my 2…
asked 2024-02-12T22:00:07.63+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, 33%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ER%3C/text%3E%3C/svg%3E)
Robouste
20
Reputation points
commented 2024-02-13T18:52:42.15+00:00
Oury Ba-MSFT
16,241
Reputation points Microsoft Employee
1 answer
We have a PostegrSQL Flexible Server which is stuck in Update State for about 2 hours now. I tried restarting and stopping it via az cli and it didn't work.
We have a PostegrSQL Flexible Server which is stuck in Update State for about 2 hours now. I tried restarting and stopping it via az cli and it didn't work. I changed the max connection time and restarted it
asked 2024-02-06T07:12:08.0166667+00:00
ishang baniya
5
Reputation points
commented 2024-02-12T04:20:56.9033333+00:00
ShaktiSingh-MSFT
13,346
Reputation points Microsoft Employee
3 answers
Upgrading Azure Database for PostgreSQL flexible server to version 16
When trying to upgrade a PostgreSQL server from 15 to 16 I'm getting the following error: You are already running the latest major PostgreSQL version available. It is possible to create a new Azure Database for PostgreSQL flexible server with version 16.
asked 2024-01-04T09:53:45.2533333+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(316.8, 78%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJK%3C/text%3E%3C/svg%3E)
Jonas Kvinge
15
Reputation points
commented 2024-02-07T14:23:58.9333333+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, 87%, 36%)' 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)
Marius Løkken
0
Reputation points