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


Lingid

https://www.digitalocean.com/community/tutorials/how-to-back-up-restore-and-migrate-postgresql-databases-with-barman-on-centos-7