Error: F_JD023F: DBMS Error [ERROR: Must Be Owner of Table Address]
Issue
Activation fails with the following error:
F_JD023F: DBMS error [ERROR: must be owner of table address]. Last query [alter table replica identity full].
F_JR0015: The previous error was detected during generation of objects for channel . It is possible that objects have been left incomplete.
Environment
- HVR 6
- Source: PostgreSQL
Resolution
To resolve this issue, execute the following statement for all applicable tables:
alter table tbl replica identity full;
Cause
This issue occurs when you are trying to perform log-based capture on replicated tables where you have not applied the above statement. See section Grants for Log-Based Capture in our PostgreSQL requirements for more information.