Azure Database for PostgreSQL
An Azure managed PostgreSQL database service for app development and deployment.
870 questions
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
77,231
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
![](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,751
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,751
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,971
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,636
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,831
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,681
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,261
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,636
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,751
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
2 answers
ERROR: postgresql Connection terminated due to connection timeout
Getting an error as ERROR: postgresql Connection terminated due to connection timeout pool = new Pool({ max: 300, connectionTimeoutMillis: 5000, host: 'c-abxxxfg.22ps25nxx7gjw5.postgres.cosmos.azure.com', …
asked 2024-02-06T09:44:47.8433333+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, 82%, 10%)' 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)
Akash Panda
0
Reputation points
answered 2024-02-07T10:36:49.04+00:00
ShaktiSingh-MSFT
13,751
Reputation points Microsoft Employee
1 answer
Azure Database for PostgreSQL Flexible Server
Hello Team, My query is more concerned with Azure Database for PostgreSQL Flexible Server. Recently I had raised a ticket requesting to get the Region access with zonal dependency (Availability Zones) for my subscription. Support quickly got the…
asked 2024-02-02T14:02:46.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(64, 94%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELC%3C/text%3E%3C/svg%3E)
Learn Cloud
80
Reputation points
commented 2024-02-06T21:10:33.6333333+00:00
Oury Ba-MSFT
16,636
Reputation points Microsoft Employee
2 answers
One of the answers was accepted by the question author.
Can't Find Firewall Settings for PostgreSQL Flexible Server
I created a Web App + Database and am having problems connecting to the PostgreSQL server using PgAdmin and Azure CLI. All the instructions I'm finding to add my IP address seem to indicate a Firewall setting that I am having a hard time finding. Is…
asked 2024-02-05T17:57:19.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(9.6, 19%, 10%)' 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)
coding_took
20
Reputation points
answered 2024-02-05T23:01:01.6433333+00:00
Oury Ba-MSFT
16,636
Reputation points Microsoft Employee
1 answer
orafce extension in Azure Database for PostgreSQL flexible server
orafce extension is not supported in Azure Database for PostgreSQL flexible server with PostgreSQL version 16, is there any alternative for this?
asked 2024-01-31T07:31:54.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(25.6, 86%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENK%3C/text%3E%3C/svg%3E)
Naveen Kumar Kakarla (Quadrant Resource)
161
Reputation points
answered 2024-02-05T04:30:45.9266667+00:00
ShaktiSingh-MSFT
13,751
Reputation points Microsoft Employee
3 answers
Anon extension is not loading in postgresql flexible server version 15.3
I am trying to load "anon" extension for postgresql flexible server (15.3) . ( for "anon" referring this https://postgresql-anonymizer.readthedocs.io/en/latest/ ) however I always get this error . SQL Error [22023]: ERROR:…
asked 2023-09-18T11:34:32.89+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(211.20000000000002, 45%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPP%3C/text%3E%3C/svg%3E)
Prasad Patil
5
Reputation points
commented 2024-02-03T15:19:40.4466667+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, 28.000000000000004%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAC%3C/text%3E%3C/svg%3E)
Andrei Chiriaev
0
Reputation points
1 answer
One of the answers was accepted by the question author.
Can't filter on both (tagName/tagValue) and resourceType
I have a problem where I am trying to discover services on my subscription via the Azure REST service "Resource Management". I am trying to list resources of a certain type, that fit a certain criteria, where I want to specify a tag as…
asked 2024-02-01T12:40:02.77+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, 81%, 31%)' 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)
Christoffer Pedersen
20
Reputation points
edited the question 2024-02-02T05:02:09.3466667+00:00
PRADEEPCHEEKATLA-MSFT
78,576
Reputation points Microsoft Employee
3 answers
Offline Migration to postgreSQL flexible server failes with extension creation error
Migrating my PostgreSQL Single Server to Flexible Server does not work. The error message is as follows: One or more errors occurred while migrating 'xxx' : EX001: Extension creation failed for the following extensions: hypopg, pg_buffercache,…
asked 2024-01-27T09:39:10.4766667+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(227.2, 63%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EWR%3C/text%3E%3C/svg%3E)
Wolfgang Roese
0
Reputation points
commented 2024-02-01T17:58:19.88+00:00
Oury Ba-MSFT
16,636
Reputation points Microsoft Employee
4 answers
Azure postgreSQL single server publisher to subscriber replication new slot not getting active.
Hi Experts, Azure PostgreSQL single server is the publisher, and the subscriber is an Azure VM running PostgreSQL. There are already 10 replication slots that are working properly; however, when we tried to create 11 slots, they did not become active.…
asked 2024-02-01T02:13:22.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(48, 18%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EV%3C/text%3E%3C/svg%3E)
Veera
240
Reputation points
answered 2024-02-01T08:31:30.0733333+00:00
ShaktiSingh-MSFT
13,751
Reputation points Microsoft Employee