Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
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: Tue, 13 May 2008 11:31:58 -0400
- Message-id: <20080513153158(dot)GG6966(at)alvh(dot)no-ip(dot)org>
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
- Follow-Ups:
- Re: pg_standby / WAL archive-restore through system restarts
- From: Guillaume Lelarge
- Re: pg_standby / WAL archive-restore through system restarts
- References:
- pg_standby / WAL archive-restore through system restarts
- From: David Wall
- Re: pg_standby / WAL archive-restore through system restarts
- From: Guillaume Lelarge
- Re: pg_standby / WAL archive-restore through system restarts
- From: David Wall
- pg_standby / WAL archive-restore through system restarts
- Prev by Date: Re: rounding problems
- Next by Date: Re: Making sure \timing is on
- Previous by thread: Re: pg_standby / WAL archive-restore through system restarts
- Next by thread: Re: pg_standby / WAL archive-restore through system restarts
- Indexes: