diff options
| author | Josh Morel <morel.josh@hotmail.com> | 2018-07-29 13:23:30 -0400 |
|---|---|---|
| committer | Chocobozzz <me@florianbigard.com> | 2018-07-30 16:38:31 +0200 |
| commit | 43c4c63937b63ed1f41b17f4cc8fe652a6d010fc (patch) | |
| tree | d2984aa4b817e316e6a3df8cffa84daa53d99470 /support/doc | |
| parent | 05882211077a30e27ebbb79baff0cf8fb87b7ae2 (diff) | |
| download | PeerTube-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
Diffstat (limited to 'support/doc')
| -rw-r--r-- | support/doc/production.md | 6 |
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 | ||
| 227 | Fetch the latest tagged version of Peertube: | 227 | Fetch 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 | ``` |