Stack Overflow
Stack Overflow

Questions tagged [barman]

Barman is an open-source administration tool for disaster recovery of PostgreSQL servers written in Python.

43 questions
0
votes
0 answers

Barman SQL statement messurment

I'am look for SQL statments to messure a barman instance. Statements like is the replication still working like barman check db-server and grab informations out of it. Informations from wal-logs if they are still up to date would be really helpful…
schnake
  • 1
  • 2
0
votes
0 answers

Can pgbarman be used with an SSHFS mounted filesystem?

TLDR: Can pgbarman be used with SSHFS? In the barman configuration file I can change the directory where backups are stored to being a mounted directory, e.g. mounted with NFS: barman_home = /mnt/barman-data/ In the documentation it (only) states…
rasmush
  • 61
  • 1
  • 7
0
votes
1 answer

Barman Recovery taking long time

I have Postgres cluster with Barman setup With Barman backup 1.4TB I am Recovering to another server. I have DB size is 1.5TB and WAL files size 18 GB. Using below command for recovery to another server barman recover --remote-ssh-command "ssh…
jack
  • 3
  • 2
0
votes
1 answer

Why is Barman not compressing WAL files

Our Barman install doesn't seem to be compressing the WAL files. The wal file sizes are the same as they are on the Postgresql server. We've got streaming_archiver turned on, and in barman show-server compression is set to pigz, but wal_compression…
ScottN
  • 5
  • 2
0
votes
0 answers

Problem with barman to backup instance with archive_mode = off

I am using postgres v14.4. I would use barman to make a backup of this instance. Log archives are not needed and hence archive_mode = off. The problem is that barman refuses to make a backup with the archive mode disabled. Is there a way to do a…
Fabrice Chapuis
  • 448
  • 1
  • 5
  • 19
0
votes
1 answer

Barman full Backup is not getting triggered

Barman full Backup is not getting triggered. Installed Barman 2.3-2 in Ubantu 18.04 . Barman is taking incremental backup perfectly but it is not taking full backup. Barman backup command show below output , Backup start at LSN: This is the first…
Ramapandian Jayaraman
  • 1
  • 1
0
votes
0 answers

Cannot import name from Enum

I am simple running below python script and got the error - Traceback (most recent call last): File "repl.py", line 3, in from enum import Enum ImportError: cannot import name Enum #!/usr/bin/python2 from enum import Enum class…
Ravi Chauhan
  • 11
  • 2
0
votes
3 answers

Why repmgr showing WAL replay is paused on all standby node?

At repmgr cluster show command showing below error. Why it show WAL replay is paused on node2 & node3 as a warning. Here node2 and node3 is my standby node. Here I attached postgresql.auto.conf for node1 and node2. After PITR using Barman I found…
Sheikh Wasiu Al Hasib
  • 450
  • 5
  • 18
0
votes
0 answers

Cannot connect Barman to PostgreSQL 12

I have 2 ubuntu-20.04 VM on VMWARE with Postgres 12 installed on each pgprimary on ip 192.168.1.131 pgbackup on ip 192.168.1.130 barman CLI tools are installed on pgprimary barman is installed on pgbackup I want to backup data from pgprimary on…
Tarek EZZAT
  • 333
  • 1
  • 5
  • 15
0
votes
0 answers

Recover Postgresql pgBarman

I've setup a postgresql DB and I want to backup it. I've 1 server with my main DB et 1 with Barman. All the setup is working, I can backup my DB with barman. I just don't understand how I can recover my DB on a exact time point between the backups…
Nicolas C
  • 1
0
votes
1 answer

Barman geo-redundancy configuration error

I trying to config the geo-redundancy on my barman setup, but i get an error when i try to copy from primary to secundary backup, my configuration is: SERVER 1 Ubuntu 18 on Virtual Box Postgres 12 192.168.0.103 /etc/barman.conf backup_method =…
Tiago Oliveira de Freitas
  • 476
  • 1
  • 7
  • 17
0
votes
1 answer

Barman restore command behavior w.r.t PITR

I have setup the Backup via rsync/SSH with WAL streaming (Scenario 2b as mentioned in barman docs) architecture with a single PostgreSQL and Barman. I am trying to understand how PITR works with barman recover command. What would be the expected…
lmk
  • 654
  • 5
  • 21
0
votes
1 answer

Automatic creation of replication slot not working on Barman 2.11?

I am using barman 2.11 and postgres 9.5 in my setup. I specified "create_slot = auto" in the server config for automatic replication slot creation as mentioned in the docs but it unfortunately appears to have no effect & the barman check reports the…
lmk
  • 654
  • 5
  • 21
0
votes
1 answer

Older barman 2.6-1 instead of the latest 2.11 when using 2ndQuadrant Public APT repository

I am trying to setup & deploy barman as a docker container as part of setting up PostgreSQL DR. I notice that when i use the 2ndQuadrant Public APT repository & install barman i see barman 2.6-1 getting installed instead of 2.11. Below is my…
lmk
  • 654
  • 5
  • 21
0
votes
1 answer

Barman - Postgres "normal" Backups

I am trying to configure Barman but I can only find backups with SSH access or WAL. Is there any other way to do automatic backups with barman that dont depend on SSH/WAL? I dont have access to these features because its a managed db. Thanks for…
Rickser
  • 45
  • 4
1
2
3