From: | Andreas Kretschmer <akretschmer(at)spamfence(dot)net> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: controlled switchover with repmgr |
Date: | 2017-03-15 06:50:58 |
Message-ID: | 20170315065058.GA5035@tux |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Dylan Luong <Dylan(dot)Luong(at)unisa(dot)edu(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Stuart Bishop | 2017-03-15 09:26:49 | Re: Postgres backup solution |
Previous Message | John R Pierce | 2017-03-15 03:23:36 | Re: index on search - pg 9.2 |