Question: Postgres failover Error

Question

Postgres failover Error

Answers 0
Added at 2016-12-07 16:12
Tags
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

Answers to

Postgres failover Error

Source Show
◀ Wstecz