annotate scripts/remote-backup-existing.sh @ 509:cd2fb1609cab

USASR-5154 list files
author belknapSSDT <zach.belknap@mcoecn.org>
date Fri, 29 Sep 2023 12:57:14 -0400
parents dfae5707657d
children
rev   line source
329
5014e2b0e5d3 adding script per Ryan at MCOECN
aldrich@ssdt-ohio.org
parents:
diff changeset
1 #!/bin/bash
5014e2b0e5d3 adding script per Ryan at MCOECN
aldrich@ssdt-ohio.org
parents:
diff changeset
2 # This is similar to the remote backup script except it uses an existing database backup
5014e2b0e5d3 adding script per Ryan at MCOECN
aldrich@ssdt-ohio.org
parents:
diff changeset
3 # MCOECN personnel used the basic script and modified it
5014e2b0e5d3 adding script per Ryan at MCOECN
aldrich@ssdt-ohio.org
parents:
diff changeset
4 # The current directory is expected to contain a project configured
5014e2b0e5d3 adding script per Ryan at MCOECN
aldrich@ssdt-ohio.org
parents:
diff changeset
5 # as with SSDT conventions for an application database.
5014e2b0e5d3 adding script per Ryan at MCOECN
aldrich@ssdt-ohio.org
parents:
diff changeset
6 #
5014e2b0e5d3 adding script per Ryan at MCOECN
aldrich@ssdt-ohio.org
parents:
diff changeset
7 # The file will also be placed on the specified remote target
5014e2b0e5d3 adding script per Ryan at MCOECN
aldrich@ssdt-ohio.org
parents:
diff changeset
8 # The format of the output is a compressed pg_dump (sql) format.
332
aafdbfc9623b testing
aldrich
parents: 330
diff changeset
9 # Still needs tweaking
334
ea21046c5e57 testing
aldrich
parents: 332
diff changeset
10 #
336
dfae5707657d testing remote
aldrich
parents: 335
diff changeset
11 # testing changes additional
329
5014e2b0e5d3 adding script per Ryan at MCOECN
aldrich@ssdt-ohio.org
parents:
diff changeset
12 # This will send both usasdb and uspsdb,
5014e2b0e5d3 adding script per Ryan at MCOECN
aldrich@ssdt-ohio.org
parents:
diff changeset
13 # along with the top level contents of the project directory
5014e2b0e5d3 adding script per Ryan at MCOECN
aldrich@ssdt-ohio.org
parents:
diff changeset
14 #Environment variables can be used for REMOTE_BACKUP_TARGET and REMOTE_USERNAME
5014e2b0e5d3 adding script per Ryan at MCOECN
aldrich@ssdt-ohio.org
parents:
diff changeset
15 remoteTarget=${1:-$REMOTE_BACKUP_TARGET}
5014e2b0e5d3 adding script per Ryan at MCOECN
aldrich@ssdt-ohio.org
parents:
diff changeset
16 userName=${2:-$REMOTE_USERNAME}