Erinevus lehekülje "Barman" redaktsioonide vahel
Allikas: Kuutõrvaja
(→Seadistus) |
(→Seadistus) |
||
35. rida: | 35. rida: | ||
description = "Main DB Server" | description = "Main DB Server" | ||
ssh_command = ssh postgres@192.168.0.4 | ssh_command = ssh postgres@192.168.0.4 | ||
− | conninfo = host=192.168.0.4 user=postgres | + | backup_options = exclusive_backup |
+ | parallel_jobs = 1 | ||
+ | conninfo = host=192.168.0.4 user=postgres password=parool | ||
+ | last_backup_maximum_age = 33 DAYS | ||
+ | minimum_redundancy = 1 | ||
+ | retention_policy = RECOVERY WINDOW OF 1 MONTHS | ||
Postgres serveris lisame käsud rsyncida walide barmani saatmise, postgresql.conf | Postgres serveris lisame käsud rsyncida walide barmani saatmise, postgresql.conf |
Redaktsioon: 7. august 2020, kell 11:11
Sissejuhatus
Barman on postgresi varundamise vahend, kus postgresql server saadab pidevalt enda muudatused wal-idena barmani serverisse ning annab seeläbi point-in-time recovery võimekuse.
- Postgres-server 192.168.0.4
- Barman-server 192.168.0.5
Paigaldus Debianis
# apt-get install barman barman-cli
Postgresql server ja barman server peavad suutma mõlemad logida ssh võtmetega üksteise käsureale
Postgresql serveris
# sudo -u postgres ssh-keygen -b 2048 -t rsa -N "" -C "postgres@server-a"
Barman serveris
# sudo -u barman ssh-keygen -b 2048 -t rsa -N "" -C "barman@server-b"
Seadistus
Avame barmani serveris /etc/barman.conf
[barman] barman_home = /srv/barman barman_user = barman log_file = /var/log/barman/barman.log compression = gzip reuse_backup = link backup_method = rsync archiver = on [main-db-server] description = "Main DB Server" ssh_command = ssh postgres@192.168.0.4 backup_options = exclusive_backup parallel_jobs = 1 conninfo = host=192.168.0.4 user=postgres password=parool last_backup_maximum_age = 33 DAYS minimum_redundancy = 1 retention_policy = RECOVERY WINDOW OF 1 MONTHS
Postgres serveris lisame käsud rsyncida walide barmani saatmise, postgresql.conf
archive_mode = on archive_command = ‘rsync -a %p barman@192.168.0.5:STREAMING_WALS_DIRECTORY/%f`
Kasutamine
Tekitame main backupi
# barman backup postgres-server
Vaatamiseks
# barman list-backup postges-server
Barman võimaldab ka point-in-time taastamist otse serverisse, kus võetakse aluseks üks backupidest ning täiendatakse seda arhiveeritud wal-idega
# barman recover --target-time "2020-03-04 06:42:34.139167+02:00" --remote-ssh-command "ssh postgres@192.168.0.4" main-server 20200304T010401 /var/data/pgdata