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.
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.
For any further questions, feel free to contact us through the chatbot.
Chatbot
