TCapture table level filtering

Learn how to use table level filtering in TCapture Replication

TCapture RepSrv filtering

Activate the filtering

filter=true
 # file ../conf/prod1_rdb_bdr.conf

Configure filter options inserting directly in table ,

example all table in public schema Delete/Insert/Update;

insert into _rdb_bdr.walq__prod1_filtro values ('public','all','DIU', now());
INSERT 0 1

rdb_db__prod1=# select * from _rdb_bdr.walq__prod1_filtro ;

schemaf | tablef | opdml |           dateop
---------+--------+-------+----------------------------
public  | all    | DIU   | 2020-01-13 15:49:21.344249

Recycle Replication Server:

sh stopTCRepSrv.sh -n prod1
sh runTCRepSrv.sh -n prod1

Test it:

delete from prova where aa=66;

Check log trace:

TRACE | 2020-01-13 15:52:02.334 | [TC-prod1] edslab.TCapt (TCapt.java:563) - TC-prod1_651:<Begin Txid> :9777247
TRACE | 2020-01-13 15:52:02.334 | [TC-prod1] edslab.TCapt (TCapt.java:573) - TC-prod1_651:<< Debug >>  line:9777247#DELETE FROM public.prova WHERE aa = 66 AND ac = 'prod1'; Txid: 9777247
TRACE |  2020-01-13 15:52:02.334 | [TC-prod1] edslab.TCapt (TCapt.java:315) - TC-prod1_651:<< Check >> : select 1 from _rdb_bdr.walq__prod1_xid where xid_current =9777247
TRACE | 2020-01-13 15:52:02.338 | [TC-prod1] edslab.TCapt (TCapt.java:362) - TC-prod1_651:checkFilt on  DELETE FROM public.prova WHERE aa = 66 AND ac = 'prod1'
TRACE | 2020-01-13 15:52:02.338 | [TC-prod1] edslab.TCapt (TCapt.java:363) - TC-prod1_651:v_opdml is  D
TRACE | 2020-01-13 15:52:02.338 | [TC-prod1] edslab.TCapt (TCapt.java:368) - TC-prod1_651:parz is  #public.prova#
TRACE | 2020-01-13 15:52:02.338 | [TC-prod1] edslab.TCapt (TCapt.java:370) - TC-prod1_651:qschema is  #public#
TRACE | 2020-01-13 15:52:02.338 | [TC-prod1] edslab.TCapt (TCapt.java:372) - TC-prod1_651:qtable is  #prova#
TRACE | 2020-01-13 15:52:02.344 | [TC-prod1] edslab.TCapt (TCapt.java:610) - TC-prod1_651:Filter is true
TRACE | 2020-01-13 15:52:02.354 | [TC-prod1] edslab.TCapt (TCapt.java:513) - TC-prod1_651:.......................................>>  Commit#1 >> in Buffer null - Txid:0 - Txidbef:9777247
INFO  | 2020-01-13 15:52:02.355 | [TC-prod1] edslab.TCapt (TCapt.java:514) - TC-prod1_651:Managing xid 9777247
INFO  | 2020-01-13 15:52:02.356 | [TC-prod1] edslab.TCapt (TCapt.java:521) - TC-prod1_651:Scanned:1