Questions tagged [barman]
Barman (backup manager) is a PostgreSQL-specific tool for backup and recovery. It manages backups of multiple remote servers.
48
questions
-1
votes
1answer
21 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-...
2
votes
1answer
78 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 ...
0
votes
1answer
21 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 ...
0
votes
0answers
11 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 ...
0
votes
1answer
25 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)
...
0
votes
0answers
28 views
Create hot standby on top of Barman streaming backup
I set up a Barman server that uses pg_basebackup and pg_receivewal for streaming replication. It is pretty much the same setup as described in the Barman documentation (scenario 1).
Is there a ...
0
votes
1answer
16 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. ...
0
votes
0answers
21 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 ...
0
votes
1answer
95 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 ...
0
votes
0answers
55 views
How to use PostgreSQL backup tool Barman's passive feature?
There are 2 servers
Backup Server(Installed Barman)
Passive Server(Installed Barman)
Configuration
Backup Server
/etc/barman.d/postgresql-server-db1.conf
[db1]
description = "DB1 PostgreSQL ...
1
vote
0answers
48 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, ...
0
votes
0answers
13 views
Why cron jobs didn't be set correctly by Ansible playbook?
I created this playbook to set crontab:
- name: Set PATH to crontab
cron:
name: PATH
env: yes
user: barman
job: /usr/local/bin:/bin:/usr/bin:/usr/local/sbin:/usr/sbin:/var/lib/...
0
votes
2answers
59 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 ...
0
votes
0answers
166 views
How to promote a PostgreSQL standby server by repmgr automatically with pgbouncer and barman?
Now using these servers:
Node1: pgbouncer1
Node2: pgbouncer2
Node3: repmgr primary
Node4: repmgr standby
Node5: repgmr standby
Node6: repmgr standby
Node7: barman primary
Node8: barman passive
...
0
votes
2answers
193 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 ...
0
votes
1answer
188 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:
...
1
vote
2answers
471 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:...
0
votes
0answers
48 views
Is it possible to create 2 pgBouncer servers and automaticly notify changed repmgr master to Barman?
For a database cluster design as below:
In order to do high availability, prepare 2 pgBouncer servers. If the first server down, then the second server act as new connection pool, use HAProxy(Load ...
1
vote
1answer
39 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 ...
0
votes
2answers
216 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 ...
2
votes
0answers
275 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 ...
0
votes
1answer
42 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 ...
0
votes
1answer
573 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 ...
0
votes
1answer
49 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 - ...
1
vote
1answer
418 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.
...
0
votes
1answer
318 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
295 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 ...
1
vote
1answer
1k 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
1answer
218 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
286 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
336 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
914 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'...
1
vote
1answer
363 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
198 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
816 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 ...
2
votes
1answer
6k 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
585 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 ...
5
votes
2answers
7k 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
401 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
502 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
140 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 ...
-1
votes
1answer
265 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
1k 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 ...
6
votes
2answers
12k 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
552 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
3k 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
2k 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 ...