DOCS: backup restore improvements #332

ilja · 2022-12-03T18:35:30Z

ilja commented

2022-12-03 18:35:30 +00:00

Mostly add how to speed up restoration by adding activities_visibility_index later. Also some small other improvements.

This is based on what I did on a Pleroma instance. I assume the activities_visibility_index taking so long is still true for Akkoma, but can't really test because I don't have a big enough Akkoma DB yet 🙃

Mostly add how to speed up restoration by adding activities_visibility_index later. Also some small other improvements. This is based on what I did on a Pleroma instance. I assume the activities_visibility_index taking so long is still true for Akkoma, but can't really test because I don't have a big enough Akkoma DB yet 🙃

ilja added 1 commit 2022-12-03 18:35:31 +00:00

ci/woodpecker/pr/woodpecker Pipeline is pending Details

777e7cb11d backup restore improvements

Mostly add how to speed up restoration by adding activities_visibility_index later

floatingghost approved these changes 2022-12-03 22:47:42 +00:00

floatingghost left a comment

instructions looks good, thanks! just one very tiny small nitpick

docs/docs/administration/backup.md Outdated

					
				@ -28,1 +30,3 @@

				[^1]: Prefix with `MIX_ENV=prod` to run it using the production config file.

				[¹]: We assume the database name and user are both "akkoma". If not, you can find the correct name in your config files.  

				[²]: You can recreate the `config/setup_db.psql` by running the `mix pleroma.instance gen` task again. You can ignore most of the questions, but make the database user, name, and password the same as found in your backed up config file. This will also create a new `config/generated_config.exs` file which you may delete as it is not needed.  

				[³]: `pg_restore` will add data before adding indexes. The indexes are added in alphabeticall order. There's one index, `activities_visibility_index` which may take a long time because it can't make use of an index that's only added later. You can significantly speed up restoration by skipping this index and add it afterwards. For that, you can do the following (we assume the akkoma.pgdump is in the directory you're running the commands):