#!/bin/bash # run a bunch of full postgresql backups # vim:syn=sh: # Copyright 2014 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 if [ -t 0 ]; then verbose=1 else verbose=0 fi if [ "${1:-}" = "-h" ] || [ "${1:-}" = "--help" ]; then echo "Usage: $0 [:]" exit 0 fi if [ "$#" -gt 0 ]; then forcehostport="$1" shift else forcehostport="" fi while read host port username cluster version; do [ "${host#\#}" = "$host" ] || continue [ -z "$host" ] && continue if [ -n "$forcehostport" ] && [ "$forcehostport" != "$host:$port" ]; then [ "$verbose" -gt 0 ] && echo "Skipping $host:$port $version/$cluster." continue fi /usr/local/bin/postgres-make-one-base-backup "$host" "$port" "$username" "$cluster" "$version" done << EOF seger.debian.org 5432 debian-backup dak 9.6 bmdb1.debian.org 5435 debian-backup main 9.6 bmdb1.debian.org 5436 debian-backup wannabuild 9.6 bmdb1.debian.org 5440 debian-backup debsources 9.6 fasolo.debian.org 5433 debian-backup dak 9.6 sibelius.debian.org 5433 debian-backup snapshot 9.4 <%- if @hostname != "backuphost" -%> moszumanska.debian.org 5432 debian-backup main 9.1 <%- end -%> # # puppet notice: this is just a partial file. The tail EOF comes # from a different concat fragment