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,…
Failedto load PostgreSQL Flexible serverdatabases
Hi everyone Maybe who knows what is going on?
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…
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…
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 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…
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 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…
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…
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…
Azure Data Factory managed private endpoint to Azure PostgresSQL flexible server
In my infra I have a Vnet with two subnets: application-subnet delegated-subnet The Azure Data Factory instance is on application-subnet. The Azure PostgreSQL flexible server is in delegated-subnet and is configured with Private Access (VNET…
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:…
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…
Azure Database for PostgreSQL flexible server stuck in restarting state
I changed some server parameters on my server and in the activity log the 'Update PostgreSQL server configuration' succeeded but it has now been stuck in a restarting state for over 4 hours. I have tried to stop, start and restart via CLI but all…
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…
Using key vault to customize the encryption keys at rest for Azure Database PostgreSQL imply any cost on for encrypt/decrypt operations?
Hi, Based on the pricing for Key Vault, encryption/decryption operations via API are charged. My question is, does this also imply cost for PostgreSQL DBaaS using custom encryption keys stored in Azure Key Vault or the cost for encrypting/decrypting…
I am using PostgreSQL server service on azure platform accidentally i have replaced my PostgreSQL server and all the data has been lost. The server has been recreated but the data is lost and the backups have been done from the date of new creation.
I am using PostgreSQL server service which is handled by terraform. Recently I have recreated the server and the databases inside it accidentally while making a few changes to the code. The server has been recreated but the data is lost. The backup is…
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…