As of May 31, 2023, we have updated our Code of Conduct.

Questions tagged [barman]

Barman (backup manager) is a PostgreSQL-specific tool for backup and recovery. It manages backups of multiple remote servers.

Filter by
Sorted by
Tagged with
0 votes
0 answers
39 views

Difference between WALs archival from primary db and Barman streaming WALs from the primary

In fact, it is not a problem, yet I find it hard to differentiate between 2 concepts 1- WALs archival: Usually done from the primary, by defining the archive_mode and the archive_command in the ...
Abraam Magued's user avatar
0 votes
1 answer
42 views

Postgresql: Why incremental size is negative at barman backup details?

Here my backup method is rsync and reuse_backup=link. Everything doing well, but why incremental size showing negative value. Necessary details given below.
Sheikh Wasiu Al Hasib's user avatar
1 vote
0 answers
107 views

How to activate barman_slot in PostgreSQL?

I am using PostgreSQL cluster with Barman backup tools. I just recovered one of my backups. After recover, I found barman slot is inactive. Later, I deleted that inactive barman slot and created ...
Sheikh Wasiu Al Hasib's user avatar
1 vote
1 answer
3k views

Failed Postgres Replication from master to standby

I have a master-standby postgres cluster; For availability issue, I want to add a new standy server. So I created a new server, did base installation as installing postgres, creating postgres data ...
Abraam Magued's user avatar
0 votes
1 answer
399 views

PITR with barman fails - is my understanding even accurate?

