Snapshot replication options v7
Note
These options apply only to the publication server unless otherwise specified.
The server configuration options apply to snapshot replications.
escapeTabDelimiter
When JDBC COPY
is used in snapshot replication, the data delimiter between column values is an escaped tab character (t). Set this option to false
if you don't want to escape the tab delimiter character.
escapeTabDelimiter={true | false}
The default value is true
.
mtkCopyDelimiter
When JDBC COPY
is used in snapshot replication, the data delimiter between column values is an escaped tab character (t). Set this option to change the data delimiter character.
mtkCopyDelimiter=c
c
denotes the single replacement character for the data delimiter.
The default value is \t.
enableConstBeforeDataLoad
The enableConstBeforeDataLoad
option controls whether table constraints, including triggers, are reenabled before loading data into target tables. The default process is that the tables are loaded first, and then the constraints are enabled afterwards.
Activate this option if triggers affect how data is loaded into the target tables.
If target tables are created as sets of Postgres-inherited tables resulting from partitioned Oracle source tables, then you must enable this option.
enableConstBeforeDataLoad={true | false}
The default value is false.