1,427 questions with Azure Database for PostgreSQL tags

Sort by: Updated
Updated Created Answers
1 answer One of the answers was accepted by the question author.

Private Endpoint impossible to create on PostgreSQL flexible server despite preview activated

Hello, On my subscription, I activated the preview feature called "Enable Private Endpoints for PostgreSQL flexible servers". After subscription is validated, I logout/Log on. After, I create a new "Azure Database for PostgreSQL Flexible…

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.
551 questions
Azure Database for PostgreSQL
asked 2024-02-27T14:14:17.48+00:00
fbrunhes 25 Reputation points
commented 2024-02-27T19:17:50.2366667+00:00
fbrunhes 25 Reputation points
1 answer One of the answers was accepted by the question author.

How to connect with pgAdmin to Azure Database for PostgreSQL flexbile server

I've got my Django app up and running with a PostgreSQL flexible server. The Network connectivity is set to Private access (VNet Integration), which I cannot change. Now I would like to connect with pgAdmin to my database, but it seems to me that the…

Azure Database for PostgreSQL
asked 2023-10-05T13:38:39.24+00:00
Anonymous
commented 2024-02-27T03:40:46.9166667+00:00
Moussavou Boussougou Milandu Keith 20 Reputation points
4 answers

SSH Connection error - deploying a Django web app with PostgreSQL using the Azure portal

Hi, I've been doing the Tutorial: Deploy a Django web app with PostgreSQL using the Azure portal, and all is well until I get to Run Django database migrations. When I try to connect to the SSH, it errors with "ssh://root@172.16.3.3:2222 SSH…

Azure Database for PostgreSQL
Azure App Service
Azure App Service
Azure App Service is a service used to create and deploy scalable, mission-critical web apps.
8,933 questions
asked 2020-09-23T08:40:10.833+00:00
Dennis Chan 6 Reputation points
commented 2024-02-24T00:34:40.5266667+00:00
NodeX iHub 0 Reputation points
1 answer One of the answers was accepted by the question author.

HTTP response was nil; connection may have been reset

Error: creating Flexible Server (Subscription: "00000000" │ Resource Group Name: "XYG-rg" │ Flexible Server Name: "XYZ-pqsql-flex-db"): performing Create: Put…

Azure Database for PostgreSQL
asked 2024-02-21T20:49:52.3766667+00:00
Kukkala, Venugopal 41 Reputation points
commented 2024-02-22T20:23:51.92+00:00
Oury Ba-MSFT 20,911 Reputation points Microsoft Employee Moderator
1 answer One of the answers was accepted by the question author.

PG_BUFFERCACHE extension not available in PostgreSQL Flexible Server 16

Hello, I am trying to migrate Azure PostgreSQL 11 Single Server to Azure PosgreSQL 16 Flexible Server using the Single to Flex migration tool. However I face an issue during the migration: the tool is telling me that it can't create the pg_buffercache…

Azure Database for PostgreSQL
asked 2023-11-20T10:59:53.4133333+00:00
Alexandre 40 Reputation points
commented 2024-02-22T18:22:51.8966667+00:00
Peter Ciavarella 0 Reputation points
1 answer One of the answers was accepted by the question author.

Failed connections in Azure PostgreSQL

Hello Team, We have a azure database for postgresql flexible server. On the metrics screen, we can see that there are a couple of failed connections (PFB the screenshot). But, there is no error message mentioned. How to find out what is the error…

Azure Monitor
Azure Monitor
An Azure service that is used to collect, analyze, and act on telemetry data from Azure and on-premises environments.
3,645 questions
Azure Database for PostgreSQL
asked 2024-02-22T12:02:02.0333333+00:00
Nagesh CL 696 Reputation points
edited a comment 2024-02-22T16:00:50.0066667+00:00
Nagesh CL 696 Reputation points
1 answer

Permission denied for schema cron

Hi there! I am trying to configure the pg_cron extension on our postgresql 16 flexible server, however, I've been stuck for a while now trying to figure out how I am suppose to do anything with the cron schema. I've added pg_cron to the azure.extensions…

