Azure Database for PostgreSQL
An Azure managed PostgreSQL database service for app development and deployment.
1,159 questions
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…
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(76.8, 21%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAL%3C/text%3E%3C/svg%3E)
0 answers
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…
asked 2025-01-10T03:46:57.2766667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(227.2, 85%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESD%3C/text%3E%3C/svg%3E)
subhash-DBA
105
Reputation points
commented 2025-01-13T22:40:09.81+00:00
subhash-DBA
105
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.
asked 2025-01-13T12:05:49.72+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(217.60000000000002, 32%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAM%3C/text%3E%3C/svg%3E)
Adish M
0
Reputation points
commented 2025-01-13T19:31:20.78+00:00
Oury Ba-MSFT
19,991
Reputation points Microsoft Employee
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…
asked 2025-01-13T16:57:23.53+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(256, 81%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGJ%3C/text%3E%3C/svg%3E)
Grover, Jyoti
40
Reputation points
commented 2025-01-13T17:40:47.7533333+00:00
Oury Ba-MSFT
19,991
Reputation points Microsoft Employee
2 answers
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…
asked 2025-01-08T19:51:51.9966667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(99.2, 61%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EG%3C/text%3E%3C/svg%3E)
Gia
1
Reputation point
answered 2025-01-13T17:24:11.5166667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(252.8, 60%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMK%3C/text%3E%3C/svg%3E)
Mahesh Kurva
1,700
Reputation points Microsoft Vendor
0 answers
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…
asked 2025-01-13T09:22:14.5+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(89.60000000000001, 32%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHH%3C/text%3E%3C/svg%3E)
Huynh, Huu Thang
0
Reputation points
commented 2025-01-13T16:36:51.36+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(35.2, 49%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVK%3C/text%3E%3C/svg%3E)
Vijayalaxmi Kattimani
905
Reputation points Microsoft Vendor
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-…
asked 2025-01-02T20:15:35.4833333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(57.599999999999994, 20%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGP%3C/text%3E%3C/svg%3E)
Greg Polanco
0
Reputation points
answered 2025-01-13T16:36:47.9+00:00
Mahesh Kurva
1,700
Reputation points Microsoft Vendor
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…
asked 2025-01-12T13:06:16.08+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(262.40000000000003, 8%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERH%3C/text%3E%3C/svg%3E)
Richard Huesken
1
Reputation point
commented 2025-01-13T15:28:41.68+00:00
Richard Huesken
1
Reputation point
0 answers
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…
asked 2025-01-13T09:14:08.78+00:00
Huynh, Huu Thang
0
Reputation points
commented 2025-01-13T12:59:25.2866667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(54.400000000000006, 71%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGP%3C/text%3E%3C/svg%3E)
Ganesh Patapati
2,825
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/ …
asked 2025-01-09T11:47:33.3033333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(281.6, 39%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJP%3C/text%3E%3C/svg%3E)
Joana Pedroso
0
Reputation points
commented 2025-01-13T09:58:47.5633333+00:00
Vijayalaxmi Kattimani
905
Reputation points Microsoft Vendor
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…
asked 2025-01-07T04:55:54.2833333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(121.6, 39%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECS%3C/text%3E%3C/svg%3E)
Choppakatla, Sasi Kiran
0
Reputation points
edited a comment 2025-01-13T07:49:17.65+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(220.8, 4%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESM%3C/text%3E%3C/svg%3E)
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?
asked 2025-01-13T03:08:17.9666667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(217.60000000000002, 22%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJG%3C/text%3E%3C/svg%3E)
Jeferson Galhardi de Godoy
20
Reputation points
accepted 2025-01-13T03:49:27.7066667+00:00
Jeferson Galhardi de Godoy
20
Reputation points
0 answers
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... …
asked 2025-01-07T17:15:54.6866667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(166.4, 51%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVI%3C/text%3E%3C/svg%3E)
Vision Intelligence
20
Reputation points
commented 2025-01-10T21:06:20.68+00:00
Vision Intelligence
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…
asked 2024-08-23T08:53:50.2166667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(70.4, 3%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVM%3C/text%3E%3C/svg%3E)
Vipal Mehta
40
Reputation points
commented 2025-01-10T17:14:52.0333333+00:00
Oury Ba-MSFT
19,991
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 * * *…
asked 2024-11-20T22:35:13.98+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(44.800000000000004, 6%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHJ%3C/text%3E%3C/svg%3E)
Herman, Justin
35
Reputation points
commented 2025-01-10T14:22:18.88+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(156.8, 0%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EES%3C/text%3E%3C/svg%3E)
Eric Swiggum
0
Reputation points
0 answers
Postgres Flexible Server 15.8 No Longer Supports ANY md5 Functionality
The 15.8 version of the server no longer supports md5 hashing. The 15.7 version allows us to call the MD5() function within the server. We DO NOT use this function for passwords or other security mechanisms. It is purely used to create a unique,…
asked 2024-10-16T19:27:38.1866667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(108.80000000000001, 94%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDC%3C/text%3E%3C/svg%3E)
David Carson
0
Reputation points
commented 2025-01-08T20:48:18.1333333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(240, 10%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMM%3C/text%3E%3C/svg%3E)
Matthew Mckenzie
5
Reputation points
0 answers
Connection Refused from AKS cluster to Postgres Flex server
Hi All, I am getting connection refused error while connecting to Postgres Flex server from AKS Cluster pod. Same Postgres Flex server connection is working fine from PgAdmin. Can someone please help what could be wrong configuration from AKS…
asked 2024-12-31T11:49:47.77+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(246.4, 91%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESA%3C/text%3E%3C/svg%3E)
Shah, Apoorv-XT
0
Reputation points
commented 2025-01-08T07:40:31.3766667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(300.8, 3%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESK%3C/text%3E%3C/svg%3E)
Sai Krishna Katakam
1,685
Reputation points Microsoft Vendor
1 answer
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 Database for PostgreSQL
An Azure managed PostgreSQL database service for app development and deployment.
1,159 questions
Azure Static Web Apps
Azure Static Web Apps
An Azure service that provides streamlined full-stack web app development.
1,039 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.
513 questions
asked 2025-01-02T18:58:16.6733333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(76.8, 8%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Ashwin
0
Reputation points
commented 2025-01-08T00:37:37.06+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(304, 61%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELR%3C/text%3E%3C/svg%3E)
Laxman Reddy Revuri
1,525
Reputation points Microsoft Vendor
1 answer
One of the answers was accepted by the question author.
Request to Enable PostGIS Extension on Azure PostgreSQL Server
I am hosting a PostgreSQL server on Azure and need to use the PostGIS extension for my project. However, when attempting to install the extension with the azure_pg_admin user, I receive the following error: ERROR: extension "postgis" is not…
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(204.8, 70%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETT%3C/text%3E%3C/svg%3E)
1 answer
One of the answers was accepted by the question author.
Can't renew reservation for Azure Database for PostgreSQL expiring
Presently still using Azure Database for PostgreSQL - Single Server. We have a reservation that expires near end of January (azuredb_postgresql_general_purpose_compute_gen5 - East US). When attempt to purchase another reservation, only Flexible Server…
asked 2025-01-06T13:46:39+00:00
Vision Intelligence
20
Reputation points
accepted 2025-01-07T16:49:13.7333333+00:00
Vision Intelligence
20
Reputation points