Help Center/ Data Replication Service/ Troubleshooting/ Solutions to Failed Check Items/ Database Parameters/ Checking Whether the max_wal_senders Value of the Source Database Is Correctly Configured
Updated on 2022-09-21 GMT+08:00
View PDF

Checking Whether the max_wal_senders Value of the Source Database Is Correctly Configured

PostgreSQL Synchronization

Table 1 Checking whether the max_wal_senders value of the source database is correctly configured

Check Item

Whether the max_wal_senders value of the source database is correctly configured

Description

The max_wal_senders value of the source database must be greater than the number of used replication slots. Otherwise, the synchronization may fail.

Failure Cause and Handling Suggestion

Failure cause: The max_wal_senders value of the source database is less than or equal to the number of used replication slots.

Handling suggestion: Set max_wal_senders to a value greater than the number of used replication slots and restart the database to apply the changes. Run the following command to query the number of used replication slots in the current database:

select count(1) from pg_replication_slots;
Parent topic: Database Parameters