Enable log based sync on Postgres DB
Get your database ready for log based syncs with Nekt.
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.conf
configurations: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');
After the replication slot creation, the system will collect logs and, because of that, a raise on the database storage usage should be noticeduntil Nekt is done with reading the database.
Done! With that, you are ready to follow the next steps and connect Nekt with your database through the interface of our application.
If you encounter any issues, reach out to us via Slack, and we’ll gladly assist you!