/
db_sync.sh
31 lines (24 loc) · 1.13 KB
/
db_sync.sh
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
#!/bin/bash
set -e
# if [ "$(id -u)" != "0" ]; then
# echo "This script must be run as root. Please enter your password for sudo." 1>&2
# sudo -H env PATH=$PATH INTERNAL_SUDO=TRUE "$0" "$@"
# exit 0;
# else
# if [ $INTERNAL_SUDO != "TRUE" ]; then
# echo "Please allow the script to 'sudo' internally, it has to be done a specific"
# echo "way to properly preserve some environment variables."
# exit 1
# fi
# fi
echo "Fetching db dump from remote server";
ssh client@ks1 'sudo -u postgres pg_dump --clean -d wlndb | xz' | pv -cN Db-Fetch-Progress > /media/Storage/Scripts/dbBak/db_dump_$(date +%Y-%m-%d).sql.xz
echo "Updating local database from dump file";
xz -d /media/Storage/Scripts/dbBak/db_dump_$(date +%Y-%m-%d).sql.xz -c | pv -c | ssh wlnuser@10.1.1.61 -t "psql -d wlndb"
echo "Synchronizing cover folder!"
rsync -rvvP client@ks1:/media/Storage/wlnupdates/covers /media/Storage/Scripts/_web_resource_backend/; &
echo "Done!"
# Run the server
#source flask/bin/activate
#python run.py all
#sudo -H -u herp -- bash -c "ssh client@ks1 'tar -c /media/Storage/wlnupdates/covers | xz' | pv -cN Cover-Fetch-Progress > .$