Checking Whether session_replication_role of the Destination Database Is correctly Set
During PostgreSQL synchronization, the session_replication_role parameter of the destination database is not set to replica. Data synchronization may fail when the synchronized table has associated foreign key constraints or triggers.
Failure Cause
The session_replication_role parameter of the destination database is not set to replica.
Handling Suggestion
Before starting the synchronization task, set session_replication_role of the destination database to replica. After the synchronization is complete, change the value of this parameter to origin.
- For a self-managed PostgreSQL database, refer to the following SQL command:SET session_replication_role TO 'replica';
- For an RDS for PostgreSQL instance, change the parameter by referring to "Modifying Parameters of an RDS for PostgreSQL Instance".
Parent topic: Database Parameters
- Failure Cause
- Handling Suggestion