Thread: [GENERAL] controlled switchover with repmgr
Hi
In a controlled switchover from master to slave with repmgr, what is the downtime timeframe? Seconds?
What is the internal process involved in a switchover with repmgr? Is the process all automated? Will there be data loss?
Regards
Dylan
Dylan Luong <Dylan.Luong@unisa.edu.au> wrote: > Hi > > > > In a controlled switchover from master to slave with repmgr, what is the > downtime timeframe? Seconds? yes, seconds. > > What is the internal process involved in a switchover with repmgr? Is the > process all automated? Will there be data loss? repmgr first attempts to stop the master. If this is successfull, it will promote the standby, rewinds the old master using pg_rewind and start it as a new standby. It is all automated A switchover is a controlled and planned action, for instance for maintenance. In this case you can take care that there are no open transactions running on the master, without data loss. https://github.com/2ndQuadrant/repmgr/blob/master/README.md Regards, Andreas Kretschmer -- Andreas Kretschmer http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services