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…
![](https://techprofile.blob.core.windows.net/images/kjzQAO5Oq0Oj37wdNf6qTQ.png?8D8E42)
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…
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…
![](https://techprofile.blob.core.windows.net/images/kjzQAO5Oq0Oj37wdNf6qTQ.png?8D8E42)
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…
![](https://techprofile.blob.core.windows.net/images/kjzQAO5Oq0Oj37wdNf6qTQ.png?8D8E42)
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.
![](https://techprofile.blob.core.windows.net/images/kjzQAO5Oq0Oj37wdNf6qTQ.png?8D8E42)
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().
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…
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…
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…
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?
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…
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.
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…
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:…
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
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.…
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:…
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…
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…
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…