# 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](https://docs.verbdata.com/data-sources/ingestion-methods).

## Enable Change Data Capture (CDC)

### Configure server-level settings

1. Set `wal_level = logical`
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>;
```