From: A J <s5aly@yahoo.com>
To: Kevin Grittner <Kevin.Grittner@wicourts.gov>
To: Ray Stell <stellr@cns.vt.edu>
Cc: pgsql-admin@postgresql.org
Subject: Re: Switchover of Master and Slave roles
Date: Tue, 7 Jun 2011 11:59:07 -0700 (PDT)
Message-ID: <349220.32155.qm@web120008.mail.ne1.yahoo.com> (raw)
In-Reply-To: <4DEE2B49020000250003E2A2@gw.wicourts.gov>
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>
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.
Right ?
________________________________
From: Kevin Grittner <Kevin.Grittner@wicourts.gov>
To: Ray Stell <stellr@cns.vt.edu>; A J <s5aly@yahoo.com>
Cc: pgsql-admin@postgresql.org
Sent: Tue, June 7, 2011 2:44:41 PM
Subject: Re: [ADMIN] Switchover of Master and Slave roles
A J <s5aly@yahoo.com> wrote:
> What does it exactly mean to 'recreate a standby server' ? Can I
> not use the datafiles on the former primary and just let it sync
> and get the incremental from the new primary ? Do I have to remove
> all the data files from the former primary and get all the
> datafiles through rsync (or other similar manner) from the new
> primary ?
The old server will probably be close enough that judicious use of
rsync with the old copy as the target will allow a base backup to be
taken very quickly.
-Kevin
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: s5aly@yahoo.com, Kevin.Grittner@wicourts.gov, stellr@cns.vt.edu
Subject: Re: Switchover of Master and Slave roles
In-Reply-To: <349220.32155.qm@web120008.mail.ne1.yahoo.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