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

From Alvaro Herrera
Subject Re: pg_standby / WAL archive-restore through system restarts
Date
Msg-id 20080513153158.GG6966@alvh.no-ip.org
Whole thread Raw
In response to Re: pg_standby / WAL archive-restore through system restarts  (David Wall <d.wall@computer.org>)
Responses Re: pg_standby / WAL archive-restore through system restarts  (Guillaume Lelarge <guillaume@lelarge.info>)
List 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

pgsql-general by date:

Previous
From: Justin
Date:
Subject: Re: rounding problems
Next
From: Tom Lane
Date:
Subject: Re: Making sure \timing is on