From c7a9f34f7229529ea726de13867f87c0a8dd3007 Mon Sep 17 00:00:00 2001 From: Chocobozzz Date: Fri, 19 Jan 2018 10:30:35 +0100 Subject: Add SQL backup/restore commands in production guide --- support/doc/production.md | 20 ++++++++++++++++++++ 1 file changed, 20 insertions(+) (limited to 'support') diff --git a/support/doc/production.md b/support/doc/production.md index de5d67b4e..0bdc36da1 100644 --- a/support/doc/production.md +++ b/support/doc/production.md @@ -239,6 +239,16 @@ $ cd /home/peertube/peertube-latest && NODE_ENV=production npm run reset-passwor ## Upgrade +Make a SQL backup: + +``` +$ SQL_BACKUP_PATH="backup/sql-peertube_prod-$(date -Im).bak" && \ + cd /home/peertube && sudo -u peertube mkdir -p backup && \ + sudo pg_dump -U peertube -W -h localhost -F c peertube_prod -f "$SQL_BACKUP_PATH" +``` + +Upgrade PeerTube: + ``` $ VERSION=$(curl -s https://api.github.com/repos/chocobozzz/peertube/releases/latest | grep tag_name | cut -d '"' -f 4) && \ cd /home/peertube/versions && \ @@ -248,3 +258,13 @@ $ VERSION=$(curl -s https://api.github.com/repos/chocobozzz/peertube/releases/la cd ./peertube-latest && sudo -u peertube yarn install --production --pure-lockfile && \ sudo systemctl restart peertube ``` + +Things went wrong? Change `peertube-latest` destination to the previous version and restore your SQL backup: + +``` +$ OLD_VERSION="v0.42.42" && SQL_BACKUP_PATH="backup/sql-peertube_prod-2018-01-19T10:18+01:00.bak" && \ + cd /home/peertube && rm ./peertube-latest && \ + sudo -u peertube ln -s "versions/peertube-$OLD_VERSION" peertube-latest && \ + pg_restore -U peertube -c -d peertube_prod "$SQL_BACKUP_PATH" + sudo systemctl restart peertube +``` -- cgit v1.2.3