summaryrefslogtreecommitdiff
path: root/docs/administration/backup.md
diff options
context:
space:
mode:
authorAlexander Strizhakov <alex.strizhakov@gmail.com>2020-03-12 18:31:10 +0300
committerAlexander Strizhakov <alex.strizhakov@gmail.com>2020-03-12 18:31:10 +0300
commit39ed608b13f9204e0503311c7394934b01501ab8 (patch)
tree34250ed1c719224a3522fd1a841bbd0a360e1245 /docs/administration/backup.md
parent1306b92997dc6e76e5d617d529dbc229d5aee200 (diff)
parent00d17520314e3591caaa7ab4ca39c6227a6bdf15 (diff)
downloadpleroma-39ed608b13f9204e0503311c7394934b01501ab8.tar.gz
pleroma-39ed608b13f9204e0503311c7394934b01501ab8.zip
Merge branch 'develop' into gun
Diffstat (limited to 'docs/administration/backup.md')
-rw-r--r--docs/administration/backup.md5
1 files changed, 2 insertions, 3 deletions
diff --git a/docs/administration/backup.md b/docs/administration/backup.md
index 692aa7368..be57bf74a 100644
--- a/docs/administration/backup.md
+++ b/docs/administration/backup.md
@@ -18,9 +18,8 @@
6. Run `sudo -Hu postgres pg_restore -d <pleroma_db> -v -1 </path/to/backup_location/pleroma.pgdump>`
7. If you installed a newer Pleroma version, you should run `mix ecto.migrate`[^1]. This task performs database migrations, if there were any.
8. Restart the Pleroma service.
-9. After you've restarted Pleroma, you will notice that postgres will take up more cpu resources than usual. A lot in fact. To fix this you must do a VACUUM ANLAYZE. This can also be done while the instance is still running like so:
- $ sudo -u postgres psql pleroma_database_name
- pleroma=# VACUUM ANALYZE;
+9. Run `sudo -Hu postgres vacuumdb --all --analyze-in-stages`. This will quickly generate the statistics so that postgres can properly plan queries.
+
[^1]: Prefix with `MIX_ENV=prod` to run it using the production config file.
## Remove