[GENERAL] how to decrease the promotion time when performing a multiple failovers.....

2015-12-31 Thread Shay Cohavi
*Hi,* *I have postgresql 9.3 setup with 2 nodes (active/standby with streaming replication & continuos archiving).* *I have created 2 failover & failback script in order to perform a switchover between the DB servers:* *1. failover - create a trigger file in order to promote the new primary.* *2.

[GENERAL] postgresql 9.3 failover time

2015-12-12 Thread Shay Cohavi
*Hi,* *I have postgresql 9.3 setup with 2 nodes (active/standby with streaming replication & continuos archiving).* *I have created 2 failover & failback script in order to perform a switchover between the DB servers:* *1. failover - create a trigger file in order to promote the new primary.* *2.