summary refs log tree commit diff
path: root/develop/postgres.html
diff options
context:
space:
mode:
authorreivilibre <reivilibre@users.noreply.github.com>2022-07-07 10:08:48 +0000
committerreivilibre <reivilibre@users.noreply.github.com>2022-07-07 10:08:48 +0000
commit79c12e8ee62b5654c27d763b0446165cac98b606 (patch)
treedc35b3e1f8a823135cd8a90d93621450e19e7e8f /develop/postgres.html
parentdeploy: dcc7873700da4a818e84c44c6190525d39a854cb (diff)
downloadsynapse-79c12e8ee62b5654c27d763b0446165cac98b606.tar.xz
deploy: fb7d24ab6de870ab21f83d49d9f1db569eff4b56
Diffstat (limited to 'develop/postgres.html')
-rw-r--r--develop/postgres.html7
1 files changed, 7 insertions, 0 deletions
diff --git a/develop/postgres.html b/develop/postgres.html

index 7f70667c19..780604462a 100644 --- a/develop/postgres.html +++ b/develop/postgres.html
@@ -267,6 +267,13 @@ of the SQLite database file. This makes it safe to repeat step 1 if there was a delay between taking the previous snapshot and being ready to do step 2.</p> <p>It is safe to at any time kill the port script and restart it.</p> +<p>However, under no circumstances should the SQLite database be <code>VACUUM</code>ed between +multiple runs of the script. Doing so can lead to an inconsistent copy of your database +into Postgres. +To avoid accidental error, the script will check that SQLite's <code>auto_vacuum</code> mechanism +is disabled, but the script is not able to protect against a manual <code>VACUUM</code> operation +performed either by the administrator or by any automated task that the administrator +may have configured.</p> <p>Note that the database may take up significantly more (25% - 100% more) space on disk after porting to Postgres.</p> <h3 id="using-the-port-script"><a class="header" href="#using-the-port-script">Using the port script</a></h3>