Show HN: 100% open source, logical multi-master PostgreSQL replication

Summary

Spock Multi-Master Replication for PostgreSQL Table of Contents Spock Multi-Master Replication for PostgreSQL - Prerequisites and Requirements The Spock extension provides multi-master replication for PostgreSQL versions 15 and later. Take the following requirements into consideration as you design your cluster: You will need to install the Spock extension on each node in your cluster. If you're performing a major version upgrade, the old node can be running a recent version of pgLogical2 before upgrading it to become a Spock node. On each node in your cluster, tables must have the same name and reside in the same schema. To check the table name and schema name of an existing table, you can connect to the database with psql and use the \d meta-command: SELECT schemaname, tablename FROM pg_tables ORDER BY schemaname, tablename; For example: lcdb = # \d List of relations Schema | Name | Type | Owner -- ------+----------------+----------+---------- public | table_a | table | ec2 - user public | table_a_id_seq | sequence | ec2 - user public | table_b | table | ec2 - user public | table_b_id_seq | sequence | ec2 - user public | table_c | table | ec2 - user public | table_c_id_seq | sequence | ec2 - user ( 6 rows) Each table must also have the same columns and primary keys, with the same data types in each column. To review detailed information for all tables within a specific schema, connect to the database with psql and use the \d schema_name.* command; for example: lcdb = # \d public.* Table " public.table_a " Column | Type | Collation | Nullable | Default -- ----------+--------------------------+-----------+----------+------------------------------ id | bigint | | not null | generated always as identity name | text | | not null | qty | integer | | not null | created_at | timestamp with time zone | | not null | now() Indexes: " table_a_pkey " PRIMARY KEY , btree (id) Sequence " public.table_a_id_seq " Type | Start | Minimum | Maximum | Increment | Cycles? | Cache -- --...