PgBackupAll - Revision history

T1t0 at 04:10, 8 April 2019

2019-04-08T04:10:43Z

← Older revision		Revision as of 04:10, 8 April 2019
Line 1:		Line 1:
	~~Questo~~ script ~~fa un~~ backup ~~completo di~~ PostgreSQL ~~e lo invia all'~~email ~~configurato~~. ~~E' possibile restaurare il~~ backup ~~con le istruzioni dell'articolo~~ [[postgresql\|PostgreSQL]].		This script make a full backup of all PostgreSQL databases and sent email with the status. Optionally, it can send the backup by the email itself or by FTP . It is possible to restore this backup following the info at [[postgresql\|PostgreSQL]].



	= Requirements =		= Requirements =

	~~Il percorso~~ /srv/backup/postgresql/alldatabases/ ~~deve esistere e essere di proprietà dell'utente~~ postgres, ~~e i comandi mail,~~ pg_dumpall, gzip, ftp e mutt ~~devono essere accessibili~~.		The dest path (default /srv/backup/data/postgresql/alldatabases/) must exists and be owned by postgres user, and the required commands (pg_dumpall, gzip, mail, mutt, ftp) must be installed (apt-get install mailutils mutt gzip ftp).



			= Script =
	<pre>		<pre>
	#!/bin/bash		#!/bin/bash
	#		#
	# NAME ~~pgBackupAll~~.sh		# NAME postgres_backup_all.sh
	# VERSION 1.1		# VERSION 1.2
	# REQUIRED pg_dumpall, mail, mutt~~, gzip~~, ftp		# REQUIRED pg_dumpall, gzip, mail, mutt , ftp
			#
			# Note:
			# you can use it with cron add something like the follows in the crontab
			#
			# 00 4 * * * root cd /tmp && run-parts --report --regex='^[a-zA-Z0-9_-]+\.sh$' /etc/cron/cron.daily_4h
	#		#
			# and add this file in the /etc/cron/cron.daily_4h path
			# - you should be able to send email from your system, for instance, configuring exim4
			# dpkg-reconfigure exim4-config # choose "internet site;"


Line 21:		Line 26:
	# Var		# Var

	BACKUP_DIR="/srv/backup/postgresql/alldatabases/";		BACKUP_DIR="/srv/backup/data/postgresql/alldatabases/";
	BACKUP_FILE="bkp-postgresql_alldatabases-`date +%Y.%m.%d_%H.%M.%S`-dump.sql.gz";		BACKUP_FILE="bkp-postgresql_alldatabases-`date +%Y.%m.%d_%H.%M.%S`-dump.sql.gz";
	BACKUP_COMMAND="pg_dumpall \| gzip > ${BACKUP_DIR}${BACKUP_FILE}";		BACKUP_COMMAND="pg_dumpall \| gzip > ${BACKUP_DIR}${BACKUP_FILE}";
Line 27:		Line 32:
	ROTATE_USER="postgres";		ROTATE_USER="postgres";
	ROTATE_DAYS="8";		ROTATE_DAYS="8";
			EMAIL="[WHO@MAILSERVER.WHR]";
			SUBJECT="[YOURDOMAIN.WHR] Postgresql backup";

	SEND_BY_FTP="y";		SEND_BY_FTP="false";
	FTP_HOST="[DESTDOMSIN.WHR]";		FTP_HOST="[DESTDOMSIN.WHR]";
	FTP_DIR="~~postgresql/alldatabases~~";		FTP_DIR="[REMOTEPATH]";
	FTP_USER="[USER]";		FTP_USER="[USER]";
	FTP_PASS="[PASS]";		FTP_PASS="[PASS]";

	SEND_BY_EMAIL="~~n";~~		SEND_BY_EMAIL="false";
	~~EMAIL="[WHO@MAILSERVER.WHR]";~~
	~~SUBJECT="[YOURDOMAIN.WHR] Postgresql backup~~";


Line 42:		Line 47:
	# Test		# Test

	if test ! `which mail`		if test ! -e "`which mail`"
	then		then
	echo "Command mail not found, exit.";		echo "Command mail not found, exit." >&2;
	exit 1;		exit 1;
	fi;		fi;

	if test ! `which pg_dumpall`		if test ! -e "`which pg_dumpall`"
	then		then
	echo "Command pg_dumpall not found, exit." \| mail -s "${SUBJECT} error." "${EMAIL}";		echo "Command pg_dumpall not found, exit." \| mail -s "${SUBJECT} error." "${EMAIL}";
