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:
-
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.
-
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!