aboutsummaryrefslogtreecommitdiffhomepage
path: root/support
diff options
context:
space:
mode:
authorChocobozzz <me@florianbigard.com>2018-01-19 10:30:35 +0100
committerChocobozzz <me@florianbigard.com>2018-01-19 10:30:35 +0100
commitc7a9f34f7229529ea726de13867f87c0a8dd3007 (patch)
tree853ce995de1c5629ab0fb0916ab95438b9acaca7 /support
parentadcaf1a8671b85f62f77058edd50fe146cb41c8e (diff)
downloadPeerTube-c7a9f34f7229529ea726de13867f87c0a8dd3007.tar.gz
PeerTube-c7a9f34f7229529ea726de13867f87c0a8dd3007.tar.zst
PeerTube-c7a9f34f7229529ea726de13867f87c0a8dd3007.zip
Add SQL backup/restore commands in production guide
Diffstat (limited to 'support')
-rw-r--r--support/doc/production.md20
1 files changed, 20 insertions, 0 deletions
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
239 239
240## Upgrade 240## Upgrade
241 241
242Make a SQL backup:
243
244```
245$ SQL_BACKUP_PATH="backup/sql-peertube_prod-$(date -Im).bak" && \
246 cd /home/peertube && sudo -u peertube mkdir -p backup && \
247 sudo pg_dump -U peertube -W -h localhost -F c peertube_prod -f "$SQL_BACKUP_PATH"
248```
249
250Upgrade PeerTube:
251
242``` 252```
243$ VERSION=$(curl -s https://api.github.com/repos/chocobozzz/peertube/releases/latest | grep tag_name | cut -d '"' -f 4) && \ 253$ VERSION=$(curl -s https://api.github.com/repos/chocobozzz/peertube/releases/latest | grep tag_name | cut -d '"' -f 4) && \
244 cd /home/peertube/versions && \ 254 cd /home/peertube/versions && \
@@ -248,3 +258,13 @@ $ VERSION=$(curl -s https://api.github.com/repos/chocobozzz/peertube/releases/la
248 cd ./peertube-latest && sudo -u peertube yarn install --production --pure-lockfile && \ 258 cd ./peertube-latest && sudo -u peertube yarn install --production --pure-lockfile && \
249 sudo systemctl restart peertube 259 sudo systemctl restart peertube
250``` 260```
261
262Things went wrong? Change `peertube-latest` destination to the previous version and restore your SQL backup:
263
264```
265$ OLD_VERSION="v0.42.42" && SQL_BACKUP_PATH="backup/sql-peertube_prod-2018-01-19T10:18+01:00.bak" && \
266 cd /home/peertube && rm ./peertube-latest && \
267 sudo -u peertube ln -s "versions/peertube-$OLD_VERSION" peertube-latest && \
268 pg_restore -U peertube -c -d peertube_prod "$SQL_BACKUP_PATH"
269 sudo systemctl restart peertube
270```