Stack Overflow
Stack Overflow

Questions tagged [azure-database-postgresql]

"Azure Database for PostgreSQL" is PostgreSQL as-a-service in MS Azure. Use this tag specifically for the azure service "Azure Database for PostgreSQL". DON'T use it for PostgreSQL hosted on a Azure virtual machine.

38 questions
0
votes
1 answer

Azure postgresql data encryption at rest

All managed dB services on azure have data encryption at rest turned on by default( as per azure docs). How to see the status on it for Azure postgresql.? Right now when I do "az postgres server show --name -g" of an existing postgresql server I can…
Aravind
  • 4,125
  • 1
  • 28
  • 39
0
votes
0 answers

Azure DB for PostgreSQL - changes to log_line_prefix parameter not implemented

I have a General Purpose Single Server instance of Azure DB for PostgreSQL where I have installed the pgAudit plugin. I am trying to add more data to the pgAudit session auditing entries by following the instructions on Microsoft's page and…
Lotusmeristem
  • 53
  • 3
  • 13
0
votes
1 answer

Azure Database for PostgreSQL fail to Point in time restore

I use Azure Database for PostgreSQL server I can't restore my server it give me the following error The resource operation completed with terminal provisioning state The user name conflict with an existing database user name is not a valid …
Ayman Elarian
  • 301
  • 2
  • 15
0
votes
1 answer

Azure Database for PostgreSQL server is displaying 100% CPU utilization

Azure Database for the PostgreSQL server is displaying 100% CPU utilization every day from 10 AM to 12 PM. The load on the server is minimal when this is happening. Did anyone face the same issue? What could be the probable cause for this to…
Manoj vardhan reddy
  • 183
  • 2
  • 8
0
votes
1 answer

Azure PostgreSQL: it is not possible to remove database through Azure CLI

I have created pipeline using Azure DevOps for Azure PostgreSQL database. What actually pipeline do? Connect to PostgreSQL; Remove database db_test from PostgreSQL using Azure CLI; az postgres db delete -g my_group -s database_here -n db_test…
DariyN
  • 466
  • 1
  • 6
  • 23
0
votes
1 answer

Autovacuum config on Azure Postgresql

I am trying to change some global settings below for auto-vacuum on an Azure Database for PostgreSQL instance. select * from pg_settings where name like 'autovacuum%' Say if I want to change the scale factor with ALTER SYSTEM SET…
chi
  • 471
  • 3
  • 18
0
votes
0 answers

Azure Database for PostgreSQL Basic Plan and Debugging

We are using Azure Database for PostgreSQL Basic Plan (vCore 2) for development environment. When we try to debug our application from Visual Studio (EF PostgreSQL), we often get "Unknown message code: 21 (also 2 and 3)" errors. Is it limitation of…
pirimoglu
  • 328
  • 4
  • 9
0
votes
1 answer

Connect Stream Analytics to Azure Postgres - Possible?

Getting error messages. Seems this is not possible ? message is : The JSON provided in the request body is invalid. Property 'server' value 'postgres-mydatabase123.postgres.database.azure.com' is not acceptable.
user2022284
  • 413
  • 1
  • 9
  • 22
1 2
3