Database Administrators Stack Exchange
Database Administrators Stack Exchange

Questions tagged [barman]

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

See also

57 questions
8
votes
3 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
  • 183
  • 1
  • 1
  • 5
6
votes
2 answers

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 been closed on server 'pg' Waiting for the WAL file…
Saurabh Nanda
  • 333
  • 1
  • 4
  • 16
3
votes
1 answer

I need help understanding Postgres's archive cleanup functionality

I'm reading http://www.postgresql.org/docs/9.2/static/pgarchivecleanup.html and to me it seems like it will remove any and all WAL segments from my slave server that aren't required to perform recovery upon the slave server crashing (so basically…
orokusaki
  • 1,209
  • 2
  • 12
  • 21
3
votes
1 answer

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 critical. Is there a way to ignore those tables…
André Christoffer Andersen
  • 217
  • 1
  • 7
3
votes
1 answer

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: PostgreSQL: OK is_superuser: OK …
rawmain
  • 359
  • 1
  • 9
  • 20
2
votes
2 answers

Barman incremental backups and a recovery window: what is actually stored?

I'm planning on setting up streaming backups + WAL streaming with Barman from a PostgreSQL 17 instance. From my reading of the documentation, I don't quite understand what will happen in the scenario that I've planned—if it's valid at all. Here's my…
JK Laiho
  • 175
  • 5
2
votes
1 answer

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 filesystem, then initiated a pgbasebackup to the new…
Abraam Magued
  • 153
  • 1
  • 5
2
votes
0 answers

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 backups of old data that is over 1 year old, since…
Nyxynyx
  • 1,131
  • 6
  • 18
  • 29
2
votes
1 answer

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. I have barman 2.7 and postgresl 10.8 When I check…
ERQ14
  • 21
  • 2
2
votes
1 answer

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 log_file = /var/log/barman/barman.log log_level =…
Tombart
  • 1,160
  • 11
  • 23
2
votes
1 answer

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 in. Do you have any ideas ? For information, I…
TheWhiteWolf
  • 107
  • 1
  • 8
2
votes
2 answers

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 installed on backup server. barman cron is running…
Exempio Inc
  • 31
  • 1
  • 1
  • 4
2
votes
1 answer

Is it possible to migrate a postgresql database without downtime?

I have a Postgresql Database on my Centos, I use barman to backup my database, my question is that is it possible to migrate my database to another server without downtime? I know some solutions with small downtime with pg_start_backup(), barman…
Mairon
  • 121
  • 1
  • 4
1
vote
0 answers

BARMAN backup issue in edb postgresql16

I am facing BARMAN backup issue in EDB postgresql 16 database. 1> For taking incremental backup,I had changed backup_method in barman.conf file from postgres to rsync. Kept any other parameter same [root@innolx4057 barman.d]# cat…
Cassandra Thrift
  • 307
  • 1
  • 7
1
vote
0 answers

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 another barman slot. Below is the command: barman…
Sheikh Wasiu Al Hasib
  • 273
  • 1
  • 2
  • 14
1
2 3 4