On Tuesday 13 May 2008 12:48:38 Guillaume Lelarge wrote:
> Alvaro Herrera a =E9crit :
> > 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.
>
>
There is a caveat here, in that you need to keep around n number of
xlogs,=
=20
where n is determined based on the last restart point processed on the
slav=
e.=20
If you are deleting all xlogs as they are processed, any shutdown will
like=
ly=20
cause you to have to start the whole thing over again. Note pg_standby
and=
=20
8.3 give some pretty convenient tools to manage this.=20
--=20
Robert Treat
Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL
--=20
Sent via pgsql-general mailing list (pgsql-general@[EMAIL PROTECTED]
)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
|