Line 54:		Line 59:
	fi;		fi;

	if test ! `which gzip`		if test ! -e "`which gzip`"
	then		then
	echo "Command gzip not found, exit." \| mail -s "${SUBJECT} error." "${EMAIL}";		echo "Command gzip not found, exit." \| mail -s "${SUBJECT} error." "${EMAIL}";
Line 60:		Line 65:
	fi;		fi;

	if test ! `which ftp`		if test "${SEND_BY_FTP}" = "true" -a ! -e "`which ftp`"
	then		then
	echo "Command ftp not found, exit." \| mail -s "${SUBJECT} error." "${EMAIL}";		echo "Command ftp not found, exit." \| mail -s "${SUBJECT} error." "${EMAIL}";
Line 66:		Line 71:
	fi;		fi;

	if test ! `which mutt`		if test "${SEND_BY_EMAIL}" = "true" -a ! -e "`which mutt`"
	then		then
	echo "Command mutt not found, exit." \| mail -s "${SUBJECT} error." "${EMAIL}";		echo "Command mutt not found, exit." \| mail -s "${SUBJECT} error." "${EMAIL}";
Line 116:		Line 121:


	# Upload		# Upload to FTP if required

	if test ${SEND_BY_FTP} = "y";		if test "${SEND_BY_FTP}" = "true";
	then		then
	ftp -i -n ${FTP_HOST} << EOF		ftp -i -n ${FTP_HOST} << EOF
Line 136:		Line 141:


	# ~~Exit~~		# Send by mail if required, or send succes email

	if test ${SEND_BY_EMAIL} = "y";		if test "${SEND_BY_EMAIL}" = "true";
	then		then
	ls -l "${BACKUP_DIR}" \| mutt -n -e 'set copy=no' -s "${SUBJECT} success." -a "${BACKUP_DIR}${BACKUP_FILE}" -- "${EMAIL}";		ls -l "${BACKUP_DIR}" \| mutt -n -e 'set copy=no' -s "${SUBJECT} success." -a "${BACKUP_DIR}${BACKUP_FILE}" -- "${EMAIL}";

imported>T1t0 at 03:17, 8 July 2018

2018-07-08T03:17:36Z

← Older revision		Revision as of 03:17, 8 July 2018
Line 158:		Line 158:
	[[Category:backup]]		[[Category:backup]]
	[[Category:postgresql]]		[[Category:postgresql]]
			[[Category:to_translate]]

imported>T1t0 at 12:02, 1 July 2016

2016-07-01T12:02:26Z

← Older revision		Revision as of 12:02, 1 July 2016
Line 12:		Line 12:
	#!/bin/bash		#!/bin/bash
	#		#
	# pgBackupAll		# NAME pgBackupAll.sh
			# VERSION 1.1
			# REQUIRED pg_dumpall, mail, mutt, gzip, ftp
			#


Line 137:		Line 140:
	if test ${SEND_BY_EMAIL} = "y";		if test ${SEND_BY_EMAIL} = "y";
	then		then
	ls -l "${BACKUP_DIR}" \| mutt -s "${SUBJECT} success." -a "${BACKUP_DIR}${BACKUP_FILE}" -- "${EMAIL}";		ls -l "${BACKUP_DIR}" \| mutt -n -e 'set copy=no' -s "${SUBJECT} success." -a "${BACKUP_DIR}${BACKUP_FILE}" -- "${EMAIL}";
	exit 0;		exit 0;
	else		else

imported>T1t0 at 16:21, 25 October 2012

2012-10-25T16:21:32Z

← Older revision		Revision as of 16:21, 25 October 2012
Line 5:		Line 5:
	= Requirements =		= Requirements =

	Il percorso /srv/backup/postgresql/alldatabases/ deve esistere e essere di proprietà dell'utente postgres, e i comandi mail, pg_dumpall, gzip e mutt devono essere accessibili.		Il percorso /srv/backup/postgresql/alldatabases/ deve esistere e essere di proprietà dell'utente postgres, e i comandi mail, pg_dumpall, gzip, ftp e mutt devono essere accessibili.


