Re: Warm standby terminate itself? - Mailing list pgsql-admin

From Kevin Grittner
Subject Re: Warm standby terminate itself?
Date
Msg-id 4E78878D0200002500041401@gw.wicourts.gov
Whole thread Raw
In response to Warm standby terminate itself?  (Rural Hunter <ruralhunter@gmail.com>)
Responses Re: Warm standby terminate itself?  (Rural Hunter <ruralhunter@gmail.com>)
List pgsql-admin
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

pgsql-admin by date:

Previous
From: Rural Hunter
Date:
Subject: Warm standby terminate itself?
Next
From: Marc Fromm
Date:
Subject: returning id