Stack Overflow
Stack Overflow

Questions tagged [azure-postgresql]

Azure PostgreSQL is a relational database service for app development and deployment based on the open source Postgres database engine.

Links:

  1. Azure Database for PostgreSQL - Official site
  2. Azure Database for PostgreSQL - Documentation
171 questions
1
vote
0 answers

"Failed to connect to database" --> Unable to connect to Azure PostgreSQL DB from Keycloak(AKS)

While deploying keycloak in Azure Kubernetes Service using Codecentric Helm Chart, it is unable to connect to Azure PostgreSQL Database. After pulling the repository in my local machine, made below mentioned changes in the statefulset.yaml file:…
devgreyops
  • 11
  • 3
1
vote
1 answer

Connect to Azure PostgreSQL using Azure Data Studio with SSL enabled

When i try to connect to Azure PostgreSQL with SSL enabled using Azure Data Studio , with SSL Mode=Verfiy-full, i get below error root certificate file "C:\Users\mstechie\AppData\Roaming/postgresql/root.crt" does not exist Either provide the file or…
MSTechnie
  • 175
  • 10
1
vote
1 answer

Azure Postgres and Data Factory - Firewall Rules

I have an Azure Postgres database, and am looking to query it in an Azure Data Factory pipeline. When I go to add the database as a linked service, I see it fails as the IP address is not whitelisted. Looking at…
ashic
  • 6,367
  • 5
  • 33
  • 54
1
vote
2 answers

Azure DevOps for Azure PostgreSQL

I did some research and found that Azure DevOps does have any outofthebox implementations to support CI CD for Azure PostgreSQL. Does anyone , have any idea , How can we configure Azure DevOps for PaaS offering of Azure PostgreSQL Database Please…
MSTechnie
  • 175
  • 10
1
vote
1 answer

Does Azure PostgreSQL support custom certificate for Authentication instead of username & password?

I am looking for certificate based authentication for Azure PostgreSQL , where we dont have to specify any password credentials. https://learn.microsoft.com/en-us/azure/postgresql/concepts-ssl-connection-security What i understand from the above URL…
MSTechnie
  • 175
  • 10
1
vote
1 answer

what can be done for connection re use?

I am using azure postgres sql where I have one of the common method which gives me connection string, protected readonly string databaseConnString = "Host={0}.postgres.database.azure.com;Username={1}@{2};Password={3};DB={4};Ssl Mode=Require"; …
user584018
  • 10,186
  • 15
  • 74
  • 160
1
vote
0 answers

DevOps with Azure PostgreSQL

I know that this is general question which is not really the normal type of question but I have been looking around and I cannot find and detail on how to set this up. What I would like to do is figure out have the schema of my Postgres database…
Paul Cavacas
  • 4,194
  • 5
  • 31
  • 60
1
vote
0 answers

Airflow with PostgreSQL bottleneck issues

I have set up Airflow 1.10.10 with Celery as Executor, Postgres as result backend and sql alchemy connection, and Redis as broker/message queue. I'm using one pod for each Airflow component (scheduler, webserver, broker and 1 worker) with 2 GiB of…
Agustin
  • 51
  • 1
1
vote
1 answer

issue to setup alert onAazure Postgresql using Terraform

I have created postgresql with custome alert for cpu percentage using Terraform azure and its showing error metric name is not found Please check the following code. provider "azurerm" { features {} subscription_id = "***************"//add…
terraform-ninja
  • 33
  • 2
  • 7
1
vote
0 answers

Azure Database for PostgreSQL server - Permission denied to create a table space

Context In our application we have multiple tablespace, basically for allocating different sizes. We are evaluating to deploy our application in Azure Database for PostgreSQL server. Problem While trying to create a table space we got the error…
arunvg
  • 1,209
  • 1
  • 20
  • 31
1
vote
1 answer

How to Edit postgresql.conf on Azure PostgreSQL?

I need to change log_hostname to off, in an attempt to fix a performance issue as recommended here. How do I access the postgresql.conf file for an Azure PostgreSQL instance? log_hostname is NOT one of the parameters made available under Server…
VSO
  • 11,546
  • 25
  • 99
  • 187
1
vote
1 answer

Import CSV to Azure PostgreSQL withough Superuser

I'm trying to upload a CSV file into Azure Postgresql. However when I run the command, I get the following error: ERROR: must be superuser to COPY to or from a file However, Azure Postgresql doesn't allow users to be super users. How can I import…
Brig
  • 10,211
  • 12
  • 47
  • 71
1
vote
1 answer

pg_database_size is very slow for Azure PostgreSQL

I have very starnge behavior on Azure PostgreSQL server. I try to read DB size using the next query: SELECT CAST(pg_database_size(current_database()) * 1.0/(1024 * 1024) AS DECIMAL(12, 5)) But this query runs very long and I have timeout exception…
Alexander I.
  • 2,380
  • 3
  • 17
  • 42
1
vote
1 answer

Azure PostgreSQL suddenly uses all storage

Yesterday, an 'Azure Database for PostgreSQL server' database I have been appending to continually suddenly increased its rate of growth and used up all the storage, and the script reported errors as the connection became read-only. The queries for…
Pete Kirkham
  • 48,893
  • 5
  • 92
  • 171
1
vote
2 answers

Error Connecting Azure Database from Thingworx

I am trying to connect my thingworx to azure postgres database. I have two azure accounts. When I am creating my postgresql database in one of the accounts and connecting then it is working fine. But when I am trying to connect to the azure postgres…
Tarun
  • 271
  • 1
  • 6
  • 18
1 2 3
…
11 12