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?
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
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…
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.
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…
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…
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…
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…
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…
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…
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…
Failedto load PostgreSQL Flexible serverdatabases
Hi everyone Maybe who knows what is going on?
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…
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…
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…
Subject: Updating Extension Versions Without Superuser Privileges in Azure Database for PostgreSQL - Flexible Server
Hello, I am working with Azure Database for PostgreSQL - Flexible Server and am trying to update the vector extension from version 0.4.1 to 0.5.1. However, I've encountered a couple of issues due to the lack of superuser privileges, which are not…
Azure PostgreSQL flexible server: Unable to transfer ownership of table
We are using posgres 16.0. When trying to transfer ownership of a table with ALTER TABLE schema.table OWNER TO "new_role" We get error: must be able to SET ROLE "new_role" We are logged in as azure_pg_admin user and have confirmed…
Azure PostgreSQL Flexible server: Unable to drop roles
We are having some weird issues when trying to remove roles. I am connected as the admin user that is member of azure_pg_admin. When trying to remove a role with DROP ROLE role_to_drop We get the error "Could not drop the role. Only roles with the…
Private enpoint options missing from PostgreSQL Flexible Server
I'm trying to set up a private endpoint for a public facing PostgreSQL flexible server, but the option is missing from the Networking tab of my database. I have other databases that have this option and I've successfully set up links to virtual networks…
Slowness issue in database
Database is migrated from Oracle to Postgresql. In pg database insert query is running longer and taking 3Hours to complete where as same insert query is taking 30 sec at oracle platform.