diff options
| author | reivilibre <oliverw@matrix.org> | 2023-12-04 14:57:28 +0000 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2023-12-04 14:57:28 +0000 |
| commit | 51e4e35653f98c3f61222fbdbdb1dcb8864f7fca (patch) | |
| tree | b732cd0784e3540ddc03c9af5ba034a79d7d8009 /changelog.d | |
| parent | Switch UNIX socket paths to /run, and add a UNIX socket example for HAProxy (... (diff) | |
| download | synapse-51e4e35653f98c3f61222fbdbdb1dcb8864f7fca.tar.xz | |
Add a Postgres `REPLICA IDENTITY` to tables that do not have an implicit one. This should allow use of Postgres logical replication. (take 2, now with no added deadlocks!) (#16658)
* Add `ALTER TABLE ... REPLICA IDENTITY ...` for individual tables We can't combine them into one file as it makes it likely to hit a deadlock if Synapse is running, as it only takes one other transaction to access two tables in a different order to the schema delta. * Add notes * Newsfile Signed-off-by: Olivier Wilkinson (reivilibre) <oliverw@matrix.org> * Re-introduce REPLICA IDENTITY test --------- Signed-off-by: Olivier Wilkinson (reivilibre) <oliverw@matrix.org>
Diffstat (limited to 'changelog.d')
| -rw-r--r-- | changelog.d/16658.misc | 1 |
1 files changed, 1 insertions, 0 deletions
diff --git a/changelog.d/16658.misc b/changelog.d/16658.misc new file mode 100644 index 0000000000..baee042f2f --- /dev/null +++ b/changelog.d/16658.misc @@ -0,0 +1 @@ +Add a Postgres `REPLICA IDENTITY` to tables that do not have an implicit one. This should allow use of Postgres logical replication. \ No newline at end of file |