Updated on 2022-09-21 GMT+08:00

Checking Whether the Source Database Is on Standby

PostgreSQL to PostgreSQL and PostgreSQL to GaussDB(for openGauss) Synchronization

Table 1 Checking whether the source database is on standby

Check Item

Whether the source database is on standby

Description

If the source database is a standby database, set hot_standby_feedback in the source database to on.

Failure Cause and Handling Suggestion

Failure cause: The source database is a standby database and the value of hot_standby_feedback in the source database is off. As a result, full synchronization may fail.

Handling suggestion: Before full synchronization, set the hot_standby_feedback parameter of the source database to on. After the full synchronization is complete, change the parameter to the original value.