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…
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…
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:
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…
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…
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?
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…
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…
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…
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…
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…
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.
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…