1,111 questions with Azure Database for PostgreSQL tags

Sort by: Updated
1 answer

locate PostgreSQL databases exact location

locate PostgreSQL databases exact location in Azure's North European regions For GDPR compliance status. Azure Database for PostgreSQL - Flexible Servers GDPR compliance status based on region Resource group aoih-prod Subscription…

Azure Database for PostgreSQL
asked 2024-11-15T09:21:31.5233333+00:00
Gazzela Vivakar 10 Reputation points
commented 2024-11-18T06:03:04.03+00:00
Sai Raghunadh M 1,045 Reputation points Microsoft Vendor
0 answers

Azure Postgre SQL

Hi Team, Getting connection timed out error while connecting to Azure Postgre SQL server using Data Studio. Can someone please help? Regards, Tahseen

Azure Database for PostgreSQL
asked 2024-11-15T03:58:55.5466667+00:00
tfiroz 0 Reputation points
commented 2024-11-18T04:59:11.1666667+00:00
ShaktiSingh-MSFT 15,526 Reputation points
2 answers One of the answers was accepted by the question author.

Azure postgres flexible server timescale pgai "ai" extension availability

Hello Does anybody know if there will be a update to timescaledb on azure to make pgai available from timescale? Kind regards Adrian

Azure Database for PostgreSQL
Azure OpenAI Service
Azure OpenAI Service
An Azure service that provides access to OpenAI’s GPT-3 models with enterprise capabilities.
3,276 questions
asked 2024-11-16T20:15:26.7166667+00:00
Adrian Ruchti 0 Reputation points
accepted 2024-11-17T18:02:49.0633333+00:00
Adrian Ruchti 0 Reputation points
2 answers

ADX plugin postgresql_request failed to load System.Security.Cryptography.Algorithms

I have an Azure Data Explorer (ADX) instance in combination with a PostgreSQL Flexible Server (16.4) and want to access the SQL table test_adx_meta from ADX. There are no firewall or IP range limitations. I followed the official postgres_request…

Azure Data Explorer
Azure Data Explorer
An Azure data analytics service for real-time analysis on large volumes of data streaming from sources including applications, websites, and internet of things devices.
533 questions
Azure Database for PostgreSQL
asked 2024-11-13T10:24:34.47+00:00
lwerthm 0 Reputation points
commented 2024-11-15T18:19:20.4633333+00:00
Mahesh Kurva 810 Reputation points Microsoft Vendor
2 answers

ADF - postgres: Read method cannot be called when another read operation is pending

I'm using Azure Data Factory copy data activity to move data from Azure PostgreSQL to OneLake. I'm using a self-hosted integration runtime for that (because of how our VNETs are set up). Here is the error I'm getting: Operation on target…

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
10,876 questions
Azure Database for PostgreSQL
asked 2024-11-12T09:22:24.8866667+00:00
Mart Roben 0 Reputation points
answered 2024-11-15T13:45:46.93+00:00
Ganesh Gurram 1,350 Reputation points Microsoft Vendor
1 answer

How to search across multiple vector indexes in PostgreSQL with PGVector

TLDR: Is there a way to query both embedding columns in the same query, and ensure it uses the respective indexes e.g IVFFLAT and HNSW respectively in the same query? I've created this table with pgvector extension enabled: CREATE TABLE IF NOT EXISTS…

Azure Database for PostgreSQL
asked 2024-11-13T15:26:58.6033333+00:00
Arik Levy 0 Reputation points
commented 2024-11-15T12:12:10.9733333+00:00
Sina Salam 12,246 Reputation points
0 answers

Internal Server Error while creating DBforPostgreSQL flexibleServers

I keep getting a an unexpected error occured while processing the request to create a new flexible server. Code: InternalServerError

Azure Database for PostgreSQL
asked 2024-11-12T16:41:19.2233333+00:00
Sam Nehmat (Cloud Admin) 0 Reputation points
commented 2024-11-15T08:46:36.83+00:00
NIKHILA NETHIKUNTA 3,270 Reputation points Microsoft Vendor
1 answer

Flexible server performance

I m using Azure PostgreSQL Flexible Server (version 14.x) for a web application with high-concurrency, OLTP workloads. The database is hosted on a Standard_B1ms SKU (2 vCores, 8 GB RAM) and is growing to around 200 GB. We’re experiencing slow query…

Azure Database for PostgreSQL
asked 2024-11-15T07:01:54.1166667+00:00
DataCoder 220 Reputation points
answered 2024-11-15T07:47:36.97+00:00
NIKHILA NETHIKUNTA 3,270 Reputation points Microsoft Vendor
1 answer

Impact of azure_pg_admin Role on Query Performance in Azure PostgreSQL Flexible Server

We’re using Azure PostgreSQL Flexible Server (v.13) and noticed a significant performance disparity between users that have the azure_pg_admin role and those that don’t. For example, queries that complete in milliseconds for users with azure_pg_admin…

Azure Database for PostgreSQL
asked 2024-11-07T12:51:22.43+00:00
Azeem, Muhammad 0 Reputation points
commented 2024-11-14T04:01:32.8133333+00:00
ShaktiSingh-MSFT 15,526 Reputation points
0 answers

How to fix a malformed backend type returned from an Azure sys query?

