10.7.14.  P tpm Options

--pg-archive-timeout

Option--pg-archive-timeout
Aliases--repl-pg-archive-timeout
Config File Optionspg-archive-timeout, repl-pg-archive-timeout
DescriptionTimeout for sending unfilled WAL buffers (data loss window)
Value Typenumeric

--pg-ctl

Option--pg-ctl
Aliases--repl-pg-ctl
Config File Optionspg-ctl, repl-pg-ctl
DescriptionPath to the pg_ctl script
Value Typefilename

--pg-method

Option--pg-method
Aliases--repl-pg-method
Config File Optionspg-method, repl-pg-method
DescriptionPostgres Replication method
Value Typestring

--pg-standby

Option--pg-standby
Aliases--repl-pg-standby
Config File Optionspg-standby, repl-pg-standby
DescriptionPath to the pg_standby script
Value Typefilename

--postgresql-dbname

Option--postgresql-dbname
Aliases--repl-postgresql-dbname
Config File Optionspostgresql-dbname, repl-postgresql-dbname
DescriptionName of the database to replicate
Value Typestring

--postgresql-enable-mysql2pgddl

Option--postgresql-enable-mysql2pgddl
Aliases--repl-postgresql-enable-mysql2pgddl
Config File Optionspostgresql-enable-mysql2pgddl, repl-postgresql-enable-mysql2pgddl
DescriptionEnable MySQL to PostgreSQL DDL dialect converting filter placeholder
Value Typestring
Valid Valuesfalse 

--postgresql-slonik

Option--postgresql-slonik
Aliases--repl-postgresql-slonik
Config File Optionspostgresql-slonik, repl-postgresql-slonik
DescriptionPath to the slonik executable
Value Typefilename

--postgresql-tables

Option--postgresql-tables
Aliases--repl-postgresql-tables
Config File Optionspostgresql-tables, repl-postgresql-tables
DescriptionTables to replicate in form: schema1.table1,schema2.table2,...
Value Typestring

--preferred-path

Option--preferred-path
Config File Optionspreferred-path
DescriptionAdditional command path
Value Typefilename

Specifies one or more additional directories that will be added before the current PATH environment variable when external commands are run from within the backup environment. This affects all external tools used by Tungsten Replicator, including MySQL, Ruby, Java, and backup/restore tools such as Percona Xtrabackup.

One or more paths can be specified by separating each directory with a colon. For example:

shell> tpm ... --preferred-path=/usr/local/bin:/opt/bin:/opt/percona/bin

The --preferred-path information propagated to all remote servers within the tpm configuration. However, if the staging server is one of the servers to which you are deploying, the PATH must be manually updated.

--prefetch-enabled

Option--prefetch-enabled
Config File Optionsprefetch-enabled
DescriptionShould the replicator service be setup as a prefetch applier
Value Typestring

--prefetch-max-time-ahead

Option--prefetch-max-time-ahead
Config File Optionsprefetch-max-time-ahead
DescriptionMaximum number of seconds that the prefetch applier can get in front of the standard applier
Value Typenumeric

--prefetch-min-time-ahead

Option--prefetch-min-time-ahead
Config File Optionsprefetch-min-time-ahead
DescriptionMinimum number of seconds that the prefetch applier must be in front of the standard applier
Value Typenumeric

--prefetch-schema

Option--prefetch-schema
Config File Optionsprefetch-schema
DescriptionSchema to watch for timing prefetch progress
Value Typestring
Defaulttungsten_
Valid Valuestungsten_ 
 tungsten_ 

--prefetch-sleep-time

Option--prefetch-sleep-time
Config File Optionsprefetch-sleep-time
DescriptionHow long to wait when the prefetch applier gets too far ahead
Value Typestring

--preview

Option--preview
Aliases-p
Config File Options 
DescriptionDisplays the help message and preview the effect of the command line options
Value Typestring

--privileged-master

Option--privileged-master
Config File Optionsprivileged-master
DescriptionDoes the login for the master database service have superuser privileges
Value Typestring

--privileged-slave

Option--privileged-slave
Config File Optionsprivileged-slave
DescriptionDoes the login for the slave database service have superuser privileges
Value Typestring

