Erinevus lehekülje "Barman" redaktsioonide vahel
Allikas: Kuutõrvaja
| 3. rida: | 3. rida: | ||
TODO | TODO | ||
| − | * Postgres server 192.168.0.4 | + | * Postgres-server 192.168.0.4 |
| − | * Barman server 192.168.0.5 | + | * Barman-server 192.168.0.5 |
===Paigaldus Debianis=== | ===Paigaldus Debianis=== | ||
| 21. rida: | 21. rida: | ||
===Seadistus=== | ===Seadistus=== | ||
| − | /etc/barman.conf | + | Avame barmani serveris /etc/barman.conf |
[barman] | [barman] | ||
| 37. rida: | 37. rida: | ||
conninfo = host=192.168.0.4 user=postgres | 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 | ||
===Lingid=== | ===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:43
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
