Differential D1697 Diff 5703 site-modules/profile/templates/swh/pg_cluster_backup.sh.erb

Changeset View

Standalone View

	#!/bin/sh			#!/bin/sh

				TARGET_DIR=/srv/storage/space/postgres_secondary

	# banco has many slow CPU cores			# banco has many slow CPU cores
				# A full backup of the secondary cluster takes ~= 40 minutes with p=3 and c=1
	PARALLELISM=3			PARALLELISM=3
	COMPRESSION=1			COMPRESSION=1

	DATE=`/bin/date +%Y-%m-%d`			DATE=`/bin/date +%Y-%m-%d`

	export PGHOST=belvedere.internal.softwareheritage.org			export PGHOST=belvedere.internal.softwareheritage.org
	export PGPORT=5434			export PGPORT=5434
				ardumontUnsubmitted Not Done Inline Actions As a note, this could also be taken from the existing hiera configuration. ardumont: As a note, this could also be taken from the existing hiera configuration.
	export PGUSER=<%= @pg_backup_user %>			export PGUSER=<%= @pg_backup_user %>
	export PGPASSWORD=<%= @pg_backup_password %>			export PGPASSWORD=<%= @pg_backup_password %>

	DB_LIST=`/usr/bin/psql template1 -t -c \			DB_LIST=`/usr/bin/psql template1 -t -c \
	"SELECT datname from pg_database WHERE datname NOT IN ('postgres', 'template0', 'template1');"`			"SELECT datname from pg_database WHERE datname NOT IN ('postgres', 'template0', 'template1');"`

	cd ${TARGET_DIR}			cd ${TARGET_DIR}

	for database in ${DB_LIST}			for database in ${DB_LIST}
	do			do
	echo "dumping database ${database}"			echo "dumping database ${database}"
	/usr/bin/pg_dump -Fd -j ${PARALLELISM} -Z ${COMPRESSION} -f pgdump-${DATE}.${database} -d ${database} -w			/usr/bin/pg_dump -Fd -j ${PARALLELISM} -Z ${COMPRESSION} -f pgdump-${DATE}.${database} -d ${database} -w
	done			done