Barman
Allikas: Kuutõrvaja
Sissejuhatus
TODO
- 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 conninfo = host=192.168.0.4 user=postgres
Postgres serveris lisame 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