Azure PostgreSQL is a relational database service for app development and deployment based on the open source Postgres database engine.
Links:
Questions tagged [azure-postgresql]
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.
Anjali Loganathan
- 166
- 9
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…
Ziyue Li
- 34
- 2
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…
eku
- 11
- 1
- 2
- 6
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.
Prakash Premkumar
- 99
- 1
- 6
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