Help Center> Data Replication Service> Troubleshooting> Failure Cases> Real-Time Synchronization from PostgreSQL to PostgreSQL> Full Synchronization Error: relation *** does not exist
Updated on 2023-01-17 GMT+08:00
View PDF

Full Synchronization Error: relation *** does not exist

Scenarios

During full synchronization, an error is reported, and the log information is as follows: service DATAMOVE failed, cause by: ERROR: relation '%s' does not exist Position: 15

Possible Causes

During table-level synchronization, objects with dependencies are not synchronized. For example, the source database contains tables A and B and table A depends on table B, but only table A is synchronized.

Solution

  1. Clear data in the destination database.
  2. Create a synchronization task again and select the objects to be synchronized and all dependent objects.
  3. Start the synchronization task.