Re: [GENERAL] controlled switchover with repmgr
От | Andreas Kretschmer |
---|---|
Тема | Re: [GENERAL] controlled switchover with repmgr |
Дата | |
Msg-id | 20170315065058.GA5035@tux обсуждение исходный текст |
Ответ на | [GENERAL] controlled switchover with repmgr (Dylan Luong <Dylan.Luong@unisa.edu.au>) |
Список | pgsql-general |
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
В списке pgsql-general по дате отправления: