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
6
votes
1 answer

Setup barman backup when Posgres is running in Docker

I have a kubernetes cluster, with a pod running the postgres database, so in Docker. Obviously, I have the data mounted on the host. I would like to setup Barman to have a backup solution for the DB. I read the documentation about barman. According…
iAmoric
  • 1,787
  • 3
  • 31
  • 64
4
votes
2 answers

WAL archive: FAILED (please make sure WAL shipping is setup)

I am trying to configure Barman to backup. When I do a barman check replica I keep getting: Server replica: WAL archive: FAILED (please make sure WAL shipping is setup) PostgreSQL: OK superuser: OK wal_level: OK directories: OK retention policy…
Deepak Puthraya
  • 1,325
  • 2
  • 17
  • 28
2
votes
3 answers

How to compress postgres database backup using barman

We are backing up 1TB+ of postgres database using barman. Barman is backing up full database daily. Every day we are dumping 1TB+ database. So it's consuming huge space. We have following configuration in barman:(broad - level…
SAKA RAM DEWASI
  • 39
  • 5
2
votes
3 answers

barman PostgreSQL: FAILED

I am in the process of setting up a database backup system using Barman. My database is a postgreSQL db. When I run barman check main-db I get the following error: PostgreSQL: FAILED directories: OK retention policy…
anthonyjc93
  • 31
  • 2
  • 5
2
votes
0 answers

PostgreSQL + why archive_command line is marked after baarman restore

I use the barman tool as backup & restore for PostgreSQL after I restored successfully the data folder under /var/lib/pgsql by the barman we seen that line with archive_command was remarked by the #BARMAN# and the line - archive_command = false…
King David
  • 500
  • 1
  • 7
  • 20
2
votes
1 answer

How can I tell if barman is receiving the WAL stream during the day?

I followed the directions in this and this. I've also successfully backed up from one server and restored it to another server. My barman is on a dedicated machine. Looking good. But how can I tell if it's receiving the WAL stream during the day? …
101010
  • 14,866
  • 30
  • 95
  • 172
2
votes
1 answer

Barman recover command not copying "all" WAL files to standby database server from on Barman server

What is wrong with the recover command that isn't transferring these WAL files? barman recover --target-time "2017-05-16 16:39:02.235780+00:00" \ --remote-ssh-command "ssh postgres@52.212.62.91" \ main-db latest /var/lib/postgresql/9.4/main Here is…
aidanmelen
  • 6,194
  • 1
  • 23
  • 24
1
vote
1 answer

PostgreSQL not deleting old WAL archives

I have Postgresql 13 database and Barman 2.7 deployed for backing it up. The Barman is deployed on separated server. Barman is using streaming backup and WAL streaming via pg_recievewal. However the pg_wal directory become enormously large/not…
user22188956
  • 13
  • 3
1
vote
1 answer

Get last possible timestamp for PIT-Recovery with Barman

Is there a way for barman to determine the latest time for a POIT recovery? I think that barman used to tell you that if you specified a too late time for the recovery, he has no data for it. Currently barman simply performs the recovery and only…
Georg Gutsche
  • 452
  • 4
  • 9
  • 17
1
vote
1 answer

barman does not accept parameter 'target-time'

I try to recover a barman backup, and I want to use the parameter target-time. But barman does not accept this parameter, even if I use it in the same manner like many sources I found. The whole output: barman@BKUP-XXX:~$ barman recover…
Dave_B.
  • 173
  • 10
1
vote
2 answers

Pass a command string with space to docker-compose exec

Real life scenario: In my automation script, there is a cli to run barman recover on a barman container. However it's possible to pass the "ssh xxx" as a whole string arg to the --remote-ssh-command, and barman reports "barman: error: unrecognized…
silencej
  • 221
  • 2
  • 13
1
vote
0 answers

Return code 255 when trying to connect via ssh with barman

When I do a manual ssh connection it is working fine. But when I run barman check 192.168.0.41 it is giving me ssh : FAILED with return code 255 I have tried all methods that they explained in the pgbarman document like copying public keys and…
praveen kumar
  • 35
  • 2
  • 6
1
vote
1 answer

Handling backups of a large table (>1 TB) in Postgres?

I have a 1TB table (X) that is a pain to backup. The table X contains historical log data that is not often updated after creation. We usually only access a single row at a time, so performance is still very good. We currently make nightly full…
Kevin Lee
  • 1,171
  • 12
  • 30
1
vote
1 answer

Barman backup: Backup failed issuing start backup command

I have begun looking into using barman to perform my database backups however I have come across the following error: barman backup main-server This command gives the following result: ERROR: Impossible to start the backup. Check the log for more…
anthonyjc93
  • 31
  • 2
  • 5
0
votes
0 answers

Why can't repmgr attach my replica to the master?

I have a cluster of some posgtgresql databases and a Barman server for backup, managed with Repmgr. I'm currently in the process of attaching a new replica. The replica is currently cloning from Barman and now I would like to attach it to the master…
Niels Kristian
  • 8,661
  • 11
  • 59
  • 117
1
2 3