aboutsummaryrefslogtreecommitdiffhomepage
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
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.
-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)