1,962 questions with Azure Database for PostgreSQL tags

Sort by: Updated
Updated Created Answers
1 answer

Not able to "CREATE EXTENSION pg_stat_statements" in Azure Database for PostgreSQL flexible server

Not able to "CREATE EXTENSION pg_stat_statements" in Azure Database for PostgreSQL flexible server, please suggest how can we enable it we are getting following error dummy_database=> CREATE EXTENSION pg_stat_statements; ERROR: …

Azure Database for PostgreSQL
asked 2022-09-22T09:17:44.647+00:00
Manish Kumar Singh 1 Reputation point
commented 2023-03-01T19:44:33.44+00:00
Travis 0 Reputation points
1 answer One of the answers was accepted by the question author.

How to fix Azure PostgreSQL deployment error: "... Graph API client application ... is not found ... required permissions"?

After using the Azure portal to set up a PostgreSQL flexible server it failed during deployment, first showing status "Accepted" and then within a minute of working on deploying switching to status "Conflict" and returning this…

Azure Database for PostgreSQL
Microsoft Security | Microsoft Graph
asked 2023-02-01T23:54:26.1733333+00:00
christian-365 35 Reputation points
edited the question 2023-03-01T02:10:24.54+00:00
Zehui Yao_MSFT 5,881 Reputation points
1 answer

Diagnostic Log - Slow Queries Only on Azure PostgreSQL Flexible Server

Hi We want to log all slow queries on Azure PostgreSQL Flexible Server. We enabled Diagnostic Logs on the PostgreSQL Server and set the log_min_duration_statement to 1000. Now, if we query Diagnostic Logs like this, we get a lot of other queries…

Azure Database for PostgreSQL
asked 2023-02-09T10:04:57.4933333+00:00
ab-oe 6 Reputation points
commented 2023-02-28T08:57:05.4633333+00:00
SSingh-MSFT 16,461 Reputation points Moderator
1 answer

tried to remove replica from flexible postgres server, now updating for 2 hours and counting

After removing replica from instance the instance is stuck in updating state.

Azure Database for PostgreSQL
asked 2023-02-21T21:33:52.9+00:00
Greg Toews 20 Reputation points
edited a comment 2023-02-27T16:23:58.6466667+00:00
GeethaThatipatri-MSFT 29,597 Reputation points Microsoft Employee Moderator
1 answer

Azure Database for Postgres cannot be created in region although it should be possible

Hello Azure community, I want to create a resource "Azure Database for Postgres" as a flexible server. This should be supported in my region Germany West Central, see here…

Azure Database for PostgreSQL
asked 2023-02-19T14:06:31.8+00:00
Alexander Hofbeck 10 Reputation points
commented 2023-02-26T05:14:25.3766667+00:00
SSingh-MSFT 16,461 Reputation points Moderator
1 answer One of the answers was accepted by the question author.

query to fetch old sessions caused high cpu and memory

Unable to find the details what was happened a some time ago which caused high cpu and high memory from pgstatstaments view. Can you provide the direct query to get those details instead of referring articles, please. Regards, Bhanu

Azure Database for PostgreSQL
asked 2023-02-23T13:39:51.9533333+00:00
Molagara, Bhanu P 20 Reputation points
accepted 2023-02-24T10:57:36.0633333+00:00
Molagara, Bhanu P 20 Reputation points
1 answer

How to get approved server name for azure database postgresql single server

Hello... Am trying to create a single server from the azure database for postgresql in portal but can't enter any valid server name all the names i try inputing are rejected don't understand no matter what i type it's not valid any hint please??

Azure Database for PostgreSQL
asked 2023-02-16T14:46:24.9+00:00
cabrel tchoffo 0 Reputation points
commented 2023-02-23T13:57:06.53+00:00
GeethaThatipatri-MSFT 29,597 Reputation points Microsoft Employee Moderator
2 answers

Postgresql exporter pod for prometheus unable to connect to postgres

I have deployed postgres exporter to collect metrics from azure postgresql flexible server database. Both aks and postgres is in same vnet still I am getting below error in exporter pod log: ts=2023-01-31T09:27:26.841Z caller=collector.go:196 level=error…

Azure Database for PostgreSQL
asked 2023-01-31T09:31:43.84+00:00
Nitin Naidu (Consultant) 51 Reputation points
commented 2023-02-21T17:08:27.2333333+00:00
GeethaThatipatri-MSFT 29,597 Reputation points Microsoft Employee Moderator
1 answer

How to access PotgreSQL database with VPN

Hello! I want to be able to access my DB from any (and only) computer connected with a VPN (that means followed this Microsoft tutorial). I've created an "Azure DB for PostgreSQL", followed the instructions, the connection with the VPN was…

Azure Database for PostgreSQL
asked 2023-02-16T21:16:05.2666667+00:00
Rafael Gonçalves 0 Reputation points
commented 2023-02-20T21:11:49.35+00:00
GeethaThatipatri-MSFT 29,597 Reputation points Microsoft Employee Moderator
1 answer

Supporting TimescaleDB Toolkit extension on Azure Database for PostgreSQL flexible server

TimescaleDB is supported as an extension, but the affiliated extension "TimescaleDB Toolkit" is not supported/listed. Why is it not supported, and are there any plans to add support for this extension to Azure Database for PostgreSQL flexible…

Azure Database for PostgreSQL
asked 2023-02-14T10:09:18.7366667+00:00
M.L 0 Reputation points
commented 2023-02-20T06:30:08.61+00:00
SSingh-MSFT 16,461 Reputation points Moderator
1 answer

