Guide to creating synchronization jobs in PeerDB
exclude:[]
true
if you want to include initial snapshot of tables as a part of the MIRROR, else false
.snapshot_num_tables_in_parallel * snapshot_max_parallel_workers
true
if you want to soft delete rows on the target peer when they are deleted on the source peer._PEERDB_SYNCED_AT
._PEERDB_IS_DELETED
.OPTIONS
clause provides granular control when configuring the MIRROR:
if_not_exists
: If specified, the MIRROR will be created only if it does not exist.xmin
as watermark column. Note that DELETEs are not supported in XMIN Query Replication.