--profile file

Option--profile file
Config File Options 
DescriptionSets name of config file
Value Typestring
Valid Valuestungsten.cfg 

--profile-script

Option--profile-script
Config File Optionsprofile-script
DescriptionAppend commands to include env.sh in this profile script
Value Typestring

--property=key~=/match/replace/

Option--property=key~=/match/replace/
Aliases--property=key+=value, --property=key=value
Config File Options 
DescriptionModify the value for key in any file that the configure script touches; key=value - Set key to value without evaluating template values or other rules; key+=value - Evaluate template values and then append value to the end of the line; key~=/match/replace/ - Evaluate template values then excecute the specified Ruby regex with sub. For example --property=replicator.key~=/(.*)/somevalue,\1/ will prepend 'somevalue' before the template value for 'replicator.key'
Value Typestring

--protect-configuration-files

Option--protect-configuration-files
Config File Optionsprotect-configuration-files
DescriptionWhen enabled, configuration files are protected to be only readable and updatable by the configured user
Value Typestring
Valid ValuesfalseMake configuration files readable by any user
 true 

When enabled (default), the configuration that contain user, password and other information are configured so that they are only readable by the configured user. For example:

shell> ls -al /opt/continuent/tungsten/tungsten-replicator/conf/
total 148
drwxr-xr-x 2 tungsten mysql 4096 May 14 14:32 ./
drwxr-xr-x 11 tungsten mysql 4096 May 14 14:32 ../
-rw-r--r-- 1 tungsten mysql 33 May 14 14:32 dynamic-alpha.role
-rw-r--r-- 1 tungsten mysql 5059 May 14 14:32 log4j.properties
-rw-r--r-- 1 tungsten mysql 3488 May 14 14:32 log4j-thl.properties
-rw-r--r-- 1 tungsten mysql 972 May 14 14:32 mysql-java-charsets.properties
-rw-r--r-- 1 tungsten mysql 420 May 14 14:32 replicator.service.properties
-rw-r----- 1 tungsten mysql 1590 May 14 14:35 services.properties
-rw-r----- 1 tungsten mysql 1590 May 14 14:35 .services.properties.orig
-rw-r--r-- 1 tungsten mysql 896 May 14 14:32 shard.list
-rw-r----- 1 tungsten mysql 43842 May 14 14:35 static-alpha.properties
-rw-r----- 1 tungsten mysql 43842 May 14 14:35 .static-alpha.properties.orig
-rw-r----- 1 tungsten mysql 5667 May 14 14:35 wrapper.conf
-rw-r----- 1 tungsten mysql 5667 May 14 14:35 .wrapper.conf.orig

When disabled, the files are readable by all users:

shell> ll /opt/continuent/tungsten/tungsten-replicator/conf/
total 148
drwxr-xr-x 2 tungsten mysql 4096 May 14 14:32 ./
drwxr-xr-x 11 tungsten mysql 4096 May 14 14:32 ../
-rw-r--r-- 1 tungsten mysql 33 May 14 14:32 dynamic-alpha.role
-rw-r--r-- 1 tungsten mysql 5059 May 14 14:32 log4j.properties
-rw-r--r-- 1 tungsten mysql 3488 May 14 14:32 log4j-thl.properties
-rw-r--r-- 1 tungsten mysql 972 May 14 14:32 mysql-java-charsets.properties
-rw-r--r-- 1 tungsten mysql 420 May 14 14:32 replicator.service.properties
-rw-r--r-- 1 tungsten mysql 1590 May 14 14:32 services.properties
-rw-r--r-- 1 tungsten mysql 1590 May 14 14:32 .services.properties.orig
-rw-r--r-- 1 tungsten mysql 896 May 14 14:32 shard.list
-rw-r--r-- 1 tungsten mysql 43842 May 14 14:32 static-alpha.properties
-rw-r--r-- 1 tungsten mysql 43842 May 14 14:32 .static-alpha.properties.orig
-rw-r--r-- 1 tungsten mysql 5667 May 14 14:32 wrapper.conf
-rw-r--r-- 1 tungsten mysql 5667 May 14 14:32 .wrapper.conf.orig