Enabling Write Statements on Standby Nodes

enable_remote_excute

Parameter description: Determines whether to allow the standby node to execute write statements. This parameter cannot be modified after being started.

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

Value range: Boolean. The value can be true or false. true indicates that the write statement execution mode is enabled on the standby node for the current installation and deployment. off indicates that the mode is disabled.

Default value: off

NOTE:

• The default value of enable_remote_excute is false in standalone mode.
• To allow the standby node to execute write statements, set this parameter to true.
• After this function is enabled, write statements and DDL statements can be executed on the standby node, and simple and extended queries are supported. In this case, read statements are still executed on the standby node, and write statements are forwarded to the primary node for execution.
• After this function is enabled, the standby node unconditionally forwards all SQL statements, including read statements, to the primary node after starting a transaction.