Search
⌃K
Links

PostgreSQL

Supported Ingestion Methods

  • Full
  • Incremental
    • It is highly recommended that a non-clustered, non-unique index on the column used for incremental queries
  • Change Data Capture (CDC)
For more information on ingestion methods, click here.

Enable Change Data Capture (CDC)

Configure server-level settings

  1. 1.
    Set wal_level = logical
  2. 2.
    Set max_replication_slots = # (any number greater than 1, usually at least 10).

Create a dedicated replication slot

SELECT pg_create_logical_replication_slot('verb_replication_slot', 'test_decoding');

Grant permissions to user

ALTER USER <user> WITH REPLICATION;
GRANT SELECT ON ALL TABLES IN SCHEMA <schema> TO <user>;