Knowledge Base

PostgreSQL Patroni CRITICAL: system ID mismatch error

If you control your PostgreSQL services with Patroni and receive the following error while performing the replication process, the reason is that your bin_dir definition in your patroni.yml file is error/missing or a different folder.

CRITICAL: system ID mismatch, node *** belongs to a different cluster

For the solution:

You should delete your bin_dir definition and leave it with its default settings.

Then we restart the patroni service.

systemctl restart boss