29b62f77a5
Upgrade Postgres (v16.0-5 -> v16.0-6) - adds auto-tuning
2023-10-18 08:24:52 +03:00
7e54417fca
Update maintenance-postgres.md
...
no postgres 16 support with borg, 15 works.
2023-10-11 11:26:42 +02:00
8c4234d52a
Add note about ANALYZE after Postgres database importing
2023-09-26 17:52:01 +03:00
2b49ae79ca
Use just for Postgres maintenance command examples
2023-03-16 11:23:22 +02:00
9ab2a72e86
More matrix_postgres -> devture_postgres changes
...
Related to https://github.com/spantaleev/matrix-docker-ansible-deploy/pull/2319
2022-12-06 10:12:31 +02:00
7b43ef34b7
Remove more hardcoded matrix-postgres references
2022-11-27 09:16:18 +02:00
40e8ef0c70
Do not tell people to use latest Borgmatic - it won't help with Postgres v15
...
Related to https://github.com/spantaleev/matrix-docker-ansible-deploy/pull/2259#issuecomment-1312737960
2022-11-16 11:50:05 +02:00
f5a09f30b7
Update maintenance-postgres.md
2022-11-12 23:48:57 +01:00
b12cdbd99d
Update maintenance-postgres.md
2022-11-12 23:40:46 +01:00
adbc09f152
warn users about upgrading to pg15 when using borg
2022-11-12 11:20:43 +01:00
1b41e9c7dd
Update PostgreSQL Maintenance page
...
Added a mid-sized VPS configuration with configuration changes to the PostgreSQL database config.
Deleted single quotes in one of the examples to unify the examples
2021-05-26 13:50:35 +02:00
719ecb03a8
Add note about pgtune.leopard.in.ua
2021-05-26 09:55:40 +03:00
37c089bb96
Minor docs improvements
2021-04-05 11:13:45 +03:00
c86cc11386
Add some advice about tuning PostgreSQL
2021-04-02 19:26:41 -05:00
ca22355910
Update backup docs a bit
2021-02-22 08:36:42 +02:00
53869ac14a
recommend a better way of backing up postgres
...
don't spawn an extra container
run pg_dumpall within matrix-postgres instead, ensures correct version
store under /matrix so a backup of the folder will contain a DB dump
use absolute paths just in case something in the ENV is messed up
2021-02-21 21:38:20 +01:00
d3aea8f4b8
Update Postgres backup docs for ARM32
2021-01-22 14:04:36 +02:00
95346f3117
Reorganize Postgres access (breaking change)
...
In short, this makes Synapse a 2nd class citizen,
preparing for a future where it's just one-of-many homeserver software
options.
We also no longer have a default Postgres superuser password,
which improves security.
The changelog explains more as to why this was done
and how to proceed from here.
2021-01-22 13:26:12 +02:00
d7dba0a2ff
Update some Docker image references
2021-01-08 16:37:39 +02:00
0a977ce113
Fix incorrect path in docs
2021-01-05 22:59:35 +02:00
ee8dd44837
Use up-to-date PostgreSQL container version for backups.
2020-10-02 22:53:06 +02:00
e3dca2f66f
Try to avoid Docker logs growing too much for one-off containers
...
We recently had a report of the Postgres backup container's log file
growing the size of /var/lib/docker until it ran out of disk space.
Trying to prevent similar problems in the future.
2020-09-01 09:03:48 +03:00
daf13107a0
Add support for rust-synapse-compress-state
2020-08-21 13:53:39 +03:00
65963f694a
Use Postgres 12.1 when creating a backup
2020-01-20 16:33:47 -06:00
e32aaacaa7
Make gzipped SQL dumps by default during --upgrade-postgres
2019-10-05 11:42:08 +03:00
29526e7bb1
Add support for backing up / importing all Postgres databases/users
2019-10-05 11:42:08 +03:00
9c438a3870
Add support for Postgres v12
2019-10-04 08:51:36 +03:00
76862f4f2a
Suggest running start tag after janitor and Postgres vacuum
...
We do restart Synapse explicitly, but some other services
(bridges, matrix-corporal, ..) may not restart sometimes.
It's best to restart all services explicitly.
2019-07-08 11:09:23 +03:00
0ca21d80d7
Add Synapse Maintenance docs and synapse-janitor integration
2019-07-08 09:38:36 +03:00
70b2f07fec
Add PostgreSQL backup information
2019-02-09 14:36:47 +02:00
Slavi Pantaleev