Postgres failover Error

Question

We are testing Postgres failover. After the primary brought down, I 'touch' the trigger_file as instructed. The slave now becomes the primary. Test insert statement in the former_slave (now primary) came back with the following error. Anybody knows what other parameter(s) I need to disable or turnoff?

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

Abdel P. · Accepted Answer · 2016-12-23 23:12:56Z

0

You got your server in synchrounous commit, that means is waiting to a response from slave(s) and ins‘t get it, deactive the synchronous_commit or configure a slave to respond, a extension recommended to failover and switchovers is repmgr

answered Dec 23, 2016 at 23:12

Abdel P.

7382 gold badges9 silver badges25 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Postgres failover Error

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related