When modifying the citus.enable_change_data_capture setting from off-> on for distributed table CDC and executing pg_ctl reload, the setting is applied but the CDC does not work. Only the initial data is copied and subsequent replication does not occur.
However, if all of the nodes in Citus are restarted, the CDC does working.
psql -t -c "select context from pg_settings where name='citus.enable_change_data_capture';"
user
The pg_settings.context is set to user, not postmaster.
emelsimsek
commented
1 month ago
Hi.
PostgreSQL 15.8 Citus 12.1-1
When modifying the citus.enable_change_data_capture setting from off-> on for distributed table CDC and executing pg_ctl reload, the setting is applied but the CDC does not work. Only the initial data is copied and subsequent replication does not occur.
However, if all of the nodes in Citus are restarted, the CDC does working.
The pg_settings.context is set to user, not postmaster.