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 11: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
