Postgresql Backup via Barman backup at Muthoot group - Revision history

Abhinav: /* Restoration */

2013-09-09T06:33:08Z

Restoration

← Older revision		Revision as of 06:33, 9 September 2013
Line 139:		Line 139:

	where 20110920T185953 is the ID of the backup to be restored. When this command completes succesfully, /path/to/recover/directory contains a complete data directory ready to be started as a PostgreSQL database server.		where 20110920T185953 is the ID of the backup to be restored. When this command completes succesfully, /path/to/recover/directory contains a complete data directory ready to be started as a PostgreSQL database server.

			For Remote Recovery

			#barman recover main 20110920T185953 --remote-ssh-command postgres@server-ip:/tmp/recover

	Here is an example of a command that starts the server:		Here is an example of a command that starts the server:

	barman@backup$ pg_ctl -D /path/to/recover/directory start		barman@backup$ pg_ctl -D /path/to/recover/directory start

			#pg_ctl Stop
			#pg_ctl -D /tmp/recover start

	==Important Commands ==		==Important Commands ==

Biswajit at 15:33, 4 July 2013

2013-07-04T15:33:14Z

← Older revision		Revision as of 15:33, 4 July 2013
Line 1:		Line 1:
	[[category:Tetra Clients]]		[[category:Tetra Clients]]
	[[category:Installation]]		[[category:Installation]]
			[[category:Muthoot group]]

	== Backup Implemenation at Muthoot Group 's Live PostgreSql Server (RHEL 6) ==		== Backup Implemenation at Muthoot Group 's Live PostgreSql Server (RHEL 6) ==

Biswajit: /* Backup Implemenation at Muthoot Group 's Live PostgreSql Server */

2012-12-28T03:41:15Z

Backup Implemenation at Muthoot Group 's Live PostgreSql Server

← Older revision		Revision as of 03:41, 28 December 2012
Line 2:		Line 2:
	[[category:Installation]]		[[category:Installation]]

	== Backup Implemenation at Muthoot Group 's Live PostgreSql Server ==		== Backup Implemenation at Muthoot Group 's Live PostgreSql Server (RHEL 6) ==


	==Environment==		==Environment==

Biswajit: /* Delete Last Barman Backup ( as barman user) */

2012-12-26T04:50:27Z

Delete Last Barman Backup ( as barman user)

← Older revision		Revision as of 04:50, 26 December 2012
Line 184:		Line 184:
	==Delete Last Barman Backup ( as barman user)==		==Delete Last Barman Backup ( as barman user)==

	Script for auto deletion		Script for auto deletion (delete-last-backup.sh)
	#!/bin/bash		#!/bin/bash
	VALUE=`barman list-backup main \| tail -1 \| cut -d" " -f 2`		VALUE=`barman list-backup main \| tail -1 \| cut -d" " -f 2`

Biswajit at 04:49, 26 December 2012

2012-12-26T04:49:24Z

← Older revision		Revision as of 04:49, 26 December 2012
Line 161:		Line 161:

	barman check main		barman check main


			==Checking of the barman postgresql Backup==

			Login in 192.168.1.132 (the backup server of Muthoot)

			su - barman
			barman list-backup main

			main 20121225T010001 - Tue Dec 25 01:04:37 2012 - Size: 2.0 GiB - WAL Size: 6.0 MiB
			main 20121224T010001 - Mon Dec 24 01:04:34 2012 - Size: 2.0 GiB - WAL Size: 52.0 MiB
			main 20121223T010002 - Sun Dec 23 01:04:35 2012 - Size: 2.0 GiB - WAL Size: 12.0 MiB
			main 20121222T010001 - Sat Dec 22 01:04:33 2012 - Size: 2.0 GiB - WAL Size: 68.0 MiB
			main 20121221T010002 - Fri Dec 21 01:04:33 2012 - Size: 2.0 GiB - WAL Size: 47.0 MiB
			main 20121220T010001 - Thu Dec 20 01:04:31 2012 - Size: 2.0 GiB - WAL Size: 43.0 MiB
			main 20121219T010001 - Wed Dec 19 01:04:31 2012 - Size: 2.0 GiB - WAL Size: 58.0 MiB
			main 20121218T010001 - Tue Dec 18 01:04:31 2012 - Size: 2.0 GiB - WAL Size: 27.0 MiB

			it should show the last few backups , else raise the alarm


			==Delete Last Barman Backup ( as barman user)==

			Script for auto deletion
			#!/bin/bash
			VALUE=`barman list-backup main \| tail -1 \| cut -d" " -f 2`
			barman delete main $VALUE
			exit

			Make cron entry as barman user

			Crontab -l

			0 1 * * * barman backup main
			0 6 * * * /var/lib/barman/delete-last-backup.sh

Biswajit: /* Installation process */

2012-12-11T04:30:29Z

