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
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general