PostgreSQL
- Full
- Incremental
- It is highly recommended that a non-clustered, non-unique index on the column used for incremental queries
- Change Data Capture (CDC)
- 1.Set
wal_level = logical
- 2.Set
max_replication_slots = #
(any number greater than 1, usually at least 10).
SELECT pg_create_logical_replication_slot('verb_replication_slot', 'test_decoding');
ALTER USER <user> WITH REPLICATION;
GRANT SELECT ON ALL TABLES IN SCHEMA <schema> TO <user>;
Last modified 2yr ago