Installation process

← Older revision		Revision as of 04:30, 11 December 2012
Line 75:		Line 75:

	Make sure you change the INCOMING_WALS_DIRECTORY placeholder with the value returned by the ''barman show-server main'' command (.132 via barman user) above.		Make sure you change the INCOMING_WALS_DIRECTORY placeholder with the value returned by the ''barman show-server main'' command (.132 via barman user) above.

			In Our case it is /var/lib/barman/main/incoming/

	Restart the Postgresql Server ( reloading will not help )		Restart the Postgresql Server ( reloading will not help )

Biswajit: /* Installation process */

2012-12-10T13:07:01Z

Installation process

← Older revision		Revision as of 13:07, 10 December 2012
Line 82:		Line 82:

	It should show something like below		It should show something like below
	Server main:		Server main:
	active: true		active: true
	description: Main PostgreSQL Database		description: Main PostgreSQL Database
	ssh_command: ssh postgres@192.168.1.133		ssh_command: ssh postgres@192.168.1.133
	conninfo: host=192.168.1.133 user=postgres		conninfo: host=192.168.1.133 user=postgres
	backup_directory: /var/lib/barman/main		backup_directory: /var/lib/barman/main
	basebackups_directory: /var/lib/barman/main/base		basebackups_directory: /var/lib/barman/main/base
	wals_directory: /var/lib/barman/main/wals		wals_directory: /var/lib/barman/main/wals
	incoming_wals_directory: /var/lib/barman/main/incoming		incoming_wals_directory: /var/lib/barman/main/incoming
	lock_file: /var/lib/barman/main/main.lock		lock_file: /var/lib/barman/main/main.lock
	compression: gzip		compression: gzip
	custom_compression_filter: None		custom_compression_filter: None
	custom_decompression_filter: None		custom_decompression_filter: None
	retention_policy: None		retention_policy: None
	wal_retention_policy: None		wal_retention_policy: None
	pre_backup_script: None		pre_backup_script: None
	post_backup_script: None		post_backup_script: None
	current_xlog: 00000001000000010000000E		current_xlog: 00000001000000010000000E
	last_shipped_wal: None		last_shipped_wal: None
	archive_command: rsync -a %p barman@192.168.1.132:/var/lib/barman/main/incoming/%f		archive_command: rsync -a %p barman@192.168.1.132:/var/lib/barman/main/incoming/%f
	server_txt_version: 8.4.13		server_txt_version: 8.4.13
	data_directory: /var/lib/pgsql/data		data_directory: /var/lib/pgsql/data
	archive_mode: on		archive_mode: on
	config_file: /var/lib/pgsql/data/postgresql.conf		config_file: /var/lib/pgsql/data/postgresql.conf
	hba_file: /var/lib/pgsql/data/pg_hba.conf		hba_file: /var/lib/pgsql/data/pg_hba.conf
	ident_file: /var/lib/pgsql/data/pg_ident.conf		ident_file: /var/lib/pgsql/data/pg_ident.conf

	Checking the barman server		Checking the barman server
	barman check main		barman check main
	Server main:		Server main:
	ssh: OK		ssh: OK
	PostgreSQL: OK		PostgreSQL: OK
	archive_mode: OK		archive_mode: OK
	archive_command: OK		archive_command: OK
	directories: OK		directories: OK
	compression settings: OK		compression settings: OK

	In our case we have linked the main diecrtory of /var/lib/barman to /home/postreg_barman_backup/main as the home partion is very big to hold the backups		In our case we have linked the main diecrtory of /var/lib/barman to /home/postreg_barman_backup/main as the home partion is very big to hold the backups

Biswajit: /* Software Used */

2012-12-10T13:02:39Z

Software Used

← Older revision		Revision as of 13:02, 10 December 2012
Line 12:		Line 12:

	==Software Used==		==Software Used==

	Barman Backup Software for PostgreSql - http://www.pgbarman.org/		Barman Backup Software for PostgreSql - http://www.pgbarman.org/

	Document Refered - http://docs.pgbarman.org/		Document Refered - http://docs.pgbarman.org/

Biswajit: /* Environment */

2012-12-10T13:02:23Z

Environment

← Older revision		Revision as of 13:02, 10 December 2012
Line 8:		Line 8:

	1.Live PG server - 192.168.1.133		1.Live PG server - 192.168.1.133

	2.Backup Server - 192.168.1.132		2.Backup Server - 192.168.1.132

Biswajit at 13:01, 10 December 2012

2012-12-10T13:01:02Z

← Older revision		Revision as of 13:01, 10 December 2012
Line 1:		Line 1:
			[[category:Tetra Clients]]
			[[category:Installation]]

	== Backup Implemenation at Muthoot Group 's Live PostgreSql Server ==		== Backup Implemenation at Muthoot Group 's Live PostgreSql Server ==