Re: issue with 9.0 1 slave becomes master with new timeline - Mailing list pgsql-admin

From Kevin Grittner
Subject Re: issue with 9.0 1 slave becomes master with new timeline
Date
Msg-id 4CDBB293020000250003757C@gw.wicourts.gov
Whole thread Raw
In response to issue with 9.0 1 slave becomes master with new timeline  (Dragos Valentin Moinescu <dragos.moinescu@gmail.com>)
List pgsql-admin
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

pgsql-admin by date:

Previous
From: Dragos Valentin Moinescu
Date:
Subject: issue with 9.0 1 slave becomes master with new timeline
Next
From: Michal Seidl
Date:
Subject: REVOKE ALL ON SCHEMA pg_catalog FROM PUBLIC