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