From: Kevin Grittner <Kevin.Grittner@wicourts.gov>
To: Dragos Valentin Moinescu <dragos.moinescu@gmail.com>
To: pgsql-admin@postgresql.org
Subject: Re: issue with 9.0 1 slave becomes master with new timeline
Date: Thu, 11 Nov 2010 09:08:35 -0600
Message-ID: <4CDBB293020000250003757C@gw.wicourts.gov> (raw)
In-Reply-To: <AANLkTi=ajKCSuUU8wh7OnGPg9tx96gU-pBXM2wfdF5mu@mail.gmail.com>
References: <AANLkTi=ajKCSuUU8wh7OnGPg9tx96gU-pBXM2wfdF5mu@mail.gmail.com>
Dragos Valentin Moinescu <dragos.moinescu@gmail.com> wrote:
> How can I easile migrate the 2 slaves on the new master without
> creating a new base backup (which unfortunately takes too long as
> the databases contain arround 200GB)?
Have you tested rsync using a daemon from the new master (after
pg_start_backup) to the copy the slave already has? It should send
the delta pretty quickly -- perhaps quickly enough to meet your
needs. It's worth testing, anyway.
I believe this is an area people are trying to improve for 9.1.
-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: Kevin.Grittner@wicourts.gov, dragos.moinescu@gmail.com
Subject: Re: issue with 9.0 1 slave becomes master with new timeline
In-Reply-To: <4CDBB293020000250003757C@gw.wicourts.gov>
* 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