summary refs log tree commit diff
path: root/docs/postgres.md
diff options
context:
space:
mode:
Diffstat (limited to '')
-rw-r--r--docs/postgres.md12
1 files changed, 12 insertions, 0 deletions
diff --git a/docs/postgres.md b/docs/postgres.md

index d06f0cda10..d51f54c722 100644 --- a/docs/postgres.md +++ b/docs/postgres.md
@@ -100,6 +100,18 @@ database: keepalives_count: 3 ``` +## Postgresql major version upgrades + +Postgres uses separate directories for database locations between major versions (typically `/var/lib/postgresql/<version>/main`). + +Therefore, it is recommended to stop Synapse and other services (MAS, etc) before upgrading Postgres major versions. + +It is also strongly recommended to [back up](./usage/administration/backups.md#database) your database beforehand to ensure no data loss arising from a failed upgrade. + +## Backups + +Don't forget to [back up](./usage/administration/backups.md#database) your database! + ## Tuning Postgres The default settings should be fine for most deployments. For larger