Re: Disable Streaming Replication without restarting either master or slave

From: Jasen Betts <jasen(at)xnet(dot)co(dot)nz>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Disable Streaming Replication without restarting either master or slave
Date: 2012-06-02 06:48:56
Message-ID: jqcd0o$puj$1@reversiblemaps.ath.cx
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 2012-05-29, Fujii Masao <masao(dot)fujii(at)gmail(dot)com> wrote:
>
> You'd like to restart the *promoted* standby server as the standby again?
> To do this, a fresh base backup must be taken from the master onto
> the standby before restarting it, even if there has been no update since
> the standby had been promoted.
>

I'd like to add that for this purpose "rsync" will likely outperform "tar" by a
very large margin.

--
⚂⚃ 100% natural

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Jasen Betts 2012-06-02 06:57:24 Re: timestamps, formatting, and internals
Previous Message Tom Lane 2012-06-01 18:55:42 Re: autovacuum running for a long time on a new table with 1 row