Re: Switchover of Master and Slave roles

From: Guillaume Lelarge <guillaume(at)lelarge(dot)info>
To: A J <s5aly(at)yahoo(dot)com>
Cc: Ray Stell <stellr(at)cns(dot)vt(dot)edu>, pgsql-admin(at)postgresql(dot)org
Subject: Re: Switchover of Master and Slave roles
Date: 2011-06-07 18:40:03
Message-ID: 1307472003.2027.1.camel@laptop
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Tue, 2011-06-07 at 11:33 -0700, A J wrote:
> >>To return to normal operation, a standby server must be recreated,
> either on the former primary system when it comes up<<
>
>
> 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 ?
>
>

Don't remove them. This way, rsync will only send the changed files.

--
Guillaume
http://blog.guillaume.lelarge.info
http://www.dalibo.com

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Kevin Grittner 2011-06-07 18:44:41 Re: Switchover of Master and Slave roles
Previous Message A J 2011-06-07 18:33:56 Re: Switchover of Master and Slave roles