How to configure the app insight in postgressql server in azure as well as with sql db server in azure ?

HI, I just wanted to know how to configure the app insight in postgressql server in azure as well as with sql db server in azure ? Does MS supports app insight for both DB server's ? I am not find any details in web pages .

Azure SQL Database
Azure Database for PostgreSQL
asked 2023-02-10T08:46:16.2766667+00:00
Anonymous
commented 2023-02-17T22:02:14.4666667+00:00
Oury Ba-MSFT 21,156 Reputation points Microsoft Employee Moderator
0 answers

PostgreSQL Flex DB server went to updating mode when Replication is enabled from EAST US to WEST US

I used Azure Portal to create Replication and followed all the recommended settings. But PostgreSQL Flex DB server went to updating mode when Replication is enabled from EAST US to WEST US. It's been in updating mode for more than 12 Hours. The DB size…

Azure Database for PostgreSQL
asked 2023-02-03T16:02:11.34+00:00
Kukkala, Venugopal 41 Reputation points
commented 2023-02-17T00:02:01.65+00:00
Oury Ba-MSFT 21,156 Reputation points Microsoft Employee Moderator
1 answer

How to collect the azure managed PG single server metrics with Prometheus

How to monitor azure managed PG metrics, with Prometheus. Azure managed PG is running on a Linux VM. Could you please share steps to install Prometheus exporter agent on a Linux VM. Thank you!

Azure Database for PostgreSQL
asked 2023-01-30T19:22:40.4766667+00:00
Bhasker Kasireddy 0 Reputation points
commented 2023-02-16T15:23:47.45+00:00
GeethaThatipatri-MSFT 29,597 Reputation points Microsoft Employee Moderator
1 answer One of the answers was accepted by the question author.

How to fix error when changing to PostgresSQL and Azure Active Directory authentication on existing flexible server

Error when enabling, PostgreSQL and Azure Active Directory authentication, on an existing flexible postgres sql server. I would like to know how to interpret the error and fix it. It appears to be an issue with connecting AAD or permissions. Originally…

Azure Database for PostgreSQL
asked 2023-02-01T18:13:42.42+00:00
Kelli Hale 20 Reputation points
accepted 2023-02-16T14:43:31.8466667+00:00
Kelli Hale 20 Reputation points
3 answers One of the answers was accepted by the question author.

Azure PostgreSQL Single Server underlying OS

Can anyone tell me what the underlying operating system is when you use the Azure PostgreSQL single server option? Thanks Steve

Azure Database for PostgreSQL
asked 2022-01-21T18:10:03.017+00:00
Steve Hawes 21 Reputation points
edited the question 2023-02-15T14:27:36.4266667+00:00
GeethaThatipatri-MSFT 29,597 Reputation points Microsoft Employee Moderator
2 answers

I am getting a "Disk size cannot be decreased (current: 2097152, requested: 524288)." Error message when trying to enable High availability on my Azure CosmosDb for PostgreSql Cluster

Hi Everyone, Relatively new user to Azure CosmosDb for postgreSql(*Formerly Citus), So apologies in Advance if this question is an obvious misconfiguration on my part that I missed. So I am trying to enable High Availability in my Azure cosmosDb for…

Azure Database for PostgreSQL
asked 2023-01-27T02:36:02.3933333+00:00
Alex Amante 10 Reputation points
commented 2023-02-15T06:38:22.3466667+00:00
SSingh-MSFT 16,461 Reputation points Moderator
1 answer One of the answers was accepted by the question author.

InternalServerError when scaling Postgresql Flexible Server

Hello, I keep receiving InternalServerError when scaling down a Postgresql Flexible Server instance (cross tier). The error message isn't very helpful: An unexpected error occured while processing the request. Tracking ID:…

Azure Database for PostgreSQL
asked 2023-02-01T21:22:51.32+00:00
Michael Le 20 Reputation points
commented 2023-02-14T22:53:15.9833333+00:00
Michael Le 20 Reputation points
1 answer

PostgreSQL Flexible Server - Geo-backups are not available yet

I have created a Azure Database for in East US I have enabled high availability with zone redundancy and also enabled geo redundant backup during server creation itself. I am trying to restore my server to a paired region using geo redundant backup for a…

Azure Database for PostgreSQL
asked 2023-01-25T07:14:34.3466667+00:00
Sreekar Sastry 0 Reputation points
commented 2023-02-14T21:45:16.47+00:00
GeethaThatipatri-MSFT 29,597 Reputation points Microsoft Employee Moderator
1 answer

Performance Insights for Azure Postgre Flexi server

We used to have performance Insights etc or Azure Postgree single servers in Azure portal. But we do not have it for Azure Postgre Flexi Server. Any road map to get the same from MSFT for flexi servers?

Azure Database for PostgreSQL
asked 2023-02-09T12:49:01.9733333+00:00
Molagara, Bhanu P 0 Reputation points
commented 2023-02-14T21:43:15.7333333+00:00
GeethaThatipatri-MSFT 29,597 Reputation points Microsoft Employee Moderator
0 answers

Unable to use postgres exporter with azure flexible database

I get below error in place of metrics when I deploy the helm chart for postgres exporter: An error has occurred while serving metrics: 7 error(s) occurred: * collected metric "pg_database_size_bytes" { label:<name:"datname"…

Azure Database for PostgreSQL
asked 2023-01-31T18:31:32.7+00:00
Nitin Naidu (Consultant) 51 Reputation points
commented 2023-02-13T20:42:40.65+00:00
GeethaThatipatri-MSFT 29,597 Reputation points Microsoft Employee Moderator