Re: pg_standby / WAL archive-restore through system restarts

From: Guillaume Lelarge <guillaume(at)lelarge(dot)info>
To: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
Cc: David Wall <d(dot)wall(at)computer(dot)org>, pgsql-general(at)postgresql(dot)org
Subject: Re: pg_standby / WAL archive-restore through system restarts
Date: 2008-05-13 16:48:38
Message-ID: 4829C666.4010604@lelarge.info
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Scott Marlowe 2008-05-13 16:50:51 Re: multicolumn index join
Previous Message Fernando 2008-05-13 16:40:18 Re: Conditional on Select List