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 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 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
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…
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…
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…
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
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…
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…
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", …
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…
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…
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…
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…
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…
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…
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?
PGRouting availability for PostgreSQL 16 Flexible Server
Is there any update on when the PGRouting extension will be available for PostgreSQL16 flexible server please?
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 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,…