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.
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?
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…
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
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…
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?
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…
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?
Azure database for PostgreSQL Flexible Server - RPO
Hi, Propose to use Azure database for PostgreSQL Flexi Server (HA+ Read Replica) for our one of the business-critical application. I have gone through the article.…
How to fix web app deployment not loading - 504.0 GatewayTimeout
Hello, My web app does not load and instead times out after a few minutes to the 504.0 Gateway Timeout error. I am using the Azure Database for PostgreSQL flexible server and Azure Plan as the subscription and Node as the Runtime stack. Perhaps it is…
Alerting on backups events for the managed automated backup
Hi we have a requirement to enable alerts on backup events (success/failed), for the automated backup solutions. Is there any metrics available to enable such alerts? I was following this similar question, and it seems like this was not there last year.…
Azure Postgres Flexible - pg_signal_backend
We are attempting to use Azure Postgres Flexible Our application needs to terminate existing existing connection and then drop the database. This requires 'pg_signal_backend' https://www.postgresql.org/docs/current/predefined-roles.html However, this…
Trigger Not working in PostgreSQL 13.12 (PAAS)
The trigger is not working in Postgres 13 (PAAS) but in the standalone Postgres 13 the triggers are working. The trigger is unable to call the respective function which will perform the insert from one table to another. Not getting any error also. Basic…