1,116 questions with Azure Database for PostgreSQL tags

Sort by: Updated
1 answer

Azure Database for PostgreSQL resource not showing up in Azure portal

We have a postgres database, it is present in the subscription invoices. It is available for applications, but it is not visible in the resource group and is not visible anywhere except in the payment invoices.

Azure Database for PostgreSQL
asked 2024-11-20T11:49:56.4133333+00:00
Vlad Shendykov 0 Reputation points
commented 2024-11-21T14:52:07.4+00:00
Vlad Shendykov 0 Reputation points
1 answer

Azure Database for PostgreSQL - Flexible Server: Setting Session Replication Role in JDBC Options

Is it possible to set the session replication role in JDBC options for Azure Database for PostgreSQL - Flexible Server (Postgres v13)? While I was able to execute SET session_replication_role = 'replica' directly in the database, I encountered an error…

Azure Database for PostgreSQL
asked 2024-11-21T09:37:48.5066667+00:00
lye 0 Reputation points
commented 2024-11-21T10:29:06.49+00:00
Sai Raghunadh M 1,125 Reputation points Microsoft Vendor
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-21T09:37:38.3733333+00:00
Sai Raghunadh M 1,125 Reputation points Microsoft Vendor
1 answer

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 2024-11-20T22:35:13.98+00:00
Herman, Justin 0 Reputation points
edited a comment 2024-11-21T00:26:52.73+00:00
Herman, Justin 0 Reputation points
1 answer One of the answers was accepted by the question author.

How to migrate database users from Azure PostgreSQL single server to flexible server?

Hello team, I was using the migration tool provided in Azure portal to migrate databases from PostgreSQL single server to flexible server.The migration itself was successful and I could see my database and data in the flexible server. The issue I am…

Azure Database for PostgreSQL
asked 2024-05-06T18:47:09.7233333+00:00
Pratik 20 Reputation points
commented 2024-11-21T00:20:32.5266667+00:00
Oury Ba-MSFT 19,571 Reputation points Microsoft Employee
1 answer

Resetting pg_stat_statements statistics in Azure Database for PostgreSQL - Flexible Server

How do I reset the pg_stat_statements statistics in Azure Database for PostgreSQL - Flexible Server? Postgres has a pg_stat_statements_reset() function which can be used but I am not able to execute this function using the server admin account. select…

Azure Database for PostgreSQL
asked 2024-10-17T06:46:32.6866667+00:00
Jeff Chan 0 Reputation points
commented 2024-11-20T08:47:06.19+00:00
Fotis Papadamis 0 Reputation points
1 answer One of the answers was accepted by the question author.

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 20 Reputation points
accepted 2024-11-19T16:39:49.1+00:00
Arik Levy 20 Reputation points
1 answer One of the answers was accepted by the question author.

Cannot create an "Azure Database for PostgreSQL"

I have been struggling for multiple days with creating a PostgreSQL DB in Azure. I am trying to create it in Germany West. The Service always seems to get stuck at "Get PostgreSQL server List" until it times out about 3h into the deployment…

Azure Database for PostgreSQL
asked 2024-11-18T09:20:27.1866667+00:00
Simeon Kostadinov 20 Reputation points
accepted 2024-11-19T08:32:03.9533333+00:00
Simeon Kostadinov 20 Reputation points
1 answer

Azure PostgreSQL Flexible server Time Zone need to change

Azure PostgreSQL Flexible server Time Zone need to change from default UTC to IST, hence need assistance to change the same.

Azure Database for PostgreSQL
asked 2024-11-19T06:17:22.63+00:00
Navnath Manere 0 Reputation points
answered 2024-11-19T06:56:23.4533333+00:00
NIKHILA NETHIKUNTA 3,505 Reputation points Microsoft Vendor
1 answer One of the answers was accepted by the question author.

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 240 Reputation points
accepted 2024-11-18T19:31:42.4033333+00:00
DataCoder 240 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-18T17:40:24.5566667+00:00
Mahesh Kurva 890 Reputation points Microsoft Vendor
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-18T16:50:15.0033333+00:00
NIKHILA NETHIKUNTA 3,505 Reputation points Microsoft Vendor
1 answer

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-18T16:49:25.1533333+00:00
NIKHILA NETHIKUNTA 3,505 Reputation points Microsoft Vendor
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,300 questions
asked 2024-11-16T20:15:26.7166667+00:00
Adrian Ruchti 20 Reputation points
accepted 2024-11-17T18:02:49.0633333+00:00
Adrian Ruchti 20 Reputation points
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,908 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,510 Reputation points Microsoft Vendor
1 answer

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
answered 2024-11-15T05:14:37.31+00:00
ShaktiSingh-MSFT 15,766 Reputation points
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,766 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,766 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 60 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