Re: pg_standby / WAL archive-restore through system restarts - Mailing list pgsql-general

From Guillaume Lelarge
Subject Re: pg_standby / WAL archive-restore through system restarts
Date
Msg-id 4829C666.4010604@lelarge.info
Whole thread Raw
In response to Re: pg_standby / WAL archive-restore through system restarts  (Alvaro Herrera <alvherre@commandprompt.com>)
Responses Re: pg_standby / WAL archive-restore throughsystem restarts
List pgsql-general
Alvaro Herrera a écrit :
> someone wrote:
>
>>>> Can I shutdown Server B (backup/recovery postmaster) simply by
>>>> killing the postmaster and restart it back in recovery mode to
>>>> continue re-syncing where it left off?  Or does stopping Server B
>>>> while in recovery mode require any manual re-sync steps before it can
>>>> resume recovery?
>>> I think you'll need to redo the whole process : restore the full data
>>> backup, create the recovery.conf file, etc.
>
> No, you don't.  The server can continue replaying files.
>

Oops, sorry about this. I thought it would have a hard time to go back
to recovery mode. That's great to know. Thanks.


--
Guillaume.
  http://www.postgresqlfr.org
  http://dalibo.com

pgsql-general by date:

Previous
From: "J. Manuel Velasco - UBILIBET"
Date:
Subject: how can i get initdb
Next
From: "Scott Marlowe"
Date:
Subject: Re: multicolumn index join