Azure Database for PostgreSQL
An Azure managed PostgreSQL database service for app development and deployment.
874 questions
0 answers
How can I reach the azure database for postgresql (Temporary failure in name resolution)
Hello, I created an azure database for postgresql flexible service. As for today, I can not reach anymore the server. When I try to connect with psql, I got this : psql: error: could not translate host name…
asked 2024-05-14T09:00:59.56+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(83.2, 87%, 18%)' 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)
Patrick RANDRIANJATOVO
20
Reputation points
commented 2024-05-14T13:59:38.9066667+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,826
Reputation points Microsoft Employee
1 answer
One of the answers was accepted by the question author.
How to migrate database users from Azure PostgreSQL single server to flexible server?
Hello team, I was using the migration tool provided in Azure portal to migrate databases from PostgreSQL single server to flexible server.The migration itself was successful and I could see my database and data in the flexible server. The issue I am…
![](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(217.60000000000002, 15%, 31%)' 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)
0 answers
why plpgsql_check extension is not supported in Azure Database for PostgreSQL flexible server
plpgsql_check extension is not supported in Azure Database for PostgreSQL flexible server
asked 2024-05-13T06:59:20.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(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
commented 2024-05-14T05:12:24.2966667+00:00
ShaktiSingh-MSFT
13,826
Reputation points Microsoft Employee
1 answer
One of the answers was accepted by the question author.
Deleted feature
Hello. How to restore resource in Azure using REST API? I urgently need to restore files that I accidentally deleted today: 1 Azure Database SQLPostgree; 1 Private DNS zone link to virtual network; 1 Private DNS Zone. Best Regards, Gabriel…
asked 2024-05-13T15:29:29.2866667+00:00
Gabriel Moraes
200
Reputation points
commented 2024-05-13T22:36:39.2466667+00:00
Oury Ba-MSFT
16,641
Reputation points Microsoft Employee
1 answer
Azure Postgres Flexible Server Cost increase without any plan changes
I'm utilizing Azure Database for PostgreSQL under the Flexible Server - General Purpose Plan with D8ds_v5 / D8ads_v5 configuration, boasting 8 vCores. After examining my expenditure through cost management tools, I've identified a possible billing…
asked 2024-05-13T12:43:57.4566667+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, 99%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENB%3C/text%3E%3C/svg%3E)
Nabil BEN SALAH
0
Reputation points
answered 2024-05-13T22:05:22.27+00:00
Amira Bedhiafi
15,991
Reputation points
1 answer
One of the answers was accepted by the question author.
When will the pgrouting extension be available in Postgresql 16.2 Azure flexible server?
When will the pgrouting extension be available in Postgresql 16.2 Azure flexible server?
asked 2024-05-10T14:05:27.9533333+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(60.8, 50%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECS%3C/text%3E%3C/svg%3E)
Cooling, Steve
20
Reputation points
accepted 2024-05-13T07:31:00.11+00:00
Cooling, Steve
20
Reputation points
1 answer
How to create private endpoint for postgres SQL flexible server?
I am unable to create a private endpoint for my postgres SQL flexible server My bicep file is like this // Parameters param location string //param env string param nameAffix string param administratorLogin string // existing resource name params param…
asked 2024-05-03T02:54:55.9833333+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, 12%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKW%3C/text%3E%3C/svg%3E)
Kenny Wong (HK)
20
Reputation points
answered 2024-05-09T09:21:17.8466667+00:00
ShaktiSingh-MSFT
13,826
Reputation points Microsoft Employee
1 answer
One of the answers was accepted by the question author.
How i can access a PostgreSQL server DB in a VNet in Azure thorugh python runbook inside an Automation Account ?
Hello team, I have a problem statement, i have an automation account in azure in which i have a python runbook in that runbook i have a script to make a connection to postgreSQL DB server and do some transactions in the DB but the problem is now i have…
asked 2024-05-03T13:04:21.4433333+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, 12%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKP%3C/text%3E%3C/svg%3E)
Koushik Purva Mahendra
50
Reputation points
accepted 2024-05-08T12:40:48.11+00:00
Koushik Purva Mahendra
50
Reputation points
1 answer
One of the answers was accepted by the question author.
How to enable Azure Postgresql flexible server to have both High Availability and Storage Auto-grow scaling?
Based on the documentation, Azure Postgresql flexible server supports both High Availability and auto-growth storage, but it seems that I cannot select High Availability if I have auto-growth and vice versa. Why?
![](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, 83%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EL%3C/text%3E%3C/svg%3E)
1 answer
How can I change location in Azure Database for PostgreSQL flexible server?
How can I change location in Azure Database for PostgreSQL flexible server? source location - East US Destination location - East US 2
asked 2024-04-30T10:15:10.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, 19%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESA%3C/text%3E%3C/svg%3E)
Sonam Agrawal
0
Reputation points
commented 2024-05-07T19:06:37.1133333+00:00
GeethaThatipatri-MSFT
27,877
Reputation points Microsoft Employee
0 answers
Is there a recommended approach for triggering actions for non-supported faults in Azure Chaos Studio?
I noticed that Azure PostgreSQL Flexible Server does not have a supported Azure Chaos Studio Fault library provider. See below: https://learn.microsoft.com/en-us/azure/chaos-studio/chaos-studio-fault-library Does Microsoft have published guidance for…
asked 2024-05-06T20:12:55.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(134.4, 26%, 23%)' 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)
Andrew Citera
20
Reputation points
edited a comment 2024-05-07T18:24:44.1566667+00:00
Oury Ba-MSFT
16,641
Reputation points Microsoft Employee
1 answer
Azure Postgres Flexible high availlability is not enabling
Hi Team, I want to enable HA (high availability) in Postgres Flexible Server, but it's giving an error. Current infra is General Purpose, D2ds_v4, 2 vCores, 8 GB of RAM, and 128 GB of storage.
Azure Database for PostgreSQL
Azure Database for PostgreSQL
An Azure managed PostgreSQL database service for app development and deployment.
874 questions
Azure Startups
Azure Startups
Azure: A cloud computing platform and infrastructure for building, deploying and managing applications and services through a worldwide network of Microsoft-managed datacenters.Startups: Companies that are in their initial stages of business and typically developing a business model and seeking financing.
28 questions
asked 2023-07-03T13:56:42.31+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, 81%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENP%3C/text%3E%3C/svg%3E)
Nitin Parmar-Tss consultancy
71
Reputation points
edited the question 2024-05-07T15:58:26.3866667+00:00
bharathn-msft
5,086
Reputation points Microsoft Employee
3 answers
One of the answers was accepted by the question author.
Why are Reservations not available for Ddsv5 instances on Azure PostgreSQL Flexible Server?
I'm calculating the cost of Azure PostgreSQL Flexible Server which uses Ddsv5 instance and notice that Reservations for this series and Dadsv5 instances are not available. Is there an explanation for this? Reservations are available for the older Ddsv4…
asked 2023-08-11T08:12:39.71+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(163.2, 5%, 25%)' 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)
Pitawat
331
Reputation points
commented 2024-05-07T07:29:28.38+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, 41%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EYN%3C/text%3E%3C/svg%3E)
Yashvit Naik
16
Reputation points
3 answers
One of the answers was accepted by the question author.
Azure Postgresql Flexi instance - How to check the table creation date and time
HI Can someone help me to find the tables/objects create date/time in Azure postgresql flexi instance ? we used to use this one , select * from pg_stat_file( pg_relation_filepath('alert') ) in on-prem but that's not working in azure with admin user due…
asked 2024-04-24T02:29:38.51+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, 85%, 32%)' 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)
subhash-DBA
45
Reputation points
accepted 2024-05-07T03:53:45.71+00:00
subhash-DBA
45
Reputation points
0 answers
Postgresql flexible server on azure unplanned failover is not working in a Zoneredundant HA environment.
Hi all, On Azure we have a PostgreSQL-Server with Zone-redundant HA. When we trigger a forced Failover, the Server goes in the "Updating state" and that is the only information which we see about PostgreSQL flexible server on Azure. How we can…
asked 2024-04-22T14:27:14.8433333+00:00
Serkan Aytekin
0
Reputation points
commented 2024-05-06T22:59:53.82+00:00
GeethaThatipatri-MSFT
27,877
Reputation points Microsoft Employee
4 answers
Azure backup vault for Postgresql Flexi instance
HI , Question on the long term backup for Azure postgresql flexi - as per the doc below https://learn.microsoft.com/en-us/azure/backup/backup-azure-database-postgresql-flex I observed that, after the successful backup, I see the backup files in object…
asked 2024-05-01T13:43:38.7333333+00:00
subhash-DBA
45
Reputation points
commented 2024-05-06T19:00:12.4333333+00:00
Oury Ba-MSFT
16,641
Reputation points Microsoft Employee
0 answers
The recommended certificate didn't work on Azure Database for PostgreSQL Single server in China east 2 region
Hi, I have a question about the Azure Database for PostgreSQL - Single Server (located in China East 2). We recently noticed that there is a warning message in the Azure portal, which is "As a part of routine certificate rotation, the root…
asked 2024-04-18T15:24:54.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(64, 87%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EXL%3C/text%3E%3C/svg%3E)
Xiaoyun Liao
40
Reputation points
commented 2024-05-06T16:53:54.1866667+00:00
Oury Ba-MSFT
16,641
Reputation points Microsoft Employee
1 answer
Failedto load PostgreSQL Flexible serverdatabases
Hi everyone Maybe who knows what is going on?
asked 2024-05-06T10:26:10.36+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, 64%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAL%3C/text%3E%3C/svg%3E)
Alexander Lapin
60
Reputation points
commented 2024-05-06T13:13:43.04+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,746
Reputation points Microsoft Employee
2 answers
Why I can not create WEB App + Database
I can not create Azure WEB APP + Database. I am trying to create Django backed with PostgresSQL with the following parameters: Region UK West Python 3.10 PosgresSQL - Fixable Server (recommended) Azure Cache for Redis - NO Hosting plan - Standart…
asked 2024-04-10T14:26:01.65+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, 46%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMH%3C/text%3E%3C/svg%3E)
Mane Hambardzumyan
0
Reputation points
commented 2024-05-06T13:02:17.1233333+00:00
GeethaThatipatri-MSFT
27,877
Reputation points Microsoft Employee
1 answer
One of the answers was accepted by the question author.
Do you know how to install the 'ODBC Driver 17 for PostgreSQL' on a Azure Databricks cluster?
I am attempting to run postgreSQL stored procedures , through Azure Databricks notebook. We have stored procedure written in Azure Database for PostgreSQL and we want to run postgreSQL stored procedures through Azure Databricks Notebook (using…
asked 2024-04-30T11:06:56.06+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, 57.99999999999999%, 19%)' 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)
Anuj, Singh (Cognizant)
25
Reputation points
accepted 2024-05-02T09:34:32.8666667+00:00
Anuj, Singh (Cognizant)
25
Reputation points