aboutsummaryrefslogtreecommitdiffhomepage
path: root/scripts/upgrade.sh
diff options
context:
space:
mode:
authorLuc Didry <luc@framasoft.org>2018-10-11 10:34:44 +0200
committerChocobozzz <me@florianbigard.com>2018-10-11 13:31:57 +0200
commitd9d1989b62bed7eeed987d6def0ac8ccd6032c5e (patch)
treedd98f17807edccab23597eeef3507eb8ff487ee5 /scripts/upgrade.sh
parent71e318b4fe66175d03c7c82357d60062eb68af81 (diff)
downloadPeerTube-d9d1989b62bed7eeed987d6def0ac8ccd6032c5e.tar.gz
PeerTube-d9d1989b62bed7eeed987d6def0ac8ccd6032c5e.tar.zst
PeerTube-d9d1989b62bed7eeed987d6def0ac8ccd6032c5e.zip
Use DB informations from config/production.yaml in upgrade script
Avoid hardcoded values in upgrade script. Avoid asking for DB password. Uses python (usually installed on your system, even with minimal installations) and some of its standard lib modules.
Diffstat (limited to 'scripts/upgrade.sh')
-rwxr-xr-xscripts/upgrade.sh7
1 files changed, 6 insertions, 1 deletions
diff --git a/scripts/upgrade.sh b/scripts/upgrade.sh
index b29615fb1..c70b3b42a 100755
--- a/scripts/upgrade.sh
+++ b/scripts/upgrade.sh
@@ -23,8 +23,13 @@ fi
23 23
24# Backup database 24# Backup database
25SQL_BACKUP_PATH="$PEERTUBE_PATH/backup/sql-peertube_prod-$(date +"%Y%m%d-%H%M").bak" 25SQL_BACKUP_PATH="$PEERTUBE_PATH/backup/sql-peertube_prod-$(date +"%Y%m%d-%H%M").bak"
26DB_USER=$(node -e "console.log(require('js-yaml').safeLoad(fs.readFileSync('$PEERTUBE_PATH/config/production.yaml', 'utf8'))['database']['username'])")
27DB_PASS=$(node -e "console.log(require('js-yaml').safeLoad(fs.readFileSync('$PEERTUBE_PATH/config/production.yaml', 'utf8'))['database']['password'])")
28DB_HOST=$(node -e "console.log(require('js-yaml').safeLoad(fs.readFileSync('$PEERTUBE_PATH/config/production.yaml', 'utf8'))['database']['hostname'])")
29DB_SUFFIX=$(node -e "console.log(require('js-yaml').safeLoad(fs.readFileSync('$PEERTUBE_PATH/config/production.yaml', 'utf8'))['database']['suffix'])")
26mkdir -p $PEERTUBE_PATH/backup 30mkdir -p $PEERTUBE_PATH/backup
27pg_dump -U peertube -W -h localhost -F c peertube_prod -f "$SQL_BACKUP_PATH" 31
32PGPASSWORD=$DB_PASS pg_dump -U $DB_USER -h $DB_HOST -F c "peertube${DB_SUFFIX}" -f "$SQL_BACKUP_PATH"
28 33
29# If there is a pre-release, give the user a choice which one to install. 34# If there is a pre-release, give the user a choice which one to install.
30RELEASE_VERSION=$(curl -s https://api.github.com/repos/chocobozzz/peertube/releases/latest | grep tag_name | cut -d '"' -f 4) 35RELEASE_VERSION=$(curl -s https://api.github.com/repos/chocobozzz/peertube/releases/latest | grep tag_name | cut -d '"' -f 4)