Re: pg_standby / WAL archive-restore through system restarts

From: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
To: David Wall <d(dot)wall(at)computer(dot)org>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: pg_standby / WAL archive-restore through system restarts
Date: 2008-05-13 15:31:58
Message-ID: 20080513153158.GG6966@alvh.no-ip.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

--
Alvaro Herrera http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2008-05-13 15:36:57 Re: Making sure \timing is on
Previous Message Justin 2008-05-13 15:30:48 Re: rounding problems