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…
![](https://techprofile.blob.core.windows.net/images/9CqRWkWyk0WIvV6eSiSD-g.png?8DB6B7)
The Azure Database for PostgreSQL -flexible server metric connections_failed doesn't always have a value
Hello everyone, I have faced an issue regarding Azure Database for PostgreSQL -flexible server metrics, which I hoped someone here can help me solve it. I have an Azure Database for PostgreSQL - flexible server, which has an alert configured on it, so I…
![](https://techprofile.blob.core.windows.net/images/9CqRWkWyk0WIvV6eSiSD-g.png?8DB6B7)
Azure Postgres Flexible server: Unable to add azure_storage extension
We are unable to add a the azure_storage extension to a second database. We got it to work on the default postgres database but when trying to add it to a second database with CREATE EXTENSION azure_storage; We get role "azure_storage_admin"…
![](https://techprofile.blob.core.windows.net/images/9CqRWkWyk0WIvV6eSiSD-g.png?8DB6B7)
– “FATAL: ERROR: could not extend file "base/24834/32917": No space left on device
while copying data via ora2pg getting below error message. Please suggest where space need to be added. – “FATAL: ERROR: could not extend file "base/24834/32917": No space left on device
Postgres HA - zone redundant availability Southeast Asia
Based on the following article https://learn.microsoft.com/en-us/azure/postgresql/flexible-server/overview#azure-regions the Azure Database for PostgreSQL - Flexible Server in Southeast Asia has a capability of Zone Redundant HA, however when i created…
Problem with pg_dumpall in PostgreSQL Flexible Server
I have an Azure Database for PostgreSQL flexible server (version 12). I'm trying to upgrade using the official docs (the goal is to upgrade to 14). The first step is to dump the roles pg_dumpall -r --host=mySourceServer --port=5432 --username=myUser…
Is Azure Postgresql Flex server HIPAA COMPLIANT
I want to if Is Azure Postgresql Flex server HIPAA COMPLIANT that I am using to build Datawarehouse.
PostgreSQL Flex - storing Terrabytes of data and setting up scheduled pipelines
is it ok to store and manage Terabytes of data? 2.Azure functions or Azure Data factory and Azure Databricks which one is best business practice to use to schedule pipelines.
Pgrouting for PostgreSql Azure flexible server does not appear as extension to allow even when is recently supported by Azure
I have running a Postgres 13.6 Azure flexible server database. We have tried to have pgrouting extension working in combination with postgis. Early this year the extension was not supported by Azure to be installed in our database however has…
Can you change a postgresql flexserver parameter using an Azure policy / remediation ?
Would like to be able to use an Azure policy to audit and change the connection throttling from off to on (for security) for a large number of PostgreSQL flex servers.
![](https://techprofile.blob.core.windows.net/images/kjzQAO5Oq0Oj37wdNf6qTQ.png?8D8E42)
PostgreSQL with read replica in same delegated subnet
Hi, as far as I understand I can assign both main PostgreSQL flexible server and its Read Replica to the same delegated subnet. Should I somehow add some configuration or Azure will be smart enough to assign free IPs from the subnet to the Replica?
![](https://techprofile.blob.core.windows.net/images/9CqRWkWyk0WIvV6eSiSD-g.png?8DB6B7)
Can you add the postgis extension to an azure flexible server with postgres 16?
Hello, I am trying to upgrade our Azure Database for PostgreSQL flexible server to use postgres 16 and i need to add the postgis extension. At the moment we do this via a pipeline which adds the extension to azure.extension however this now gives the…
Cannot connect on 6432 while promoting read replica
I use Azure Flexible Server for PostgreSQL and Read Replica. To the main server I connect on 6432 port since using pgbouncer. Before promoting replica I turn on pgbouncer (using az cli) on replica as well but after promotion I cannot connect on port…
I am trying to provision a Azure Cosmos DB for PostgreSQL Cluster instance using arm template but I don't see a field to set the database name.
I am following this doc - https://learn.microsoft.com/en-us/azure/templates/microsoft.dbforpostgresql/servergroupsv2?pivots=deployment-language-arm-template to provision a Azure Cosmos DB for PostgreSQL Cluster but there is no field to specify the…
![](https://techprofile.blob.core.windows.net/images/aF7q-2Yvk0m_oGZxGMhNRg.png?8DC526)
![](https://techprofile.blob.core.windows.net/images/aF7q-2Yvk0m_oGZxGMhNRg.png?8DC526)
Can not RESTART STOP Postgresql flexible server
Can not restart/stop the server InternalServerError) An unexpected error occured while processing the request. Tracking ID: '8dd3b591-1d09-4077-94eb-7d496f686926' Code: InternalServerError
![](https://techprofile.blob.core.windows.net/images/kjzQAO5Oq0Oj37wdNf6qTQ.png?8D8E42)
Activate pg_cron
Hello everyone.... we need to run some cron in 2 databases that I have in an instance of "Azure Database for PostgreSQL flexible server". For this, enable "azure.extensions -> pg_cron" from the portal, then it seems that I must…
![](https://techprofile.blob.core.windows.net/images/9CqRWkWyk0WIvV6eSiSD-g.png?8DB6B7)
Is password history enforcing feature available in Azure managed postgres server ?
Hi, We are trying to enable password history enforcing feature for our azure managed postgres server. But we are unable to find it. I would like to know if postgresql has this feature? Appreciate your help. Thank you.
How to load balance traffic across Azure DB for PostgreSQL Flex Read Replicas
If we have an Azure DB for PostgreSQL Flex, with a number of read replicas and a number of clients (assume a number of VMs), how can the clients load balance the traffic across the different read replicas?
![](https://techprofile.blob.core.windows.net/images/kjzQAO5Oq0Oj37wdNf6qTQ.png?8D8E42)
How to restore Azure database for postgre single server, if it's Redundancy option is configured as Geo-restore
Hello, I have one production Azure database postgre single server which is configured as below Backup Redundancy options: Geo-restore Backup Retention Period: 7days If I want to restore this database using Azure portal which is configured as…
![](https://techprofile.blob.core.windows.net/images/9CqRWkWyk0WIvV6eSiSD-g.png?8DB6B7)
How to install de SPQLODBC drivers to use IB in Windows ARM
I have being trying to install the drivers psqlODBC_x64 to connect BI to our database, but as several trys I didn't have success, any one has any idea how could it be done?