aboutsummaryrefslogtreecommitdiffhomepage
diff options
context:
space:
mode:
authorJosh Morel <morel.josh@hotmail.com>2018-07-29 13:23:30 -0400
committerChocobozzz <me@florianbigard.com>2018-07-30 16:38:31 +0200
commit43c4c63937b63ed1f41b17f4cc8fe652a6d010fc (patch)
treed2984aa4b817e316e6a3df8cffa84daa53d99470
parent05882211077a30e27ebbb79baff0cf8fb87b7ae2 (diff)
downloadPeerTube-43c4c63937b63ed1f41b17f4cc8fe652a6d010fc.tar.gz
PeerTube-43c4c63937b63ed1f41b17f4cc8fe652a6d010fc.tar.zst
PeerTube-43c4c63937b63ed1f41b17f4cc8fe652a6d010fc.zip
fix pg_restore command for post-migrations
also avoid peertube db login for pg_dump command
-rw-r--r--support/doc/production.md6
1 files changed, 3 insertions, 3 deletions
diff --git a/support/doc/production.md b/support/doc/production.md
index 1d418ed66..eb72985a3 100644
--- a/support/doc/production.md
+++ b/support/doc/production.md
@@ -221,7 +221,7 @@ Make a SQL backup
221``` 221```
222$ SQL_BACKUP_PATH="backup/sql-peertube_prod-$(date -Im).bak" && \ 222$ SQL_BACKUP_PATH="backup/sql-peertube_prod-$(date -Im).bak" && \
223 cd /var/www/peertube && sudo -u peertube mkdir -p backup && \ 223 cd /var/www/peertube && sudo -u peertube mkdir -p backup && \
224 sudo pg_dump -U peertube -W -h localhost -F c peertube_prod -f "$SQL_BACKUP_PATH" 224 sudo -u postgres pg_dump -F c peertube_prod | sudo -u peertube tee "$SQL_BACKUP_PATH" >/dev/null
225``` 225```
226 226
227Fetch the latest tagged version of Peertube: 227Fetch the latest tagged version of Peertube:
@@ -305,8 +305,8 @@ Change `peertube-latest` destination to the previous version and restore your SQ
305 305
306``` 306```
307$ OLD_VERSION="v0.42.42" && SQL_BACKUP_PATH="backup/sql-peertube_prod-2018-01-19T10:18+01:00.bak" && \ 307$ OLD_VERSION="v0.42.42" && SQL_BACKUP_PATH="backup/sql-peertube_prod-2018-01-19T10:18+01:00.bak" && \
308 cd /var/www/peertube && unlink ./peertube-latest && \ 308 cd /var/www/peertube && sudo -u peertube unlink ./peertube-latest && \
309 sudo -u peertube ln -s "versions/peertube-$OLD_VERSION" peertube-latest && \ 309 sudo -u peertube ln -s "versions/peertube-$OLD_VERSION" peertube-latest && \
310 pg_restore -U peertube -W -h localhost -c -d peertube_prod "$SQL_BACKUP_PATH" 310 sudo -u postgres pg_restore -c -C -d postgres "$SQL_BACKUP_PATH" && \
311 sudo systemctl restart peertube 311 sudo systemctl restart peertube
312``` 312```