Erinevus lehekülje "Barman" redaktsioonide vahel
Allikas: Kuutõrvaja
(Uus lehekülg: ' https://www.digitalocean.com/community/tutorials/how-to-back-up-restore-and-migrate-postgresql-databases-with-barman-on-centos-7') |
|||
1. rida: | 1. rida: | ||
+ | ===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=== | ||
+ | |||
+ | /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 | ||
+ | |||
+ | |||
+ | ===Lingid=== | ||
https://www.digitalocean.com/community/tutorials/how-to-back-up-restore-and-migrate-postgresql-databases-with-barman-on-centos-7 | https://www.digitalocean.com/community/tutorials/how-to-back-up-restore-and-migrate-postgresql-databases-with-barman-on-centos-7 |
Redaktsioon: 6. august 2020, kell 10:40
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
/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