Line 54:		Line 54:
	then		then
	echo "Command gzip not found, exit." \| mail -s "${SUBJECT} error." "${EMAIL}";		echo "Command gzip not found, exit." \| mail -s "${SUBJECT} error." "${EMAIL}";
			exit 1;
			fi;

			if test ! `which ftp`
			then
			echo "Command ftp not found, exit." \| mail -s "${SUBJECT} error." "${EMAIL}";
	exit 1;		exit 1;
	fi;		fi;

imported>T1t0 at 15:05, 25 October 2012

2012-10-25T15:05:00Z

← Older revision		Revision as of 15:05, 25 October 2012
Line 22:		Line 22:
	BACKUP_COMMAND="pg_dumpall \| gzip > ${BACKUP_DIR}${BACKUP_FILE}";		BACKUP_COMMAND="pg_dumpall \| gzip > ${BACKUP_DIR}${BACKUP_FILE}";
	BACKUP_USER="postgres";		BACKUP_USER="postgres";
	ROTATE_USER="~~backup~~";		ROTATE_USER="postgres";
	ROTATE_DAYS="8";		ROTATE_DAYS="8";

imported>T1t0: /* Requirements */

2012-10-25T15:01:47Z

Requirements

← Older revision		Revision as of 15:01, 25 October 2012
Line 5:		Line 5:
	= Requirements =		= Requirements =

	Il percorso /srv/backup/postgresql/alldatabases/ deve esistere e essere di proprietà dell'utente ~~backup~~, e i comandi mail, pg_dumpall, gzip e mutt devono essere accessibili.		Il percorso /srv/backup/postgresql/alldatabases/ deve esistere e essere di proprietà dell'utente postgres, e i comandi mail, pg_dumpall, gzip e mutt devono essere accessibili.

imported>T1t0: /* Requirements */

2012-10-25T14:58:12Z

Requirements

← Older revision		Revision as of 14:58, 25 October 2012
Line 108:		Line 108:

	# Upload		# Upload

	if test ${SEND_BY_FTP} = "y";		if test ${SEND_BY_FTP} = "y";
	then		then

imported>T1t0 at 14:53, 25 October 2012

2012-10-25T14:53:11Z

← Older revision		Revision as of 14:53, 25 October 2012
Line 5:		Line 5:
	= Requirements =		= Requirements =

	Il percorso /srv/backup/postgresql/ deve esistere e essere di proprietà dell'utente ~~postgres~~, e i comandi mail, pg_dumpall, gzip e mutt devono essere accessibili.		Il percorso /srv/backup/postgresql/alldatabases/ deve esistere e essere di proprietà dell'utente backup, e i comandi mail, pg_dumpall, gzip e mutt devono essere accessibili.


Line 18:		Line 18:
	# Var		# Var

	BACKUP_DIR="/srv/backup/postgresql/";		BACKUP_DIR="/srv/backup/postgresql/alldatabases/";
	BACKUP_FILE="bkp-postgresql_alldatabases-`date +%Y.%m.%d_%H.%M.%S`-dump.sql.gz";		BACKUP_FILE="bkp-postgresql_alldatabases-`date +%Y.%m.%d_%H.%M.%S`-dump.sql.gz";
	BACKUP_COMMAND="pg_dumpall \| gzip > ${BACKUP_DIR}${BACKUP_FILE}";		BACKUP_COMMAND="pg_dumpall \| gzip > ${BACKUP_DIR}${BACKUP_FILE}";
	BACKUP_USER="postgres";		BACKUP_USER="postgres";
	ROTATE_USER="~~postgres~~";		ROTATE_USER="backup";
	ROTATE_DAYS="7";		ROTATE_DAYS="8";

	EMAIL="~~email~~@~~server~~.~~whr~~";		SEND_BY_FTP="y";
	SUBJECT="~~domain~~.~~whr~~ Postgresql backup";		FTP_HOST="[DESTDOMSIN.WHR]";
			FTP_DIR="postgresql/alldatabases";
			FTP_USER="[USER]";
			FTP_PASS="[PASS]";

			SEND_BY_EMAIL="n";
			EMAIL="[WHO@MAILSERVER.WHR]";
			SUBJECT="[YOURDOMAIN.WHR] Postgresql backup";


