Re: Warm standby terminate itself?

From: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
To: "Rural Hunter" <ruralhunter(at)gmail(dot)com>, <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Warm standby terminate itself?
Date: 2011-09-20 17:31:09
Message-ID: 4E78878D0200002500041401@gw.wicourts.gov
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Rural Hunter <ruralhunter(at)gmail(dot)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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Daniel Vázquez 2011-09-20 18:57:26 Unaccent contrib module for PostgreSQL 8.4
Previous Message Rural Hunter 2011-09-20 16:48:03 Warm standby terminate itself?