1,161 questions with Azure Database for PostgreSQL tags

Sort by: Updated
2 answers One of the answers was accepted by the question author.

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…

Azure SQL Database
Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
5,134 questions
Azure Database for PostgreSQL
asked 26 Sept 2022, 2:58 am
Testa 551 Reputation points
edited an answer 17 Jan 2025, 1:59 pm
Bobur Umurzokov 0 Reputation points MVP
0 answers

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…

Azure Database for PostgreSQL
asked 17 Jan 2025, 9:25 am
edited a comment 17 Jan 2025, 1:50 pm
Vijayalaxmi Kattimani 905 Reputation points Microsoft Vendor
0 answers

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…

Azure Database for PostgreSQL
asked 14 Jan 2025, 10:16 am
Arik Levy 20 Reputation points
commented 17 Jan 2025, 10:33 am
Arik Levy 20 Reputation points
1 answer

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…

Azure Database for PostgreSQL
asked 12 Jan 2025, 1:06 pm
Richard Huesken 1 Reputation point
commented 17 Jan 2025, 10:06 am
Richard Huesken 1 Reputation point
2 answers

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…

Azure Database for PostgreSQL
asked 16 Jan 2025, 10:52 am
commented 17 Jan 2025, 8:52 am
Vijayalaxmi Kattimani 905 Reputation points Microsoft Vendor
1 answer One of the answers was accepted by the question author.

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 Virtual Network
Azure Virtual Network
An Azure networking service that is used to provision private networks and optionally to connect to on-premises datacenters.
2,595 questions
Azure Databricks
Azure Databricks
An Apache Spark-based analytics platform optimized for Azure.
2,305 questions
Azure Web Application Firewall
Azure Database for PostgreSQL
asked 22 Nov 2024, 5:43 pm
P, John 240 Reputation points
accepted 17 Jan 2025, 1:04 am
P, John 240 Reputation points
0 answers

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 Database for PostgreSQL
asked 13 Jan 2025, 12:05 pm
Adish M 5 Reputation points
commented 16 Jan 2025, 4:54 pm
Oury Ba-MSFT 20,006 Reputation points Microsoft Employee
1 answer

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... …

Azure Database for PostgreSQL
asked 7 Jan 2025, 5:15 pm
Vision Intelligence 20 Reputation points
answered 16 Jan 2025, 10:24 am
Vision Intelligence 20 Reputation points
1 answer

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…

Azure Database for PostgreSQL
asked 13 Jan 2025, 9:22 am
Huynh, Huu Thang 20 Reputation points
commented 16 Jan 2025, 8:38 am
Vijayalaxmi Kattimani 905 Reputation points Microsoft Vendor
1 answer One of the answers was accepted by the question author.

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…

Azure Private Link
Azure Private Link
An Azure service that provides private connectivity from a virtual network to Azure platform as a service, customer-owned, or Microsoft partner services.
527 questions
Azure Kubernetes Service (AKS)
Azure Kubernetes Service (AKS)
An Azure service that provides serverless Kubernetes, an integrated continuous integration and continuous delivery experience, and enterprise-grade security and governance.
2,229 questions
Azure Database for PostgreSQL
asked 13 Jan 2025, 9:14 am
Huynh, Huu Thang 20 Reputation points
commented 16 Jan 2025, 7:05 am
Huynh, Huu Thang 20 Reputation points
1 answer

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…

Azure Database for PostgreSQL
asked 10 Jan 2025, 3:46 am
subhash-DBA 105 Reputation points
commented 16 Jan 2025, 6:46 am
NIKHILA NETHIKUNTA 4,100 Reputation points Microsoft Vendor
2 answers One of the answers was accepted by the question author.

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…

Azure Database for PostgreSQL
asked 8 Jan 2025, 7:51 pm
Gia 21 Reputation points
accepted 15 Jan 2025, 6:25 pm
Gia 21 Reputation points
2 answers

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-…

Azure Database for PostgreSQL
asked 2 Jan 2025, 8:15 pm
Greg Polanco 0 Reputation points
commented 15 Jan 2025, 5:03 pm
Mahesh Kurva 1,785 Reputation points Microsoft Vendor
0 answers

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/ …

Azure Database for PostgreSQL
asked 9 Jan 2025, 11:47 am
Joana Pedroso 0 Reputation points
commented 15 Jan 2025, 10:13 am
Vijayalaxmi Kattimani 905 Reputation points Microsoft Vendor
1 answer One of the answers was accepted by the question author.

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…

Azure Database for PostgreSQL
Azure Static Web Apps
Azure Static Web Apps
An Azure service that provides streamlined full-stack web app development.
1,046 questions
Azure Startups
Azure Startups
Azure: A cloud computing platform and infrastructure for building, deploying and managing applications and services through a worldwide network of Microsoft-managed datacenters.Startups: Companies that are in their initial stages of business and typically developing a business model and seeking financing.
521 questions
asked 2 Jan 2025, 6:58 pm
Ashwin 20 Reputation points
accepted 15 Jan 2025, 3:51 am
Ashwin 20 Reputation points
0 answers

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…

Azure Database for PostgreSQL
asked 13 Jan 2025, 4:57 pm
Grover, Jyoti 40 Reputation points
commented 14 Jan 2025, 11:21 pm
Oury Ba-MSFT 20,006 Reputation points Microsoft Employee
0 answers

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…

Azure Database for PostgreSQL
asked 7 Jan 2025, 4:55 am
Choppakatla, Sasi Kiran 0 Reputation points
edited a comment 13 Jan 2025, 7:49 am
ShaktiSingh-MSFT 16,171 Reputation points
1 answer One of the answers was accepted by the question author.

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 Database for PostgreSQL
asked 13 Jan 2025, 3:08 am
Jeferson Galhardi de Godoy 20 Reputation points
accepted 13 Jan 2025, 3:49 am
Jeferson Galhardi de Godoy 20 Reputation points
2 answers

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…

Azure Cosmos DB
Azure Cosmos DB
An Azure NoSQL database service for app development.
1,726 questions
Azure Database for PostgreSQL
asked 23 Aug 2024, 8:53 am
Vipal Mehta 40 Reputation points
commented 10 Jan 2025, 5:14 pm
Oury Ba-MSFT 20,006 Reputation points Microsoft Employee
2 answers One of the answers was accepted by the question author.

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 * * *…

Azure Database for PostgreSQL
asked 20 Nov 2024, 10:35 pm
Herman, Justin 35 Reputation points
commented 10 Jan 2025, 2:22 pm
Eric Swiggum 0 Reputation points