Postgres故障切换错误

Question

我们正在测试Postgres故障转移。在主节点关闭后，我按照指示“触摸”了trigger_file。现在，从服务器变成了主服务器。former_slave (现在主要)中的测试insert语句返回了以下错误。有人知道我还需要禁用或关闭哪些其他参数吗？

formetest=# insert into tcompany values(50,'NOT ACME','ToonLand1');  
^CCancel request sent  
WARNING:  canceling wait for synchronous replication due to user request  
DETAIL:  The transaction has already committed locally, but might not have been replicated to the standby.  
INSERT 0 1

Answer 1

您的服务器处于同步提交状态，这意味着正在等待从属服务器的响应，但无法获得它，停用synchronous_commit或配置从属服务器以响应，建议进行故障切换和切换的扩展是repmgr