Merge remote-tracking branch 'origin/master' into staging

[mirror/dsa-puppet.git] / modules / postgres / files / backup_server / postgres-make-one-base-backup

diff --git a/modules/postgres/files/backup_server/postgres-make-one-base-backup b/modules/postgres/files/backup_server/postgres-make-one-base-backup
new file mode 100755 (executable)
index 0000000..df50652
--- /dev/null
+++ b/modules/postgres/files/backup_server/postgres-make-one-base-backup
@@ -0,0 +1,97 @@
+#!/bin/bash
+
+# run a bunch of full postgresql backups
+# vim:syn=sh:
+
+# Copyright 2014,2018 Peter Palfrader
+#
+# Permission is hereby granted, free of charge, to any person obtaining
+# a copy of this software and associated documentation files (the
+# "Software"), to deal in the Software without restriction, including
+# without limitation the rights to use, copy, modify, merge, publish,
+# distribute, sublicense, and/or sell copies of the Software, and to
+# permit persons to whom the Software is furnished to do so, subject to
+# the following conditions:
+#
+# The above copyright notice and this permission notice shall be
+# included in all copies or substantial portions of the Software.
+#
+# THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND,
+# EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF
+# MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND
+# NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE
+# LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION
+# OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION
+# WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.
+
+
+set -e
+set -u
+
+usage() {
+       echo "Usage: $0 <host> <port> <username> <clustername> <version>"
+}
+
+CONFFILE=/etc/nagios/dsa-check-backuppg.conf
+ROOTDIR=$(perl -MYAML -e "print YAML::LoadFile('$CONFFILE')->{'rootdir'}")
+if [ -z "$ROOTDIR" ]; then
+       echo >&2 "Could not learn rootdir from $CONFFILE"
+       exit 1
+fi
+
+if [ -t 0 ]; then
+       verbose=1
+else
+       verbose=0
+fi
+
+if [ "$verbose" -gt 0 ]; then
+       console="--progress --verbose"
+else
+       console=""
+fi
+
+if [ "${1:-}" = "-h" ] || [ "${1:-}" = "--help" ]; then
+       usage
+       exit 0
+fi
+
+export PGSSLMODE=verify-full
+export PGSSLROOTCERT=/etc/ssl/debian/certs/ca.crt
+
+date=$(date "+%Y%m%d-%H%M%S")
+thishost=$(hostname -f)
+
+if [ "$#" != 5 ]; then
+       usage >&2
+       exit 1
+fi
+
+host="$1"; shift
+port="$1"; shift
+username="$1"; shift
+cluster="$1"; shift
+version="$1"
+
+
+label="$thishost-$date-$host-$cluster-$version-backup"
+[ "$verbose" -gt 0 ] && echo "Doing $host:$port $version/$cluster: $label"
+
+target="$cluster.BASE.$label.tar.gz"
+tmp=$(tempfile -d "$ROOTDIR" -p "BASE-$host:$port-" -s ".tar.gz")
+trap "rm -f '$tmp'" EXIT
+
+/usr/lib/postgresql/"$version"/bin/pg_basebackup \
+       --format=tar \
+       --pgdata=- \
+       --label="$label" \
+       --host="$host" \
+       --port="$port" \
+       --username="$username" \
+       --no-password \
+       $console | pigz > "$tmp"
+if ! [ "${PIPESTATUS[0]}" -eq 0 ]; then
+       echo >&2 "pg_basebackup failed with exit code ${PIPESTATUS[0]}"
+       exit 1
+fi
+mv "$tmp" "$ROOTDIR/${host%%.*}/$target"