FULL_TABLE" and "
FULL_TABLE: This mode will, at each sync run, copy all your data from all your tables and replace the existing data in Whaly by the new copy. While this replication mode is easy to setup, if your tables contains a lot of rows, sync duration will be long and it'll take some processing power on your database, which can slow down your production system.
LOG_BASED(recommended when supported): This mode will use the Postgres replication mechanism of Postgres to only sync the updates of your database at each sync run. This will have a lighter impact on your database but it'll require some setup on your part to properly configure it. Note: It is also called CDC (Change Data Capture), Logical Replication or WAL Replication.
REPLICATIONrole to the Postgres user you want to use with Whaly
wal2jsonplugin is already installed on your Postgres server 🎉
Configurationtab for your DB cluster.
rds.logical_replication. Select this row and click on the
Edit parametersbutton. Set this value to
<database_name>with the name of the Postgres database that you configure in the source.