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
0
votes
0 answers

How do you restore postgre dump to alternative DB name?

I generated successfully pg dump with directory format and when I restore it restores to DB with the same name as dump was created for despite the fact of me specifying to use alternative name. Here is my pg_dump command & pg_dump -Fd -v -j 2 -Z0…
Gregory Suvalian
  • 3,566
  • 7
  • 37
  • 66
0
votes
0 answers

Azure PostgreSQL flexible server vCore Vs On-prem socket, core, threads

We are in the process of migrating database to Azure PostgreSQL flexible server from RHEL on-prem. In on-prem RHEL, we have below set up - Sockets - 2 Cores per socket - 8 Threads per core - 2 Based on this on-prem set up, how many vCores should be…
Jacob
  • 426
  • 3
  • 19
0
votes
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:
Daemon
  • 49
  • 1
  • 6
0
votes
1 answer

Steps to connect using service principal to Azure PostgreSQL single server

How to connect securely from AKS cluster to Azure PostgreSQL Single Server using Service principal as the Managed Identity is not supported.
0
votes
0 answers

Memory continuously increases at a constant rate in Azure Database for PostgreSQL single server

Our memory usage increases at a constant rate.This is observed in Azure Metrics. Two questions here: Is there a way to know which process is generating the higher and higher memory consumption? Any insights on what could cause the memory…
0
votes
1 answer

we are not able to replicate 5GB table in postgresql using logical replication

we have multiple tables and all are replicated successfully except one table which is in size of 5GB. Once we created replication slot, the size of the server is growing high but can't see the data. we are using Postgres 12 and Logical…
0
votes
0 answers

Retrieve the private IP address of an Azure Database for PostgreSQL Flexible Server using Bicep/ARM

I want to retrieve the private IP address of an Azure Database for PostgreSQL Flexible Server during deployment with Bicep/ARM. Is there a property on the Flexible Server object, a child resource, or the private DNS zone that might have that IP?
SvenAelterman
  • 1,532
  • 1
  • 15
  • 26
0
votes
1 answer

Postgres Audit - How to get information on who is performing the DDL operation?

I'm trying to enable pgaudit in an Azure Postgres Single Server. I have followed the instructions provided by Microsoft and also the documentation of Postgres. These are my settings ( the 2 Selected in the picture below are DDL and ROLE ) Log…
Roberto Hernandez
  • 8,231
  • 3
  • 14
  • 43
0
votes
0 answers

how can terraform or bash etc. automate Backups from Azure Database for PostgreSQL Server to az fileshares"backup_psql" within Azure Storage account

I want to automate the backup my azure Postgresql flex databases to azure fileshares named as ex:"backup_psql" within Azure Storage account?. The backup should take place at certain interval. The expected architecture is given bellow. The storage…
eku
  • 11
  • 1
  • 2
  • 6
0
votes
1 answer

How can I enable notifications for upcoming scheduled maintenance events using terraform for azure postgresql flexible server using terraform

I have deployed a postgreesql server using terraform. I have configured schedule maintenance. maintenance_window { day_of_week = 0 // Sunday start_hour = 21 start_minute = 0 } Now i want to enable notifications through mail address…
eku
  • 11
  • 1
  • 2
  • 6
0
votes
0 answers

Rails Test: Rails was not able to disable referential integrity. Rails needs superuser privileges to disable referential integrity on Azure Postgres

I am getting the following error when running rails tests on WARNING: Rails was not able to disable referential integrity. This is most likely caused due to missing permissions. Rails needs superuser privileges to disable referential…
ASing
  • 45
  • 5
0
votes
1 answer

is it possible to create Azure Database for PostgreSQL Flexible server - Restore server-> (Back up and restore) using terraform?

The azure Database for PostgreSQL Flexible server automatically back up the databases. In case of any accidental deletion of any databases we can restore the database by creating a new flexible server for the recovery process from the back up…
0
votes
1 answer

On-Demand Backup/Restore for Azure PostgreSQL Flexible Servers

Hi StackOverflow Community, Can you please tell me if Azure PostgreSQL flexible servers support on-demand backup ? As I understand on-demand backup is supported just for Azure PostgreSQL single server. Thanks a lot in advance for your answers.
0
votes
1 answer

Azure PostgreSQL instances data abnormally incresing

I am having an instance of Azure PostgreSQL. I am using this instance for development purpose. And only I use this instance for now. But, this instance is increasing its size automatically even without access or no activity. This month I did not…
ndm
  • 23
  • 4
0
votes
1 answer

Failed to connect Azure postgres using JDBC Connection String - Spring Boot

Spring Boot application-uat.yml spring: datasource: username: "${DATABASE_USER}" password: "${DATABASE_PASS}" platform: postgres initialization-mode: always application.yml spring.profiles.active: uat spring: …
Niraj
  • 517
  • 1
  • 5
  • 14