I mange to take backups and recover them to my postgres-server. Now I want to see what PITR is able to do with these steps create a backup (20220111T062908) wait a minute create a new database (at 06:...
vrms's user avatar
  • 165
1 vote
1 answer
624 views

Barman Postgres 14 recovery

I updated my postgres from 10 to 14 few weeks ago. The recovery used to work before (restoring the backup on a different postgres server): Put the barman backup into the folder ssh -i ./do.pem root@...
Sergey Dudik's user avatar
0 votes
1 answer
523 views

WAL streaming backups with barman - WAL archive: FAILED

I am setting up a barman server to backup a remote PostgreSQL server and am digging my way through a bunch of FAILED messages I get on barman check [pg] Server pg: WAL archive: FAILED (please ...
vrms's user avatar
  • 165
0 votes
1 answer
900 views

barman check - what do the Error Messages mean?

Trying to get wal-streaming backups for PostgreSQL running with a barman backup server I face quite some errors on barman check [postgres_server] here an example :~> barman check pg Server pg: ...
vrms's user avatar
  • 165
0 votes
2 answers
104 views

barman installation without root priviledges - where to put barman.conf?

I am trying to figure out a Barman-2.13 installation via Ansible from the source code from github as barman user inside /opt/barman (which also is the home of the barman user). I use the barman manual ...
vrms's user avatar
  • 165
1 vote
1 answer
242 views

Could Barman backup only one database from PostgreSQL?

In my system, I have postgresql 12 and barman v2.13. I have a few backup disk around 1 TB and i have currently added new DB which has 5 TB. Previously my PostgreSQL had no more than 400 GB. i think ...
Melih's user avatar
  • 274
0 votes
1 answer
2k views

How do I stop WAL streaming in BARMAN cron?

I am having an issue "resetting" or fixing a backup server I have in BARMAN: -bash-4.2$ barman check *server-name* Server *server-name*: PostgreSQL: OK superuser or standard ...
Troy Meyerink's user avatar
1 vote
0 answers
1k views

How do you totally reset a barman backup setup?

I have recently had a database crash and recovered the machine using methods other than barman in this case. Now I have barman correctly annoyed about the status of the wal files, but for the life of ...
Peter Nunn's user avatar
-1 votes
1 answer
2k views

barman + how to cleanup the wals folder

we are using the barman - backup and restore for postgresql we noticed the under folder usage - /var/lib/barman/main-db-server/wals is 110G example to what we have 824M /var/lib/barman/main-db-...
sheffadmin's user avatar
2 votes
1 answer
256 views

To reduce recovery time (and save space): Is it possible to ignore some PostgreSQL 13 tables (or schemas) when backing up using Barman?

We have some large staging/scratch tables in one of our PostgreSQL databases. The data in them can be automatically regenerated from other databases after recovery of the database, and aren't business ...
André Christoffer Andersen's user avatar
0 votes
1 answer
257 views

Safely shutting down seemingly misconfigured (but working) PostgreSQL replication/archiving

I'm helping administer two PostgreSQL servers (one primary, one replica) plus a separate server running Barman for WAL archiving. I was not originally involved in setting up the replication and ...
JK Laiho's user avatar
  • 135
1 vote
1 answer
212 views

Recover old backup with barman

I have setup barman that allows me to backup my database. I have several backup, and I would like to recover an old backup. because I need to check the state of the database at a given time, two month ...
iAmoric's user avatar
  • 111
0 votes
1 answer
129 views

Why use synchronous_standby_names = 'barman_receive_wal' will cause database aberrant?

Use barman's synchronous_standby_names feature in PostgreSQL's postgresql.conf file synchronous_standby_names = 'barman_receive_wal' Can't do these operations: createuser(hanging) createdb(hanging) ...
rawmain's user avatar
  • 269
1 vote
1 answer
208 views

how long can your replica be offline when using repmgr with Barman?

I'm setting up some postgres database EC2 instances that I'd like to use for load balancing. The application I'm running has some very expensive and very unique queries so CPU usage is a concern. ...
dangel's user avatar
  • 236
0 votes
0 answers
168 views

High RAM usage during Postgres PITR

We're currently running Postgres 10 in our infrastructure with Barman managing weekly full backups and holding onto the WALs. Because of the size of our DB, the WAL volume, and resource constraints ...
Sammitch's user avatar
  • 306
1 vote
1 answer
749 views

Postgres Server staying in read only mode after a barman recover command is executed

All, I am trying to perform a PITR restore using barman using recover command. The problem is that the server remains in the read-only state once the barman recover is done. Is there a way by which ...
vsh9's user avatar
  • 13
1 vote
0 answers
177 views

How to use Barman's passive server?

I followed Barman's document to setup a primary(backup) server and a passive server: http://docs.pgbarman.org/release/2.10/ node1: backup server(10.0.1.1) node2: passive server(10.0.1.2) On node2, ...
rawmain's user avatar
  • 269
0 votes
2 answers
320 views

Is it possible to make a high availability PostgreSQL database cluster by open source softwares?

If use these tools can make a great modern database cluster with full features: pgbouncer (with HAProxy for HA) repmgr barman The main database will run on the repmgr servers. It has primary and ...
rawmain's user avatar
  • 269
0 votes
2 answers
823 views

How to install Barman with pg_receivewal and pg_basebackup without install PostgreSQL server?

Follow the official document, it's only necessary to install barman by yum or apt straightforward: http://docs.pgbarman.org/release/2.10/#installation Unnecessary to install PostgreSQL server on the ...
rawmain's user avatar
  • 269
2 votes
1 answer
1k views

Why backup database by Barman can't reach end(pending)?

Did operations: barman cron barman receive-wal --create-slot pg barman receive-wal pg barman switch-wal --force --archive pg Then run check and backup command: -bash-4.2$ barman check pg Server pg: ...
rawmain's user avatar
  • 269
1 vote
2 answers
2k views

How to use barman to backup PostgreSQL database correctly?

I am using PostgreSQL 10 now. Installed newest Barman on RHEL 7. When I run this command by barman user: -bash-4.2$ barman receive-wal pg Starting receive-wal for server pg ERROR: ArchiverFailure:...
rawmain's user avatar
  • 269
1 vote
1 answer
79 views

Backup and restore for PostgreSQL + why number of backups increased while we limit the recovery window of 7 days

We are using the barman for PostgreSQL backup and restore on rhel 7.2 machines In the barman configuration file - /etc/barman.conf we set the following retention_policy_mode = auto retention_policy ...
jessica's user avatar
  • 113
1 vote
2 answers
948 views

barman & Dockerized PostgreSQL: check timeout: FAILED (barman check command timed out)

I am trying to configure barman to backup a PostgreSQL 11 database running inside a Docker container. barman v2.10 is installed directly in the Ubuntu 18.04.3 host machine. barman check pgsql gives ...
Nyxynyx's user avatar
  • 1,091
2 votes
0 answers
640 views

Backing up Time Series Database (PostgreSQL/TimescaleDB) where old data will never be updated

If a PostgreSQL (using TimescaleDB extension) database that holds time series data is continuously growing in size, what is the recommended backup strategy if we do not want to continuously create ...
Nyxynyx's user avatar
  • 1,091
0 votes
1 answer
289 views

Is it possible to make simple postgres dump using replication server?

PostgreSQL 9.6, configured backup server via barman tool. Using WAL streaming (pg_receivexlog) and streaming backup (pg_basebackup). All working good. However for development/debugging purposes I may ...
frutality's user avatar
  • 103
0 votes
1 answer
2k views

barman-wal-archive with -WAL archive: FAILED (please make sure WAL shipping is setup)

i'm trying to use "barman-wal-archive" can't find out where to fix the issue or how to debug it, anyway there is a brand-new barman 2.10 and it's log: 2019-12-16 10:44:08,908 [16653] barman.server ...
Mikhail Aksenov's user avatar
0 votes
1 answer
250 views

Barman shows huge variance in WAL size

I'm using barman to take backups from postgresql. This is the result of list-backup: prod 20190831T000005 - Sat Aug 31 00:04:58 2019 - Size: 16.0 GiB - WAL Size: 654.2 MiB prod 20190830T000005 - ...
sazary's user avatar
  • 105
1 vote
1 answer
1k views

Postgresql replication slot used by barman has a long replay_lag

I set up barman using wal streaming, I just notice I have a hug replay_lag. I'd like to keep it down to 0 but have no idea about how to do this. I also have a database replica and it is working fine. ...
ERQ14's user avatar
  • 11
0 votes
1 answer
744 views

Barman: What's the best way to switch from backup_method postgres (streaming) to rsync (ssh)?

My production postgresql server is currently backed up with barman using the backup_method postgres (streaming server). I would like to switch to rsync method (ssh) to benefit from better compression. ...
jean pierre huart's user avatar
1 vote
2 answers
1k views

How much time should a backup of a 100Gb database take using streaming server setup?

I've installed barman on a dedicated server to backup all my postgresql servers. One of the server is now using 100Gb space and the instruction barman backup myserver takes 23 hours. I find it too ...
jean pierre huart's user avatar
1 vote
1 answer
3k views

Barman not able to connect: fe_sendauth: no password supplied

I'm trying to setup streaming replication to a Barman server. Barman config is pretty much basic, I'm using backup_method = postgres. [barman] barman_home = /var/lib/barman barman_user = barman ...
Tombart's user avatar
  • 962
0 votes
1 answer
874 views

verify barman backed up files after failure [closed]

I have a barman that get backups from a postgres installed on another server. its config is: active: True archive_mode: on archived_count: 47588 archiver: True archiver_batch_size:...
Alireza's user avatar
  • 123
2 votes
1 answer
602 views

The pg_wal directory on a standby server does not get auto-purged

I have a classic master-slaver PG (version 10) architecture. Despite the fact the parameter wal_keep_segments is set to 200, the pg_wal directory on the standby server is not purged and keeps filling ...
TheWhiteWolf's user avatar
1 vote
0 answers
1k views

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 ...
Kevin Lee's user avatar
  • 113
1 vote
1 answer
2k views

WAL files not being deleted and pg_drop_replication_slot('barman') causes [55000] ERROR: replication slots can only be used if wal_level > = archive

My database has stopped deleting WAL files and pg_xlog grows to eventually take all my disk space. I have to use pg_controldata and pg_archivecleanup to delete them manually. I'm almost certain it'...
Marvin Irwin's user avatar
1 vote
1 answer
495 views

Postgresql: How to take incremental backup with Barman

I am new to Postgresql, I've found a tool named Barman for taking incremental backup of database. But the few tutorials aren't helping that much as they're not for naive users. Can someone help ...
Proteeti Prova's user avatar
1 vote
0 answers
361 views

Does barman require continuous execution of receive-wal on a slot for streaming replication to work?

I am new to barman and am trying to implement barman on my server. I have followed each and every step as mentioned in the barman docs. Everything works fine till the receive-wal command in running in ...
Prashant Bajpai's user avatar
1 vote
0 answers
1k views

Postgresql Crashed after os reboot

In Postgresql 9.6 after reboot first I got: 2018-04-21 14:36:27 UTC LOG: database system was shut down at 2018-04-21 11:01:15 UTC 2018-04-21 14:36:27 UTC LOG: invalid checkpoint record 2018-04-21 ...
shalbafzadeh's user avatar
2 votes
2 answers
9k views

Error Receiving WAL files with barman

I'm having a similar issue reported here but no solutions have helped: Unable to receive WAL files with barman Trying to get streaming replication to work. PostgreSQL 9.6 on the master. Barman 2.3 ...
Exempio Inc's user avatar
0 votes
1 answer
1k views

barman creating log files with incorrect owner

I've got the following config snippet in my /etc/barman.conf: [barman] ; System user barman_user = ubuntu ; Log location log_file = /var/log/barman/barman.log However, whenever the log file is ...
Saurabh Nanda's user avatar
6 votes
2 answers
14k views

Unable to receive WAL files with barman

I've been scratching my head to solve the following error, but haven't made much progress: $ barman switch-wal --force --archive --archive-timeout 180 pg The WAL file 0000000100000059000000FF has ...
Saurabh Nanda's user avatar
0 votes
1 answer
516 views

PostgreSQL + why archive_command line is marked after barman 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 have seen that the line with archive_command was ...
yael's user avatar
  • 1
0 votes
1 answer
693 views

barman + postgresql not start after barman retore

I use the barman for backup and restore after some restore , we start the postgresql as the following systemctl start postgresql.service but postgresql not startup from the log: /var/lib/pgsql/...
yael's user avatar
  • 1
1 vote
0 answers
222 views

barman + corrupted wall + how it can be

I am using barman for bsackup version 2-1.1 and restore postgresql first after 2 restore that was successfully I perform some show-backup on other backup , and I notices all backup return this ...
yael's user avatar
  • 11
-1 votes
1 answer
535 views

barman + barman can show the details from backup directory

we have linux machine as backup server with barman tool when I want to see the details backup with the command barman show-backup then I get the following exceptions # barman show-backup main-db-...
yael's user avatar
  • 1
0 votes
1 answer
2k views

barman + backup and restore + how to enable auto deletion from backup files

I am using the barman tool to backup the postgresql DB barman is working fine but I notice that backup files that created under /var/lib/barman/main-db-server/base folder are not automatically being ...
ori's user avatar
  • 1