Re: Automatic failover

On 2020/03/17 19:30, Sonam Sharma wrote:
> I have setup replication using repmgr. Wanted to know how much time
> the slave node will take to become new primary ?? If any document,
> can someone please share of auto failover. With automatic failover,
> how much time the slave takes to become new primary .

It's impossible to give a generic answer to this.

Firstly, there will be the interval between the primary failing and whatever
failover system you are using deciding to make a failover decision. This will
be configurable, and will always be a trade-off between speed and certainty.
Secondly it will depend on what work the standby needs to do before it completes
the promotion process. Typically the standby will promote very quickly, but e.g.
if it has a bunch of WAL to replay first, the process will take longer.

Regards

Ian Barwick

--
Ian Barwick https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services