Line 92:		Line 99:
	# Rotate		# Rotate

	if ! su - "${ROTATE_USER}" -s /bin/sh -c "ls -t ${BACKUP_DIR}*-dump.sql.gz \| tail -n +8 \| xargs -d '\n' rm -f";		if ! su - "${ROTATE_USER}" -s /bin/sh -c "ls -t ${BACKUP_DIR}*-dump.sql.gz \| tail -n +${ROTATE_DAYS} \| xargs -d '\n' rm -f";
	then		then
	echo "Rotate ${BACKUP_DIR} failure, exit." \| mail -s "${SUBJECT} error." "${EMAIL}";		echo "Rotate ${BACKUP_DIR} failure, exit." \| mail -s "${SUBJECT} error." "${EMAIL}";
Line 100:		Line 107:


	~~# Exit~~

	~~ls -l "${BACKUP_DIR}" \| mutt -s "${SUBJECT} success." -a "${BACKUP_DIR}${BACKUP_FILE}" -- "${EMAIL}";~~
	~~exit 0;~~



	~~# End~~

	~~</pre>~~



	~~E' facilmente modificabile per fare l'ulpload tramite ftp aggiungendo i comandi a seguire poco prima della label ''# Exit''~~

	~~<pre>~~
	# Upload		# Upload
			if test ${SEND_BY_FTP} = "y";
	ftp -i -n ${FTP_HOST} << EOF		then
			ftp -i -n ${FTP_HOST} << EOF
	user ${FTP_USER} ${FTP_PASS}		user ${FTP_USER} ${FTP_PASS}
	binary		binary
Line 125:		Line 117:
	EOF		EOF

	if test $? -ne 0;		if test $? -ne 0;
			then
			echo "Upload to ${FTP_HOST} failure, exit." \| mail -s "${SUBJECT} error." ${EMAIL};
			exit 1;
			fi;
			fi;



			# Exit

			if test ${SEND_BY_EMAIL} = "y";
	then		then
	~~echo~~ "~~Upload to~~ ${~~FTP_HOST~~} ~~failure, exit.~~" \| ~~mail~~ -s "${SUBJECT} ~~error~~." ${EMAIL};		ls -l "${BACKUP_DIR}" \| mutt -s "${SUBJECT} success." -a "${BACKUP_DIR}${BACKUP_FILE}" -- "${EMAIL}";
	exit 1;		exit 0;
			else
			ls -l "${BACKUP_DIR}" \| mail -s "${SUBJECT} success." "${EMAIL}";
	fi;		fi;



			# End

	</pre>		</pre>

imported>T1t0 at 14:12, 25 October 2012

2012-10-25T14:12:36Z

← Older revision		Revision as of 14:12, 25 October 2012
Line 127:		Line 127:
	if test $? -ne 0;		if test $? -ne 0;
	then		then
	echo "Upload to ${FTP_HOST} failure, exit." \| mail -s "${SUBJECT}		echo "Upload to ${FTP_HOST} failure, exit." \| mail -s "${SUBJECT} error." ${EMAIL};
	error." ${EMAIL};
	exit 1;		exit 1;
	fi;		fi;

imported>T1t0 at 16:08, 25 September 2012

2012-09-25T16:08:50Z

← Older revision		Revision as of 16:08, 25 September 2012
Line 1:		Line 1:
	Questo script fa un backup completo di PostgreSQL e lo invia all'email configurato. E' possibile restaurare il backup con le istruzioni dell'articolo [[postgresql\|PostgreSQL]].		Questo script fa un backup completo di PostgreSQL e lo invia all'email configurato. E' possibile restaurare il backup con le istruzioni dell'articolo [[postgresql\|PostgreSQL]].

	~~NOTA: il~~ percorso /srv/backup/postgresql/ deve esistere e essere di proprietà dell'utente postgres, e i comandi mail, pg_dumpall, gzip e mutt devono essere accessibili.

			= Requirements =

			Il percorso /srv/backup/postgresql/ deve esistere e essere di proprietà dell'utente postgres, e i comandi mail, pg_dumpall, gzip e mutt devono essere accessibili.