Replication Parameters of Two Database Instances

RepOriginId

Parameter description: This parameter is a session-level GUC parameter. In bidirectional logical replication, set it to a non-zero value to avoid infinite data replication.

This parameter is a USERSET parameter. Set it based on Method 3 provided in Table 1.

Value range: an integer ranging from 0 to 2147483647

Default value: 0

stream_cluster_run_mode

Parameter description: Specifies whether a DN is in the primary or standby instance in dual-instance streaming DR scenarios. For single-instance scenarios, the DN is in the primary instance by default.

This parameter is a POSTMASTER parameter. Set it based on instructions provided in Table 1.

Value range: enumerated values

• cluster_primary indicates that the node is in the primary instance.
• cluster_standby indicates that the node is in the standby instance.

Default value: cluster_primary

enable_roach_standby_cluster

Parameter description: Sets the standby database instances to read-only in dual-database instance mode. Only users with the sysadmin permission can access this parameter.

This parameter is a POSTMASTER parameter. Set it based on instructions provided in Table 1.

Value range: Boolean

• on indicates that the read-only mode is enabled for the standby database instances.
• off indicates that the read-only mode is disabled for the standby database instances. In this case, the standby database instances can be read and written.

Default value: off