Azure Database for PostgreSQL
asked 2024-02-21T14:56:18.5766667+00:00
Patricia Ramos 0 Reputation points
edited the question 2024-02-21T18:41:51.9+00:00
Patricia Ramos 0 Reputation points
1 answer

Azure flexible server for Postgresql support for GP_Standard_D4s_v3 & GP_Standard_D2s_v3 in East US region

Hi, We wanted to create Azure Flexible server for postgresql in East US and East US 2 regions. But we could not find "GP_Standard_D4s_v3 & GP_Standard_D2s_v3" options in East US region. But below link mentions that East US and East US2…

Azure Database for PostgreSQL
asked 2024-02-17T13:30:02.4233333+00:00
Aramvalartha Subramanian 0 Reputation points
commented 2024-02-21T12:59:59.14+00:00
TP 124.7K Reputation points Volunteer Moderator
1 answer

Azure Manage Database

I am using an Azure-managed PostgreSQL database, the database is not able to handle multiple concurrent connections (more than 30 connections). I tried increasing the parameters (max concurrent request = 500), but still getting the error

Azure Database for PostgreSQL
asked 2024-02-18T05:30:43.0833333+00:00
ishang baniya 5 Reputation points
commented 2024-02-21T04:47:09.4366667+00:00
SSingh-MSFT 16,371 Reputation points Moderator
2 answers

Django, Azure Web Service | What is the best way to backup and restore my data stored in Postgres Flexi Server

I have recently deployed my django applciation in azure app services together with a postgres flexi database server. I would like to know what is the best way to back up and restore my database, is there any best method or best practice that I can adopt,…

Azure Database for PostgreSQL
Azure App Service
Azure App Service
Azure App Service is a service used to create and deploy scalable, mission-critical web apps.
8,933 questions
asked 2024-02-19T01:09:33.76+00:00
Md Shervin 5 Reputation points
commented 2024-02-20T08:13:33.2766667+00:00
SSingh-MSFT 16,371 Reputation points Moderator
1 answer

How to configure firewall rule for access from Databricks to Postgres flexible server

We are migrating our databases from Postgres single server to Postgres flexible server ahead of end of support for single servers. We are using Public Access as opposed to Private access in Networking tab of flexible server. This is because we want to…

Azure Databricks
Azure Databricks
An Apache Spark-based analytics platform optimized for Azure.
2,514 questions
Azure Database for PostgreSQL
asked 2024-02-05T23:03:01.0033333+00:00
Swavek Lorenc 0 Reputation points
commented 2024-02-20T05:18:44.97+00:00
ShaikMaheer-MSFT 38,546 Reputation points Microsoft Employee Moderator
3 answers One of the answers was accepted by the question author.

TimescaleDB on Azure PostgreSQL v16

