infra-ansible/scripts/public-db-copy

#!/bin/bash

#
# A simple script to copy database dumps over to public space on batcave01
# Only the most recent dump is published
#

# We need to set -e so that `chronic` will make the right decision about alerting
# us to any failures.
set -e

# This changes really often ;)
bkup_domain=rdu3.fedoraproject.org

scp db-datanommer02.${bkup_domain}:/backups/datanommer2-$(date +%F).dump.xz \
    /srv/web/infra/db-dumps/datanommer2.dump.xz
# Always yesterday because the export needs to ensure a full day's worth of data
scp db-datanommer02.${bkup_domain}:/backups/datanommer-incremental/$(date -d 'yesterday' +%F)-datanommer-incremental-csv.tar \
    /srv/web/infra/db-dumps/datanommer-incremental/

scp db-koji01.${bkup_domain}:/backups/koji-$(date +%F).dump.xz \
    /srv/web/infra/db-dumps/koji.dump.xz

scp db01.${bkup_domain}:/backups/koschei-$(date +%F).dump.xz \
    /srv/web/infra/db-dumps/koschei.dump.xz
scp db01.${bkup_domain}:/backups/bodhi2-$(date +%F).dump.xz \
    /srv/web/infra/db-dumps/bodhi2.dump.xz
scp db01.${bkup_domain}:/backups/anitya-public-$(date +%F).dump.xz \
    /srv/web/infra/db-dumps/anitya.dump.xz
scp db01.${bkup_domain}:/backups/mailman-$(date +%F).dump.xz \
    /srv/web/infra/db-dumps/mailman.dump.xz
scp db01.${bkup_domain}:/backups/hyperkitty-$(date +%F).dump.xz \
    /srv/web/infra/db-dumps/hyperkitty.dump.xz
scp db01.${bkup_domain}:/backups/resultsdb-$(date +%F).dump.xz \
    /srv/web/infra/db-dumps/resultsdb.dump.xz
scp db01.${bkup_domain}:/backups/waiverdb-$(date +%F).dump.xz \
    /srv/web/infra/db-dumps/waiverdb.dump.xz
scp db01.${bkup_domain}:/backups/tahrir-$(date +%F).dump.xz \
    /srv/web/infra/db-dumps/tahrir.dump.xz