changeset 329:5014e2b0e5d3

adding script per Ryan at MCOECN
author aldrich@ssdt-ohio.org
date Mon, 13 Jan 2020 12:57:03 +0000
parents 1f0ff7540734
children 20f86a321306
files scripts/remote-backup-existing.sh
diffstat 1 files changed, 62 insertions(+), 0 deletions(-) [+]
line wrap: on
line diff
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/scripts/remote-backup-existing.sh	Mon Jan 13 12:57:03 2020 +0000
@@ -0,0 +1,62 @@
+#!/bin/bash
+# This is similar to the remote backup script except it uses an existing database backup
+# MCOECN personnel used the basic script and modified it 
+# The current directory is expected to contain a project configured
+# as with SSDT conventions for an application database.
+#
+
+# The file will also be placed on the specified remote target
+# The format of the output is a compressed pg_dump (sql) format.
+#
+#
+# This will send both usasdb and uspsdb,
+# along with the top level contents of the project directory
+#Environment variables can be used for REMOTE_BACKUP_TARGET and REMOTE_USERNAME
+remoteTarget=${1:-$REMOTE_BACKUP_TARGET}
+userName=${2:-$REMOTE_USERNAME}
+projectDir=${3:-$PWD}
+
+cd $projectDir
+
+source "${SSDT_SCRIPTS:-$(dirname "${BASH_SOURCE[0]}")}/.functions.sh"
+
+set -o pipefail
+
+project=$(composeGetProject)
+
+#If the project is empty, we want to stop the process because this is being run                                                                                                                      from the wrong directory
+
+if [ "$project" == "" ]; then
+
+   echo "no project available"
+
+   exit 1
+
+fi
+
+echo "project is $project"
+echo "Remote target is $remoteTarget"
+echo "Username is $userName"
+
+
+backupFile1=$(ls ./backup/*usasdb*.backup.gz | tail -n 1)
+backupFile2=$(ls ./backup/*uspsdb*.backup.gz | tail -n 1)
+
+
+#Create remote directory before scp
+host=`echo $userName@$remoteTarget | sed -e 's/:.*//'`
+
+target=`echo $remoteTarget | sed -e 's/.*://'`
+
+
+ssh $host mkdir -p $target/$project
+
+#SCP files
+#
+scp ${backupFile1}  ${backupFile2}  $userName@$remoteTarget/$project
+
+echo " "
+
+echo "completed sending ${backupFile1} and ${backupFile2} to ${remoteTarget}/${project} as user $userName"
+
+