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:

  1. ⁠⁠No RDS (ou outro lugar que o banco se encontra), é necessário alterar as configurações do ⁠ postgresql.conf ⁠ da seguinte forma:

    wal_level = logical max_replication_slots = 10 max_wal_senders = 10

    No RDS isso pode ser feito através dos parameter groups. Após alterar o parameter group é necessário reiniciar o banco.

  2. Criar uma replication slot através do seguinte comando: ⁠ 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!