(Optional) Setting the Standby Node to Readable

Readable standby node is an optional feature. You need to modify the configuration parameters and restart the primary and standby nodes before using this feature. After the readable standby node function is enabled, the standby node is readable, meeting data consistency requirements.

Procedure

1. If the openGauss database instance is running on the primary and standby nodes, stop the database instance on both nodes.
2. Open the postgresql.conf configuration files of the primary and standby nodes based on the corresponding paths in Table 2, find the corresponding parameters, and change the parameter values to wal_level=hot_standby, hot_standby = on, and hot_standby_feedback = on.
3. After the modification, start the primary and standby nodes.