Dylan Luong <Dylan.Luong@xxxxxxxxxxxx> 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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general