From 44377f5ac05ff4e95f440f5704805b87a37e3327 Mon Sep 17 00:00:00 2001 From: David Robertson Date: Tue, 5 Dec 2023 16:07:42 +0000 Subject: Revert postgres logical replication deltaas This reverts two commits: 0bb8e418a41c6f583ca9d705b400e37e2308a534 "Fix postgres schema after dropping old tables (#16730)" and 51e4e35653f98c3f61222fbdbdb1dcb8864f7fca "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)" and also amends the changelog. --- .../delta/83/10_replica_identity_applied_module_schemas.sql.postgres | 1 - .../delta/83/10_replica_identity_applied_schema_deltas.sql.postgres | 1 - .../common/delta/83/10_replica_identity_background_updates.sql.postgres | 1 - .../delta/83/10_replica_identity_schema_compat_version.sql.postgres | 1 - .../common/delta/83/10_replica_identity_schema_version.sql.postgres | 1 - 5 files changed, 5 deletions(-) delete mode 100644 synapse/storage/schema/common/delta/83/10_replica_identity_applied_module_schemas.sql.postgres delete mode 100644 synapse/storage/schema/common/delta/83/10_replica_identity_applied_schema_deltas.sql.postgres delete mode 100644 synapse/storage/schema/common/delta/83/10_replica_identity_background_updates.sql.postgres delete mode 100644 synapse/storage/schema/common/delta/83/10_replica_identity_schema_compat_version.sql.postgres delete mode 100644 synapse/storage/schema/common/delta/83/10_replica_identity_schema_version.sql.postgres (limited to 'synapse/storage/schema/common') diff --git a/synapse/storage/schema/common/delta/83/10_replica_identity_applied_module_schemas.sql.postgres b/synapse/storage/schema/common/delta/83/10_replica_identity_applied_module_schemas.sql.postgres deleted file mode 100644 index 57c35b6430..0000000000 --- a/synapse/storage/schema/common/delta/83/10_replica_identity_applied_module_schemas.sql.postgres +++ /dev/null @@ -1 +0,0 @@ -ALTER TABLE applied_module_schemas REPLICA IDENTITY USING INDEX applied_module_schemas_module_name_file_key; diff --git a/synapse/storage/schema/common/delta/83/10_replica_identity_applied_schema_deltas.sql.postgres b/synapse/storage/schema/common/delta/83/10_replica_identity_applied_schema_deltas.sql.postgres deleted file mode 100644 index 1426f9a9e4..0000000000 --- a/synapse/storage/schema/common/delta/83/10_replica_identity_applied_schema_deltas.sql.postgres +++ /dev/null @@ -1 +0,0 @@ -ALTER TABLE applied_schema_deltas REPLICA IDENTITY USING INDEX applied_schema_deltas_version_file_key; diff --git a/synapse/storage/schema/common/delta/83/10_replica_identity_background_updates.sql.postgres b/synapse/storage/schema/common/delta/83/10_replica_identity_background_updates.sql.postgres deleted file mode 100644 index f04937b3db..0000000000 --- a/synapse/storage/schema/common/delta/83/10_replica_identity_background_updates.sql.postgres +++ /dev/null @@ -1 +0,0 @@ -ALTER TABLE background_updates REPLICA IDENTITY USING INDEX background_updates_uniqueness; diff --git a/synapse/storage/schema/common/delta/83/10_replica_identity_schema_compat_version.sql.postgres b/synapse/storage/schema/common/delta/83/10_replica_identity_schema_compat_version.sql.postgres deleted file mode 100644 index e3a6f7ca4f..0000000000 --- a/synapse/storage/schema/common/delta/83/10_replica_identity_schema_compat_version.sql.postgres +++ /dev/null @@ -1 +0,0 @@ -ALTER TABLE schema_compat_version REPLICA IDENTITY USING INDEX schema_compat_version_lock_key; diff --git a/synapse/storage/schema/common/delta/83/10_replica_identity_schema_version.sql.postgres b/synapse/storage/schema/common/delta/83/10_replica_identity_schema_version.sql.postgres deleted file mode 100644 index c10efe0563..0000000000 --- a/synapse/storage/schema/common/delta/83/10_replica_identity_schema_version.sql.postgres +++ /dev/null @@ -1 +0,0 @@ -ALTER TABLE schema_version REPLICA IDENTITY USING INDEX schema_version_lock_key; -- cgit 1.4.1