Is it possible to run TimescaleDB on Azure PostgreSQL v16? I just tried and the options in shared_preload_libraries and azure.extensions are not there. Downgrading to v15 works. I assume it due to TimescaleDB only fairly recently supporting it (v2.13.0…

Azure Database for PostgreSQL
asked 2024-02-16T15:23:42.6633333+00:00
Daniel Siviter 20 Reputation points
answered 2024-02-16T20:32:32.2633333+00:00
Oury Ba-MSFT 20,911 Reputation points Microsoft Employee Moderator
1 answer

AzurePostgresqlでオートスケーリングを行うことができるか

AzurePostgresqlでCPU使用率の上昇に応じてCore数を自動拡張するような機能が利用できるか確認したいです ※ドキュメントではストレージの自動拡張ができることは明記されていますが、Core数に関して記載がなかったため、確認させていただきました。

Azure Database for PostgreSQL
asked 2024-02-15T06:00:38.62+00:00
日高　満実子 0 Reputation points
answered 2024-02-16T12:37:48.5433333+00:00
Amira Bedhiafi 33,071 Reputation points Volunteer Moderator
1 answer One of the answers was accepted by the question author.

How to resolve data mapping between parquet file and Azure Database for PostgreSQL ?

I'm trying to copy data into a PostgreSQL database from a parquet file in an Azure Data Lake. The problem is that some of the numeric columns in the parquet file don't have exactly the same type of numeric data in the PG database. longitude, latitude…

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
11,624 questions
Azure Database for PostgreSQL
asked 2024-02-14T13:56:15.8566667+00:00
sliemsoonuef 20 Reputation points
accepted 2024-02-15T13:52:01.1333333+00:00
sliemsoonuef 20 Reputation points
1 answer

Data Factory to Azure Search Index Mapping Issue - StringCollection Fields Not Visible

I am encountering an issue while setting up a pipeline in Azure Data Factory to transfer data from a managed PostgreSQL database to Azure AI Search service. In Azure Data Factory, during the mapping configuration step, fields that are defined as…

Azure AI Search
Azure AI Search
An Azure search service with built-in artificial intelligence capabilities that enrich information to help identify and explore relevant content at scale.
1,339 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
11,624 questions
Azure Database for PostgreSQL
asked 2024-02-12T00:57:04.87+00:00
RobPi-8032 0 Reputation points
answered 2024-02-15T03:03:45.77+00:00
brtrach-MSFT 17,731 Reputation points Microsoft Employee Moderator
2 answers One of the answers was accepted by the question author.

Unable to access PostgreSQL database after restore - 'database does not exist' error

The other day I had issues with my database and decided to do a fast restore. Unless I didn't understand something, I had to create a new database resource for that,. In the new resource, if I go in the "Database" menu, I can see my 2…

Azure Database for PostgreSQL
asked 2024-02-12T22:00:07.63+00:00
Robouste 20 Reputation points
commented 2024-02-13T18:52:42.15+00:00
Oury Ba-MSFT 20,911 Reputation points Microsoft Employee Moderator
1 answer

We have a PostegrSQL Flexible Server which is stuck in Update State for about 2 hours now. I tried restarting and stopping it via az cli and it didn't work.

We have a PostegrSQL Flexible Server which is stuck in Update State for about 2 hours now. I tried restarting and stopping it via az cli and it didn't work. I changed the max connection time and restarted it

Azure Database for PostgreSQL
asked 2024-02-06T07:12:08.0166667+00:00
ishang baniya 5 Reputation points
commented 2024-02-12T04:20:56.9033333+00:00
SSingh-MSFT 16,371 Reputation points Moderator
3 answers

Upgrading Azure Database for PostgreSQL flexible server to version 16

When trying to upgrade a PostgreSQL server from 15 to 16 I'm getting the following error: You are already running the latest major PostgreSQL version available. It is possible to create a new Azure Database for PostgreSQL flexible server with version 16.

Azure Database for PostgreSQL
asked 2024-01-04T09:53:45.2533333+00:00
Anonymous
commented 2024-02-07T14:23:58.9333333+00:00
Marius Løkken 5 Reputation points
2 answers

ERROR: postgresql Connection terminated due to connection timeout

Getting an error as ERROR: postgresql Connection terminated due to connection timeout pool = new Pool({ max: 300, connectionTimeoutMillis: 5000, host: 'c-abxxxfg.22ps25nxx7gjw5.postgres.cosmos.azure.com', …

Azure SQL Database
Azure Database for MySQL
Azure Database for MySQL
An Azure managed MySQL database service for app development and deployment.
986 questions
Azure Cosmos DB
Azure Cosmos DB
An Azure NoSQL database service for app development.
1,902 questions
Azure Database for PostgreSQL
asked 2024-02-06T09:44:47.8433333+00:00
Akash Panda 0 Reputation points
answered 2024-02-07T10:36:49.04+00:00
SSingh-MSFT 16,371 Reputation points Moderator
1 answer

Azure Database for PostgreSQL Flexible Server

Hello Team, My query is more concerned with Azure Database for PostgreSQL Flexible Server. Recently I had raised a ticket requesting to get the Region access with zonal dependency (Availability Zones) for my subscription. Support quickly got the…

Azure Database for PostgreSQL
asked 2024-02-02T14:02:46.03+00:00
Learn Cloud 80 Reputation points
commented 2024-02-06T21:10:33.6333333+00:00
Oury Ba-MSFT 20,911 Reputation points Microsoft Employee Moderator