From: Fujii Masao <masao.fujii@gmail.com>
To: A J <s5aly@yahoo.com>
Cc: Kevin Grittner <Kevin.Grittner@wicourts.gov>
Cc: Ray Stell <stellr@cns.vt.edu>
Cc: pgsql-admin@postgresql.org
Subject: Re: Switchover of Master and Slave roles
Date: Wed, 8 Jun 2011 10:51:25 +0900
Message-ID: <BANLkTimSvtJk9C8pQFwxsPF4G8ssNcYm3A@mail.gmail.com> (raw)
In-Reply-To: <349220.32155.qm@web120008.mail.ne1.yahoo.com>
References: <693391.31715.qm@web120020.mail.ne1.yahoo.com>
<20110607181244.GA3861@cns.vt.edu>
<264025.13168.qm@web120005.mail.ne1.yahoo.com>
<4DEE2B49020000250003E2A2@gw.wicourts.gov>
<349220.32155.qm@web120008.mail.ne1.yahoo.com>
On Wed, Jun 8, 2011 at 3:59 AM, A J <s5aly@yahoo.com> wrote:
> Ok. So if I understand it correctly, as far as Postgres is concerned the
> 'mirror is broken'. It is a one-time cutover.
> We then rely on filesystem tools (or other third party tools) to get the
> original master in sync with the new master efficiently and then make it
> join as slave.
If the standby is completely sync with the master when failover happens,
and if those two servers share the archive area, you can start new standby
without taking a fresh base backup. You can do that by setting
recovery_target_timeline to 'latest' in the recovery.conf and just starting
new standby.
Regards,
--
Fujii Masao
NIPPON TELEGRAPH AND TELEPHONE CORPORATION
NTT Open Source Software Center
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: masao.fujii@gmail.com, s5aly@yahoo.com, Kevin.Grittner@wicourts.gov, stellr@cns.vt.edu
Subject: Re: Switchover of Master and Slave roles
In-Reply-To: <BANLkTimSvtJk9C8pQFwxsPF4G8ssNcYm3A@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox