Message-ID: <4E793CAF.6060600@gmail.com>
Date: Wed, 21 Sep 2011 09:23:59 +0800
From: Rural Hunter <ruralhunter@gmail.com>
User-Agent: Mozilla/5.0 (Windows NT 6.1;
	rv:6.0.2) Gecko/20110902 Thunderbird/6.0.2
MIME-Version: 1.0
To: Kevin Grittner <kevin.grittner@wicourts.gov>
CC: pgsql-admin@postgresql.org
Subject: Re: Warm standby terminate itself?
References: <4E78C3C3.5040208@gmail.com>
	<4E78878D0200002500041401@gw.wicourts.gov>
In-Reply-To: <4E78878D0200002500041401@gw.wicourts.gov>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit

Got it. thanks.

于2011年9月21日 1:31:09,Kevin Grittner写到:
> Rural Hunter<ruralhunter@gmail.com>  wrote:
>
>> I set up an warm standby server which fetches WAL logs from a
>> remote server. It has been working very well. But today, I was
>> editing the restore script(which is set as the restore_command)
>> with vi. Just right after I saved the script, I noticed suddenly
>> the standby server terminated.
>
> Updating a recovery script while it is executing is a problem.  I
> tend to update a copy of the script, stop the warm standby, mv the
> copy into place, and start the warm standby.  You can do that
> without kicking it out of recovery status.
>
> -Kevin
>