Azure SQL alternative
Hi, Currently, we are using Azure SQL Single database for a multi-tenant app. We are facing performance issue and keep scaling up to cope with the query volumes (and trying to optimize query with Query Performance Insight). If we don't want to…
Enable Connections logs on Azure Database for PostgreSQL
How can I configure Azure Database for PostgreSQL to log all connection attempts, including the IP addresses of clients, whether the connection is successful or failed? I want to monitor and log every IP trying to connect to our database for auditing and…
Is there a way to entity resolution / entity deduplication at scale with PostgreSQL and PGvector?
I'm working on merging company data from several different providers. I'm exploring an entity resolution approach using separate embeddings for name, location, and domain, stored in vector indexes. I'm considering postges as a database option, however…
Why does the major version update fail when postgis is installed
The serverlogs show the following error when doing a major version upgrade from postgres version 14 to version 16. Installed postgis, postgis_raster and postgis_sfcgal. ERROR 0A000 SELECT…
Can the replica be safely used for read-only operations in the application, or is there a risk of data being out of sync or not reflecting real-time updates?
I am using Azure Database for PostgreSQL servers and have created a replica of one of them for production purposes. Can the replica be safely used for read-only operations in the application, or is there a risk of data being out of sync or not reflecting…
Integrate storage, database, webapp, and databricks into one VNET
We are hardening our ML platform in Azure. Basically, we want to put all the Azure services ( ADLS, PostgreSQL DB, Web App, and Databricks cluster) in one virtural network so all the traffic will be inside the Azure network whenever possible (except the…
Azure Database for PostgreSQL - Flexible Server is taking too long to initialize
When trying to create a Azure Database for PostgreSQL - Flexible Server. It is taking too much time to initialize. I tried to create it with a basic spec and even tried changing the region. But it is stuck in the initialization process.
Azure DB Single Server Public IP migration options
For Azure Database for PostgreSQL Single Server...The migration process needs to be performed to move it to the Flexible Server service. Supported network scenarios for migration are discussed here... …
Failed to connect PosgresDB Flexible Server From a private AKS
Hi all, I am experiencing an issue with connecting to a PostgreSQL database from a private AKS cluster. The AKS and the database are located in two different virtual networks and subscriptions. To debug the connection, I created a pod using the following…
Cannot Connect to PosgresDB Flexible Server From in Private AKS
Hi all, I am experiencing an issue with connecting to a PostgreSQL database from a private AKS cluster. The AKS and the database are located in two different virtual networks and subscriptions. To debug the connection, I created a pod using the following…
PostgreSQL query to find the host name
HI Team, I am looking for a PostgreSQL command/query (not Azure CLI )that i can run in Azure PostgreSQL flexible server to get the server name. currently i can get this info using the below psql command "\conninfo", but this command works only…
Unable to stop/restart PostgreSQL Flexible Server (CPU at 100%)
I have a Azure Database for PostgreSQL - Flexible Server with its CPU usage at 100% for the past weeks... In the same period, the storage usage has also significantly increased to 80-90% of its 64 GB capacity. I am unable to stop/restart the server via…
Missing all data in Monitoring Metrics for Azure Database for PostgreSQL - Flexible Server
Firstly, I have followed the instructions found in the following threads and nothing works: 1- https://zcusa.951200.xyz/en-us/answers/questions/2134061/azure-database-for-postgresql-metric-storage-perce 2-…
Does Azure support PostgreSQL version 16.6?
Hello, My project is currently using version 15.7 of PostgreSQL Flexible server. However, we need to do an update to fix the following security vulnerabilities: https://www.postgresql.org/support/security/CVE-2024-10976/ …
How can I connect to the Postgres Flexible server to Azure Web App on Virtual Network from a different region.
I have a Azure Postgres Flexible server hosted in SouthEast Asia and hosting the backend Azure Web App hosted on East US (Proximity to the Azure OpenAI models), here the Azure Web App is not able to connect to the Postgres Flexible server. I have created…
convert postgresql to spark sql
Has any one has used or is aware of a tool that can convert postgresql code to Spark SQL code to run in Databricks? our case: we have to write query in dbeaver to create new logics but want to create new views/tables using Data bricks. We have…
Unable to use function schedule_in_database using azure_pg_admin
Dear Azure community, We have recently subscribed to Azure PostgreSQL 16 from SAP BTP for Production instance. However, we have not been able to use cron function "schedule_in_database" to schedule jobs. We are facing the below permission…
Create Postgres error Subscription 'xxxxxx' is not allowed to provision in 'East US'.
I am trying to create a postgres database in the East US region, but I get the following error Subscription 'xxx' is not allowed to provision in 'East US' Please, does anyone know how to solve it?
Azure Cosmos Postgresql issue with Role creation
Hi, We are using Azure Cosmos Postgresql DB and we are experiencing issues with Role creation. We created a role from console as well as az cli using below command - The command shows succeeded and the role is visible. However the same role is not…
Postgre-SQL Flexible Server - pg_cron permissions issue
I am connecting to the postgres database with the psqladminun user who is a member of the azure_pg_admin role. I run the following: CREATE EXTENSION pg_cron; After that I go to schedule a job: SELECT cron.schedule_in_database('part_maint_TEST','0 * * *…