pglogical: SQL "frontend" related changes meta issue

[otan]

• [ ] Add the system replication_slots table + migration
• [x] Add replication role option #106082
• [x] Add pg_lsn data type #105031
  • [x] Add requisite version gating https://github.com/cockroachdb/cockroach/pull/105391
  • [x] Version gate pg_lsn type in cast expressions
  • [x] Add pgwire encoding tests for pg_lsn to pkg/cmd/generate-binary/main.go
• [x] add pg_lsn operators https://github.com/cockroachdb/cockroach/pull/105326
• [ ] Implement the PG streaming replication protocol
  • [x] Implement the parser #104938
  • [x] Allow replication={database,0,1,on,off} as an argument into the connection string #105400
  • [x] Disable extended protocol when replication mode enabled #106131
  • [x] Disable logging in unless you have the replication roleoption #106082
  • [ ] (optional) Disable changing replication session variable
  • [ ] Implement & use the streaming replication protocol commands
    • [x] IDENTIFY_SYSTEM #106131
    • [ ] START_REPLICATION -- follow https://github.com/postgres/postgres/blob/master/src/backend/replication/walsender.c
    • [ ] CREATE_REPLICATION_SLOT (not-AWS DMS blocking)
    • [ ] DROP_REPLICATION_SLOT (not-AWS DMS blocking)
    • [x] Add unimplemented errors to unsupported replication protocol commands (i.e. TIMELINE_HISTORY, CREATE_REPLICATION_SLOT for PHYSICAL, BASE_BACKUP, READ_REPLICATION_SLOT) #104938
• [ ] Implement the pg_catalog metadata tables
• [ ] Implement the functions
  • [ ] pg_create_logical_replication_slot
  • [ ] pg_drop_replication_slot
  • [ ] pg_logical_slot_get_changes (not-AWS DMS blocking)
  • [ ] pg_logical_slot_peek_changes (not-AWS DMS blocking)
  • [ ] pg_logical_slot_get_binary_changes (stretch/not-AWS DMS blocking)
  • [ ] pg_logical_slot_peek_binary_changes (stretch/not-AWS DMS blocking)
  • [ ] pg_get_replication_slots (not-AWS DMS blocking)
  • [ ] pg_replication_slot_advance (not-AWS DMS blocking)
  • [ ] Add unimplemented errors to unsupported commands
• [ ] Add mixed version testing for v22.2+v23.1 / v23.2
• [ ] Properly figure out LSNs
• [ ] Add max_replication_slots, max_wal_senders, wal_level, wal_sender_timeout session variables
• [ ] (stretch) extend SHOW SYNTAX to support pg repl commands
• [ ] (stretch) CREATE PUBLICATION

---

x-ref #93404 for prototype PR DMS meta issue https://github.com/cockroachdb/cockroach/issues/84505 Epic: https://cockroachlabs.atlassian.net/browse/CRDB-26486 test with https://github.com/jackc/pglogrepl

Jira issue: CRDB-28886

Epic CRDB-26486

[blathers-crl[bot]]

cc @cockroachdb/cdc

[shermanCRL]

We might consider contributing to or forking https://github.com/jackc/pglogrepl for things that are “only about the protocol”, and are not CRDB-specific.