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
1answer
26 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. ...
1
vote
2answers
58 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 ...
0
votes
1answer
252 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 ...
0
votes
0answers
174 views

replication slot: FAILED (slot 'barman_the_backupper' not initialised: is 'receive-wal' running?)

I am running a postgres cluster with point in time restore using barman. It stopped streaming WAL. it says slot "barman_the_backupper" not initialized. how can I initilize this slot? I am getting ...
0
votes
1answer
32 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:...
2
votes
1answer
98 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 ...
1
vote
0answers
110 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 ...
1
vote
1answer
289 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'...
0
votes
1answer
204 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 ...
1
vote
0answers
115 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 ...
1
vote
0answers
357 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 ...
1
vote
1answer
3k 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 ...
0
votes
1answer
265 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 ...
4
votes
2answers
3k 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 ...
0
votes
1answer
278 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 ...
0
votes
1answer
392 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/...
1
vote
0answers
106 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 ...
0
votes
1answer
205 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-...
0
votes
1answer
497 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 ...
3
votes
2answers
6k views

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 ...
1
vote
0answers
443 views

pgbarman recover from streaming backup

I´m currently evaluating pgbarman for production use. I set up a testserver (postgres 9.6) and barman using synchronous streaming backup. I know the synchronous streaming works, the WAL file in ~...
0
votes
1answer
2k views

PostgreSQL corrupted after running pg_resetxlog

We are using PostgreSQL version 9.3 on Ubuntu 14.04. This PostgreSQL server shared among all our application servers (Odoo), so we made it run on the separate environment. On Saturday we found disk ...
0
votes
1answer
1k views

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 ...
3
votes
1answer
2k views

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 ...