Help Center/ Data Replication Service/ Troubleshooting/ Solutions to Failed Check Items/ Database Parameters/ Checking Whether the Source Database Is on Standby
Updated on 2024-09-25 GMT+08:00
View PDF
Share

Checking Whether the Source Database Is on Standby

For a full+incremental synchronization task where the source database is a PostgreSQL database, the source database cannot be a standby database. Otherwise, the incremental synchronization cannot be performed. For a full synchronization task, the source database can be a standby database, but hot_standby_feedback must be set to on. Otherwise, the synchronization may fail.

Failure Cause

  • In a full+incremental synchronization task, the source database is a standby database, and incremental synchronization cannot be performed.
  • For a full synchronization task, the source database is a standby database, and hot_standby_feedback is set to off.

Handling Suggestion

  • For a full+incremental synchronization task, change the source database to a primary database.
  • For a full synchronization task, change the source database to a primary database. Alternatively, change the hot_standby_feedback value of the source database to on before starting full synchronization. After the full synchronization is complete, change the value of this parameter to off.
Parent topic: Database Parameters