Azure Database for PostgreSQL
An Azure managed PostgreSQL database service for app development and deployment.
1,008 questions
1 answer
Is there a way to nightly sync one DB with another?
Is there a way to set up a nightly sync between two (Azure-hosted) Postgres databases? I've read about Azure Data Sync for SQL, but from what I can tell it doesn't apply to Postgres DBs. Basically we have a live DB, and a stage DB, and we would like the…
asked 2024-08-20T10:58:45.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(259.20000000000005, 81%, 35%)' 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)
mitya33
1
Reputation point
commented 2024-09-03T18:47:09.04+00:00
Oury Ba-MSFT
18,601
Reputation points Microsoft Employee
0 answers
Unable to set "synchronous_commit" the parameter for Azure Database for PostgreSQL flexible server instance
Hi Everyone, we are using Postgresql Flexible server instance in our product. Now, we want to integrate pgpool in our product to load-balance the queries between primary and replica databases. For this issue, we tried to set…
asked 2024-08-29T10:21:37.5233333+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' %3EMB%3C/text%3E%3C/svg%3E)
Mahesh Bathina
0
Reputation points
commented 2024-09-03T17:23:10.71+00:00
Mahesh Bathina
0
Reputation points
0 answers
how to improve the azure PostgreSQL flexible server performance in cloud
Hi Team, When we are calling our Api which has multiple database queries, it is allowing only 10 instances to connect with DB. From the 11th instance or connection, we are getting socket exception with error message socket closed. Can anyone help us how…
asked 2024-08-14T14:10:14.1+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, 50%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKM%3C/text%3E%3C/svg%3E)
Kattekola Mahesh
5
Reputation points
commented 2024-09-03T17:12:19.6566667+00:00
Oury Ba-MSFT
18,601
Reputation points Microsoft Employee
0 answers
How can I immediately take ownership of an Azure PostgreSQL table without AZURESU superuser permissions?
A developer created a PostgreSQL table and now has ownership, causing my PGADMIN backup task to fail. They could fix the issue when they return from vacation, but how can I immediately take ownership without AZURESU superuser permissions? Since AZURE…
asked 2024-08-26T17:19:14.6733333+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, 14.000000000000002%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGL%3C/text%3E%3C/svg%3E)
Greg Lowell
0
Reputation points
commented 2024-09-03T16:47:33.8133333+00:00
Oury Ba-MSFT
18,601
Reputation points Microsoft Employee
0 answers
Postgres flexi server storage is increasing exponentially
Postgres flexi server storage is increasing exponentially from 3GB to 32GB, the DB size in the server is approx. 3GB Can you anyone please suggest why the storage is increasing , what could be the issue.
asked 2024-09-03T13:16:07.6266667+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, 21%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGS%3C/text%3E%3C/svg%3E)
Guttappa Sajjan
0
Reputation points
commented 2024-09-03T16:40:08.22+00:00
Oury Ba-MSFT
18,601
Reputation points Microsoft Employee
0 answers
how can I get permission to visit pg_current_logfile() in my Azure Cosmos DB for PostgreSQL Cluster
I want to access my log file in my database (Azure Cosmos DB for PostgreSQL Cluster), but my admin account don't have permission to visit pg_current_logfile().
asked 2024-09-03T08:49:42.4633333+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(288, 43%, 37%)' 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)
Rose
0
Reputation points
commented 2024-09-03T16:00:47.7433333+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(198.4, 69%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESR%3C/text%3E%3C/svg%3E)
Sai Raghunadh M
75
Reputation points Microsoft Vendor
0 answers
How can fix LongTermRetentionBackupInternalError
I am trying to make a backup to Azure database Postgres SQL flexible server but it fails and gives me this error LongTermRetentionBackupInternalError I followed https://video2.skills-academy.com/en-us/azure/backup/backup-azure-database-postgresql-flex but…
asked 2024-08-13T06:40:28.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(60.8, 2%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EYY%3C/text%3E%3C/svg%3E)
Youssef Yassa
25
Reputation points
commented 2024-09-03T15:59:16.0766667+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, 33%, 15%)' 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)
Anderson Leite
5
Reputation points
0 answers
The value 'pg_availability,pg_cron,pg_stat_statements,pgaudit' for configuration 'shared_preload_libraries' is not valid.
Hello, team! We have Azure Database for PostgreSQL flexible server I would like to add over AZURE portal pgaudit extension. First of all I add here: Then I try to add here: Bu t I get deployment error like this : The resource write operation…
asked 2024-09-01T10:46:27.27+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, 62%, 32%)' 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)
Yusif Nasirov
0
Reputation points
edited a comment 2024-09-03T15:37:24.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(252.8, 60%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMK%3C/text%3E%3C/svg%3E)
Mahesh Kurva
0
Reputation points Microsoft Vendor
0 answers
How to connect to azure postgresql flexible server using Microsoft Entra group
Hello I want to connect to Azure Postgresql Flexible server using PgAdmin4 and using Entra ID group. I followed the steps from: https://video2.skills-academy.com/en-us/azure/postgresql/flexible-server/how-to-configure-sign-in-azure-ad-authentication My Entra…
0 answers
Postgre SQL Automigration 8 Databases Limit
When migrating my server manually, I can only migrate 8 databases, but now 2 servers will be migrated automatically from Single server to Flexible on 07.09. What happens to the databases if there are more than 8 databases?
asked 2024-09-02T14:04:57.8833333+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, 2%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBC%3C/text%3E%3C/svg%3E)
BÖCKLE Dominik
10
Reputation points
commented 2024-09-03T09:46:39.1566667+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,811
Reputation points
1 answer
How to setup point to site vpn to got access to azure resource by private link
Hello I setup vpn connection do azure using p2s with tunel type openvpn and authentication azure active directory. Client is able to conntect to vpn without issue. Next i setup azure postgresql database with access by private endpoint and configured…
asked 2024-08-29T08:22:26.0566667+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(265.6, 40%, 35%)' 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)
Radek
1
Reputation point
commented 2024-09-03T09:37:52.8866667+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, 71%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGP%3C/text%3E%3C/svg%3E)
Ganesh Patapati (Quadrant Resource LLC)
20
Reputation points Microsoft Vendor
2 answers
Requesting support for Apache AGE extension on Azure PostgreSQL
Is it possible to request support for the Apache AGE extension on Azure PostgreSQL databases? I'm curious if Microsoft has a request system similar to AWS.
asked 2024-01-25T03:10:38.2133333+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, 67%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJW%3C/text%3E%3C/svg%3E)
Jessica Wang
5
Reputation points
answered 2024-09-03T07:16:02.3466667+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, 65%, 31%)' 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)
Nitin Agarwal
0
Reputation points Microsoft Employee
1 answer
Postgres db does not finish restarting (Azure Database for PostgreSQL flexible server) after connectivity issues / full storage
Hi, This Monday morning, our Azure Database for PostgreSQL flexible server instance turned out to have connectivity issues. None of our services could connect to it anymore and manually connecting also failed. These issues started last Saturday; before…
asked 2024-09-02T09:16:46.59+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, 20%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAN%3C/text%3E%3C/svg%3E)
Arthur Nieuwland
0
Reputation points
commented 2024-09-03T06:05:34.42+00:00
ShaktiSingh-MSFT
14,811
Reputation points
0 answers
Azure Database for PostgreSQL error: FATAL: password authentication failed for user
Hello, For some reason, I cannot access my PostgreSQL Database. I'm using a Managed Identity (MI). I already red the following article and it doesn'y apply to my situation:…
asked 2024-08-31T21:23:50.7066667+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(288, 96%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3E0%3C/text%3E%3C/svg%3E)
0x3N3JVhPUV
0
Reputation points
commented 2024-09-03T04:41:17.1733333+00:00
ShaktiSingh-MSFT
14,811
Reputation points
1 answer
how to connect to CITUS remotely
I have using single node CITUS, my coordinator node running on 9700 and my PostgreSQL running on 5432 I don't know how I can remote connect my CITUS coordinate node
asked 2024-08-18T01:49:07.85+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)
201
Reputation points
commented 2024-09-03T02:08:04.52+00:00
Sai Raghunadh M
75
Reputation points Microsoft Vendor
0 answers
How to fix 403 in app service with postgres flexible server?
We have an existing app service and are migrating the data and application from mongodb to a flexible postgres-server database. The stack consists of 3 private endpoints with network interfaces, for the frontend, the keyvault and the postgres-db.…
Azure
Azure
A cloud computing platform and infrastructure for building, deploying and managing applications and services through a worldwide network of Microsoft-managed datacenters.
1,146 questions
Azure Database for PostgreSQL
Azure Database for PostgreSQL
An Azure managed PostgreSQL database service for app development and deployment.
1,008 questions
Azure App Service
Azure App Service
Azure App Service is a service used to create and deploy scalable, mission-critical web apps.
7,604 questions
asked 2024-08-08T13:41:04.69+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, 2%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAV%3C/text%3E%3C/svg%3E)
Anita Veldman
0
Reputation points
edited the question 2024-09-02T16:08:00.6866667+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(281.6, 17%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGM%3C/text%3E%3C/svg%3E)
Givary-MSFT
31,956
Reputation points Microsoft Employee
1 answer
Recreating a deleted Postgres flexible server returns Internal Server Error
When trying to create a Postgres flexible server, a "Conflict" is returned with the error: {"code":"InternalServerError","message":"An unexpected error occured while processing the request. Tracking ID:…
asked 2024-09-02T12:47:45.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(134.4, 22%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPT%3C/text%3E%3C/svg%3E)
Paul Toft Duizer
0
Reputation points
answered 2024-09-02T13:17:17.1266667+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' %3ER%3C/text%3E%3C/svg%3E)
RahulRandive
9,431
Reputation points
1 answer
SSL error: certificate verify failed when connection to Azure PostgreSQL
Hi, I have faced SSL error: certificate verify failed error today, while everything worked correctly yesterday. I specify sslmode="require" and sslrootcert="/path/to/DigiCertGlobalRootG2.crt.pem". I also tried…
![](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(3.2, 39%, 10%)' 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)
5 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
341
Reputation points
commented 2024-08-30T12:27:34.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(147.20000000000002, 17%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EK9%3C/text%3E%3C/svg%3E)
KoernerLars059-9586
0
Reputation points
1 answer
Authentication failure in Azure postgresql database
Hello everyone, I am following these turotials to authenticate with Azure postgresql db with system assigned managed identity. I haven't deployed to code to azure app service, when i try to check the connection locally, I'm getting the error 'Password…
asked 2024-08-22T09:13:22.8333333+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(121.6, 67%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGR%3C/text%3E%3C/svg%3E)
Gokul R Dev
326
Reputation points
answered 2024-08-29T09:56:23.63+00:00
Gokul R Dev
326
Reputation points