How to Handle Point-in-Time Restore with Azure PostgreSQL and Terraform?
Hello, I'm using an Azure PostgreSQL database and need to perform a point-in-time restore (PITR) as part of a disaster recovery drill. I can successfully restore the database to a new server and update my application to point to this new server. However,…
track_commit_timestamp server parameter in Azure Database for PostgreSQL flexible server
I see that track_commit_timestamp server parameter is disabled by default in Azure Database for PostgreSQL flexible server, I would like to know if there is any performance issue if I enable it.
Can't enable private link with my newly created read replica server
Hi! I have a postgres SQL flexible server that is created in March 2023, I am not able to enable the private link because the server is created too long ago. I just created read replica server, but it has the same issue that I can't find private link…
Azure PostgreSQL Flexible Server - Creating Database in pgAdmin tool
Hi, I am using Azure Database for PostgreSQL Flexible Servers, I cannot create database in pgAdmin due to missing privileges for pg_default tablespace. I cannot find that in documentation, could you confirm that creating databases are possible only in…
After Postgresql flexible migration from 14 to 16 admin user can't ALTER other role anymore
Since migrating my flexible server to postgresql version 16 my admin user can't modify roles anymore. With version 16 it's mandatory to have WITH ADMIN OPTION on roles to be able to alter them. My problem is that it wasn't the case on version 14 and my…
Flexible PostgreSQL server not responsive for unknown reason
Our web server suddenly started to fail to connect to our PostgreSQL flexible server, and the portal is stuck with the message 'The server is currently in 'restarting' state. Please wait for the operation to complete. You can refresh to check status.…
Azure data factory
Dear Team, I need to copy a data from a single table to multiple tables with mapping of columns in azure data factory by connecting with a PostgreSQL server. only one source table and I need to send that source data to the multiple sink tables by…
Scheduled Backup doe not stop
Hello, i have a running Backup Job, that does not stop. It's running for over 24h now. I tried to stop it via GUI, which is not possible; also via Powershell / CLI which also failed. The GUI has no "Stop" button. The Powershell / CLI claims…
create sp to populate table from one db to another
Hi, how to create Store procedure to populate data from one database table to another database table and do we need to refresh or it will auto sync
Azure PostgreSQL flexible Server Database Managed Identity connection
Hello, -We have created Azure postgres Flexible server with Microsoft Entra Authentication only deployment as Paas in Azure subscription. -We have added Azure Service Principal into Database admin user via Azure portal. We have created Azure VM and…
How can I manage the Virtual Network of an Azure PostgresSQL Flexible server after changing the DB's subscription?
I'm trying to move my cloud resources into a new Subscription. I was able to successfully move an Azure Database for PostgresSQL to a new subscription, however the attached virtual network cannot be changed. Per MSFT documentation, the attached virtual…
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…
Need to know ETA of reservations support for V5 instance series of Azure Database for PostgreSQL flexible server.
We need to know ETA of reservations support for V5 instance series of Azure Database for PostgreSQL flexible server, as we're thinking to upgrading all of our servers to V5 along with taking benefit of reservations for it.
Failedto load PostgreSQL Flexible serverdatabases
Hi everyone Maybe who knows what is going on?
AZURE DATA FACTORY STORED PROCEDURE WITH POSTGRESQL SERVER
Dear Microsoft Support, I have created a stored procedure in a PostgreSQL server and established a linked service for that server in Azure Data Factory (ADF). My goal is to execute this stored procedure within a pipeline in ADF. However, when I attempt…
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…
How to unstack these data?
I was given these data below, and asked the following question. How would I go about it? B) From the below table, analyze, interpret and show the performance and trend within 3 years using the following secondary data of Women and girl traders’ annual…
Azure Synapse Analytics | Pipeline | Linked Service to "Azure Database for PostgreSQL" not available in 'Stored Procedure'
Hi everyone, I am trying to create a simple pipeline in Azure Synapse Analytics which should write some files' metadata fields into a Database. To do so, I first created a linked service to a postresql database instance hosted on Azure: I am now trying…
Azure Database for PostgreSQL flexible server stuck in restart state
Hi, our Azure Database for PostgreSQL flexible server is stuck in restarting state. We noticed to late that storage is utilized 100% and now we can’t increase the instance or do any modifications. We can't even delete it, it just states that it is in…
pgaadauth_create_principal does not exist in my flexible postgresql instance
I am trying to create users that I will later use to log in from my kubernetes service. I have set up 2 admins for this database 1. being a user group on which I am added and the other being a service principal. I tried to use the create_principal…