Re: Online base backup from the hot-standby

Поиск
Список
Период
Сортировка
От Jun Ishiduka
Тема Re: Online base backup from the hot-standby
Дата
Msg-id 201108160609.p7G69pD0019748@ccmds32.silk.ntts.co.jp
обсуждение исходный текст
Ответ на Re: Online base backup from the hot-standby  (Robert Haas <robertmhaas@gmail.com>)
Ответы Re: Online base backup from the hot-standby  (Steve Singer <ssinger_pg@sympatico.ca>)
Список pgsql-hackers
> >> > * 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.
> >>
> >> Isn't having a standby make the full_page_write = on in all case
> >> (bypass configuration) ?
> >
> > what's the meaning?

Thanks. 

This has the following two problems.* pg_start_backup() must set 'on' to full_page_writes of the master that   is
actualwriting of the WAL, but not the standby.* The standby doesn't need to connect to the master that's actual writing
 WAL.  (Ex. Standby2 in Cascade Replication: Master - Standby1 - Standby2)
 

I'm worried how I should clear these problems.

Regards.

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




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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: src/backend/storage/ipc/README
Следующее
От: Jun Ishiduka
Дата:
Сообщение: Re: Online base backup from the hot-standby