A malformed backend_type is returned from an azure_sys query in Azure Flexible PostgreSQL pg_stat_activity table: [ { "state": "idle", "query": "SELECT query_stats.pgms_stats_insert_data", …

Azure Database for PostgreSQL
asked 2024-11-11T17:03:22.3766667+00:00
Savan Dosanjh 0 Reputation points
commented 2024-11-14T03:48:31.1433333+00:00
ShaktiSingh-MSFT 15,526 Reputation points
2 answers One of the answers was accepted by the question author.

Can I change to owner of a database in Azure Database for PostgreSQL flexible server?

I have a database created with the migration tool in the Azure Database for PostgreSQL flexible server. The migration tool sets the database owner as the server admin, and I want to change the owner to a different role. How do I do this? ALTER DATABASE…

Azure Database for PostgreSQL
asked 2024-06-12T19:41:39.73+00:00
Kristine Kisman 25 Reputation points
commented 2024-11-13T16:45:37.3+00:00
Zeinab Khosravi 40 Reputation points
1 answer One of the answers was accepted by the question author.

How to fix FATAL: remaining connection slots are reserved for roles with privileges of the "pg_use_reserved_connections" role on an Azure Database for PostgreSQL flexible server.

Hi. I have a database running on an Azure Database for PostgreSQL flexible server. I have been managing the database using pgAdmin. Now i am not able to access or login as i am getting the following error, FATAL: remaining connection slots are reserved…

Azure Database for PostgreSQL
asked 2024-10-25T12:37:37.95+00:00
Abhishek M 20 Reputation points
edited a comment 2024-11-13T15:08:32.6566667+00:00
Johnson, Eric M (MNIT) 0 Reputation points
0 answers

Performance issues after scaling up Azure Database for PostgreSQL - Flexible Server

We're running Azure Database for PostgreSQL - Flexible Server on General Purpose, D8ds_v5 (8 vCores, 32 GiB RAM) with 2Tb storage. After switching to D16ds_v5 (16 vCores, 64 GiB RAM) with 4Tb storage, the performance decreased significantly. All the…

Azure Database for PostgreSQL
asked 2024-11-11T21:13:35.8533333+00:00
Tigran Sardaryan 0 Reputation points
commented 2024-11-13T07:11:37.1633333+00:00
NIKHILA NETHIKUNTA 3,270 Reputation points Microsoft Vendor
2 answers

Unable to upgrade Postgresql Flexible Server from V14 to V16

Dear Azure Support, I would like to do a major upgrade of Postgres Flexible Server from V14 to V16. I always get the following error message, although I have removed extensions dblink and postgres_fdw. PS C:\Program Files\PowerShell\7> az postgres…

Azure Database for PostgreSQL
asked 2024-11-08T15:16:50.1133333+00:00
Martin Constam 0 Reputation points
edited an answer 2024-11-12T14:53:28.2233333+00:00
Chi Kit Yuen 0 Reputation points
3 answers One of the answers was accepted by the question author.

Deploying Azure flexible server hangs

Following this page: https://learn.microsoft.com/en-us/azure/postgresql/flexible-server/tutorial-webapp-server-vnet When creating the actual database, the process hangs. It eventually fails after a couple hours with this: The resource write operation…

Azure Database for PostgreSQL
asked 2024-11-07T23:45:12.63+00:00
Julian Wood 20 Reputation points
accepted 2024-11-12T03:47:52.51+00:00
Julian Wood 20 Reputation points
1 answer

Unable to Provision Azure PostgreSQL Flexible Server in West US 2 with FoundersHub Subscription

We are currently running our PostgreSQL database on an Ubuntu VM and would like to migrate to Azure PostgreSQL Flexible Server. However, when we attempt to create this resource in the West US 2 region, we encounter the following…

Azure Database for PostgreSQL
asked 2024-11-05T10:17:18.0033333+00:00
Mustafa Savas 0 Reputation points
commented 2024-11-07T12:50:27.62+00:00
Vijayalaxmi Kattimani 415 Reputation points Microsoft Vendor
2 answers

Auto increment postgres serial type in logic app insert row action ID field

Hi, The insert row action is requiring an ID field but my table in postgres is type serial. Is there anyway to tell the logic app that an ID field does not need to be set on the insert as postgres will auto increment this field?

Azure Logic Apps
Azure Logic Apps
An Azure service that automates the access and use of data across clouds without writing code.
3,222 questions
Azure Database for PostgreSQL
asked 2022-03-01T00:53:14.293+00:00
Liam O'Dowd 26 Reputation points
answered 2024-11-07T07:13:45.96+00:00
Power Automate 0 Reputation points
1 answer

PGRouting availability for PostgreSQL 16 Flexible Server

Is there any update on when the PGRouting extension will be available for PostgreSQL16 flexible server please?

Azure Database for PostgreSQL
asked 2024-10-31T08:09:07.3633333+00:00
Cooling, Steve 20 Reputation points
commented 2024-11-06T19:11:40.05+00:00
Oury Ba-MSFT 19,571 Reputation points Microsoft Employee
1 answer

I want to get permission to create schema in COSMOS DB for postgresql

I am currently working on migrating data from AWS Aurora database to Azure Cosmos db for postgresql. I tried to use airbyte as a tool for that, but when I connect cosmos db as target database in airbyte, I get an error saying that I don't have permission…

Azure Cosmos DB
Azure Cosmos DB
An Azure NoSQL database service for app development.
1,680 questions
Azure Database for PostgreSQL
asked 2024-11-01T16:28:46.5533333+00:00
paradigmshift 0 Reputation points
commented 2024-11-06T18:08:25.93+00:00
NIKHILA NETHIKUNTA 3,270 Reputation points Microsoft Vendor
2 answers One of the answers was accepted by the question author.

Azure Database for PostgreSQL - Flexible Server - How to modify table owner

Does anyone know how to modify table owner in Azure Database for PostgreSQL - Flexible Server (postgres v13)? I have a administrator role account admindemo (member of azure_pg_admin) and another account named 'liquibase for managing tables, functions,…

Azure Database for PostgreSQL
asked 2024-11-04T02:48:06.53+00:00
aya 40 Reputation points
accepted 2024-11-06T08:07:52.3333333+00:00
aya 40 Reputation points