Full or Incremental Phase Error: memory required is *** MB, maintenance_work_mem is *** MB

Scenarios

During a full or incremental synchronization, an error is reported, and the log information is as follows: retry structures failed events=the fail structures are [type=index, index=***, schema_name=***, object_name=***]reason:[ERROR: memory required is *** MB, maintenance_work_mem is *** MB]

Possible Causes

When an index is created in the destination database, the required memory is greater than the value of maintenance_work_mem configured for the database.

Solution

1. Change the value of maintenance_work_mem in the destination database RDS for PostgreSQL to an appropriate value. For details, see Modifying RDS for PostgreSQL Instance Parameters.
2. Restart the database to apply the change. Then, On the Data Synchronization Management page, locate the target task and click Resume in the Operation column to resume the task.