Online base backup from the hot-standby

Поиск
Список
Период
Сортировка
От Jun Ishiduka
Тема Online base backup from the hot-standby
Дата
Msg-id 201108050646.p756kHC5023570@ccmds32.silk.ntts.co.jp
обсуждение исходный текст
Ответы Re: Online base backup from the hot-standby  (Cédric Villemain <cedric.villemain.debian@gmail.com>)
Re: Online base backup from the hot-standby  (Fujii Masao <masao.fujii@gmail.com>)
Список pgsql-hackers
> I will provide a patch which can exeute pg_start/stop_backup
> including to solve above comment and conditions in next stage.
> Then please review.

done.


* Procedure

1. Call pg_start_backup('x') on the standby.
2. Take a backup of the data dir.
3. Call pg_stop_backup() on the standby.
4. Copy the control file on the standby to the backup.
5. Check whether the control file is status during hot standby with pg_controldata.
   -> If the standby promote between 3. and 4., the backup can not recovery.
      -> pg_control is that "Minimum recovery ending location" is equals 0/0.
      -> backup-end record is not written.

* Not correspond yet

  * full_page_write = off
    -> If the primary is "full_page_write = off", archive recovery may not act
       normally. Therefore the standby may need to check whether "full_page_write
       = off" to WAL.

--------------------------------------------
Jun Ishizuka
NTT Software Corporation
TEL:045-317-7018
E-Mail: ishizuka.jun@po.ntts.co.jp
--------------------------------------------

Вложения

В списке pgsql-hackers по дате отправления:

Предыдущее
От: Heikki Linnakangas
Дата:
Сообщение: Re: Reduce WAL logging of INSERT SELECT
Следующее
От: Cédric Villemain
Дата:
Сообщение: Re: Online base backup from the hot-standby