Barman - Redigeerimiste ajalugu

Jj: /* Paigaldus Debianis */

2020-08-07T09:15:31Z

Paigaldus Debianis

←Vanem redaktsioon		Redaktsioon: 7. august 2020, kell 09:15
10. rida:		10. rida:
	# apt-get install barman barman-cli		# apt-get install barman barman-cli

	Postgresql server ja barman server peavad suutma mõlemad logida ssh võtmetega üksteise käsureale		Postgresql server ja barman server peavad suutma mõlemad logida ssh võtmetega üksteise käsureale. Ehk siis barman kasutaja peab saama logida postgres kasutajaga
			postgres sererisse ja postgres serer omakorda barman kasutajaga barmani serverisse.

	Postgresql serveris		Postgresql serveris

2020-08-07T09:14:12Z

Seadistus

←Vanem redaktsioon		Redaktsioon: 7. august 2020, kell 09:14
32. rida:		32. rida:
	archiver = on		archiver = on

	[main~~-db~~-server]		[main-server]
	description = "Main DB Server"		description = "Main DB Server"
	ssh_command = ssh postgres@192.168.0.4		ssh_command = ssh postgres@192.168.0.4
45. rida:		45. rida:

	archive_mode = on		archive_mode = on
	archive_command = ‘rsync -a %p barman@192.168.0.5:~~STREAMING_WALS_DIRECTORY~~/%f`		archive_command = ‘rsync -a %p barman@192.168.0.5:/srv/barman/main-server/incoming/%f`

			/var/data/barman/main-server/incoming/%f

	===Kasutamine===		===Kasutamine===

2020-08-07T09:11:41Z

Seadistus

←Vanem redaktsioon		Redaktsioon: 7. august 2020, kell 09:11
35. rida:		35. rida:
	description = "Main DB Server"		description = "Main DB Server"
	ssh_command = ssh postgres@192.168.0.4		ssh_command = ssh postgres@192.168.0.4
	conninfo = host=192.168.0.4 user=postgres		backup_options = exclusive_backup
			parallel_jobs = 1
			conninfo = host=192.168.0.4 user=postgres password=parool
			last_backup_maximum_age = 33 DAYS
			minimum_redundancy = 1
			retention_policy = RECOVERY WINDOW OF 1 MONTHS

	Postgres serveris lisame käsud rsyncida walide barmani saatmise, postgresql.conf		Postgres serveris lisame käsud rsyncida walide barmani saatmise, postgresql.conf

2020-08-06T09:50:48Z

Seadistus

←Vanem redaktsioon		Redaktsioon: 6. august 2020, kell 09:50
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		Postgres serveris lisame käsud rsyncida walide barmani saatmise, postgresql.conf

	archive_mode = on		archive_mode = on

2020-08-06T09:43:42Z

Sissejuhatus

←Vanem redaktsioon		Redaktsioon: 6. august 2020, kell 09:43
1. rida:		1. rida:
	===Sissejuhatus===		===Sissejuhatus===

	~~TODO~~		Barman on postgresi varundamise vahend, kus postgresql server saadab pidevalt enda muudatused wal-idena barmani serverisse ning annab seeläbi point-in-time recovery võimekuse.

	* Postgres-server 192.168.0.4		* Postgres-server 192.168.0.4

2020-08-06T08:54:36Z

Kasutamine

←Vanem redaktsioon		Redaktsioon: 6. august 2020, kell 08:54
51. rida:		51. rida:

	# barman list-backup postges-server		# barman list-backup postges-server

			Barman võimaldab ka point-in-time taastamist otse serverisse, kus võetakse aluseks üks backupidest ning täiendatakse seda arhiveeritud wal-idega

			# barman recover --target-time "2020-03-04 06:42:34.139167+02:00" --remote-ssh-command "ssh postgres@192.168.0.4" main-server 20200304T010401 /var/data/pgdata

	===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

2020-08-06T08:43:41Z

←Vanem redaktsioon		Redaktsioon: 6. august 2020, kell 08:43
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

2020-08-06T08:40:43Z

←Vanem redaktsioon		Redaktsioon: 6. august 2020, kell 08:40
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

2019-03-05T12:10:03Z

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

Uus lehekülg

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