0. Required pre work
In order to enable log based syncs, when connecting Postgres database as a Source, make sure to prepare your database. Here’s the procedure:-
On RDS (or any other place where your database is located), modify the
postgresql.confconfigurations: wal_level = logical max_replication_slots = 10 max_wal_senders = 10 If you are using RDS, this can be done through parameter groups. After you change the parameter group, reseting the database is required. -
Create a replication slot using this command:
SELECT * FROM pg_create_logical_replication_slot('nekt', 'wal2json');
If you encounter any issues, reach out to us via Slack, and we’ll gladly assist you!