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

Handle Django application if DB is taking time to respond

We recently our migrated our application from VM and in-memory Database to AKS and Azure Postgres flexible server. After the migrations, we feel DB is not stable and when monitoring the CPU utilisation it was going 90% sometimes and Django…
Sakthi Panneerselvam
  • 1,337
  • 1
  • 14
  • 25
1
vote
1 answer

Azure PostgreSQL - How to create admin user

We use Azure Database for PostgreSQL flexible servers. My requirement is creating admin user that should be able to anything (DDL/Alter etc.) with any table in any schema throughout the database, irrespective of which user has created that table,…
Tomer Stein
  • 11
  • 2
1
vote
0 answers

Azure Postgres Flexible Server VNET Integration

we run several Azure Postgres Single Servers with VNET integration through Private Endpoint Connections. The Private DNS Zone used is privatelink.postgres.database.azure.com. Now we want to setup an new Azure Postgres Flexible Server with VNET…
stef
  • 271
  • 3
  • 10
1
vote
0 answers

Sqlalchemy 1.14 + Fastapi (asyncpg), set connection expiry

Using Sqlalchemy 1.14 + Fastapi (asyncpg), in project Trying to connect to azure poetgre db via azure identity access token. But the access token expires every 90 minutes or so(and that's the limit of access token). So afterwards, the connection…
Adb101Cosmo
  • 11
  • 1
1
vote
0 answers

How to use pg_repack extension on Azure PostgreSQL

How to use pg_repack extension on Azure PostgreSQL? Here is the link of with the PostgreSQL extension and while there is documentation for some of them, the documentation for pg_repack is missing. It is pointing to official documentation here but I…
Christian
  • 420
  • 1
  • 8
  • 15
1
vote
1 answer

Unable to get the list of queries in azure postgresql?

Pg_stats_actvity is used in pgadmin 4 but it give only current queries. And also checked on azure portal for logs in server logs there can't see the logs for queries. If anyone know help on this it is azure postgresql server. Need Queries for one…
surendra kumar
  • 11
  • 2
1
vote
1 answer

node-postgres self signed certificate in certificate chain

I have an Azure Postgres instance, and I am trying to connect to it using node-postgres (pg) module but getting Self signed certificate in certificate chain error. I am able to connect using psql with sslmode=require param Below is my code…
Yash
  • 65
  • 6
1
vote
1 answer

Big Latency using Azure Database for PostgreSQL flexible server

I have a PostgreSQL database deployed on Azure using Azure Database for PostgreSQL flexible server. I have the same database created locally and queries that takes 70ms locally, takes 800ms on the database deployed on Azure. The latency happens if I…
Roesmi
  • 466
  • 5
  • 15
1
vote
0 answers

Trouble with the listing/ updating server parameters for azure postgres flexible server

The issue is observed on Azure Portal, CLI along with IaC Terraform provisioning.
Usman Khawar
  • 21
  • 4
1
vote
1 answer

Azure Postgres Flexible Server - Vnet integration DNS not resolving

I provisioned the resources accordingly to the documentation. https://learn.microsoft.com/en-us/azure/postgresql/flexible-server/concepts-networking I did the provisioning using BICEP. The name of the server is my-dev-db and I created a DNS private…
raduone
  • 191
  • 1
  • 10
1
vote
1 answer

Is there a way to set "Allow access to Azure services" in Microsoft.DBforPostgreSQL/servers using Bicep?

I've been working with Microsoft.DBforPostgreSQL/servers resource and Azure Bicep specifically using this reference. I am missing parameter to set my database accessable from Azure resouces (see the picture attached). I thought publicNetworkAccess:…
evgeny
  • 1,039
  • 1
  • 9
  • 26
1
vote
0 answers

Server logs for Postgres Flex server?

we migrated to the postgres flex server recently. We've got the problem that some of us could not connect to the DB, altough we set the correct ip for them within our firewall rules. So for further investigating we want to look into the server logs…
TjayGs
  • 11
  • 1
1
vote
0 answers

Create Azure Database for PostgreSQL with Initialization Script for schema, tables, roles, etc in Terraform

I have created the Azure Postgre SQL server and DB using terraform. Now I need to deploy the table and fields(schema). Can this be done through terraform or we need different set of tools? eg: Azure CLI to deploy the tables? I am looking for similar…
Blue Clouds
  • 7,295
  • 4
  • 71
  • 112
1
vote
0 answers

AzurePolicy for activating DiagnosticSetting on Azure Postgesql flexible server

I'm writing an Azure policy for activating logs and diagnostic setting for postgresql Flexible server. However it doesn't get applied and I see this message: Reason for non-compliance No related resources match the effect details in the policy…
Matrix
  • 2,399
  • 5
  • 28
  • 53
1
vote
1 answer

Getting connection timeout error while connecting Azure Postgres DB in Python

I am trying to connect Azure Postgres DB from Python using psycopg2 library but getting below error. Could someone help on this. Error: psycopg2.OperationalError: connection to server at "xxx.postgres.database.azure.com" (xx.xx.xxx.xxx), port 5432…
Rahul Jha
  • 874
  • 1
  • 11
  • 28
1 2
3
…
11 12