Re: Online base backup from the hot-standby

Поиск
Список
Период
Сортировка
Искать
От
Jun Ishiduka
Тема
Re: Online base backup from the hot-standby
Дата
Msg-id
201110190248.p9J2mSf7018918@ccmds32.silk.ntts.co.jp
Ответ на
Список
Дерево обсуждения
Online base backup from the hot-standby Jun Ishiduka <ishizuka.jun@po.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 Jun Ishiduka <ishizuka.jun@po.ntts.co.jp>
Re: Online base backup from the hot-standby Robert Haas <robertmhaas@gmail.com>
Re: Online base backup from the hot-standby Jun Ishiduka <ishizuka.jun@po.ntts.co.jp>
Re: Online base backup from the hot-standby Steve Singer <ssinger_pg@sympatico.ca>
Re: Online base backup from the hot-standby Jun Ishiduka <ishizuka.jun@po.ntts.co.jp>
Re: Online base backup from the hot-standby Fujii Masao <masao.fujii@gmail.com>
Re: Online base backup from the hot-standby Robert Haas <robertmhaas@gmail.com>
Re: Online base backup from the hot-standby Fujii Masao <masao.fujii@gmail.com>
Re: Online base backup from the hot-standby Robert Haas <robertmhaas@gmail.com>
Re: Online base backup from the hot-standby Fujii Masao <masao.fujii@gmail.com>
Re: Online base backup from the hot-standby Jun Ishiduka <ishizuka.jun@po.ntts.co.jp>
Re: Online base backup from the hot-standby Fujii Masao <masao.fujii@gmail.com>
Re: Online base backup from the hot-standby Jun Ishiduka <ishizuka.jun@po.ntts.co.jp>
Re: Online base backup from the hot-standby Jun Ishiduka <ishizuka.jun@po.ntts.co.jp>
Re: Online base backup from the hot-standby Jun Ishiduka <ishizuka.jun@po.ntts.co.jp>
Re: Online base backup from the hot-standby Fujii Masao <masao.fujii@gmail.com>
Remastering using streaming only replication? Josh Berkus <josh@agliodbs.com>
Re: Remastering using streaming only replication? Fujii Masao <masao.fujii@gmail.com>
Re: Online base backup from the hot-standby Magnus Hagander <magnus@hagander.net>
Re: Online base backup from the hot-standby Fujii Masao <masao.fujii@gmail.com>
Re: Online base backup from the hot-standby Magnus Hagander <magnus@hagander.net>
Re: Online base backup from the hot-standby Fujii Masao <masao.fujii@gmail.com>
Re: Online base backup from the hot-standby Magnus Hagander <magnus@hagander.net>
Re: Online base backup from the hot-standby Fujii Masao <masao.fujii@gmail.com>
Re: Online base backup from the hot-standby Fujii Masao <masao.fujii@gmail.com>
Re: Online base backup from the hot-standby Jun Ishiduka <ishizuka.jun@po.ntts.co.jp>
Re: Online base backup from the hot-standby Steve Singer <ssinger_pg@sympatico.ca>
Re: Online base backup from the hot-standby Fujii Masao <masao.fujii@gmail.com>
Re: Online base backup from the hot-standby Steve Singer <ssinger_pg@sympatico.ca>
Re: Online base backup from the hot-standby Fujii Masao <masao.fujii@gmail.com>
Re: Online base backup from the hot-standby Fujii Masao <masao.fujii@gmail.com>
Re: Online base backup from the hot-standby Jun Ishiduka <ishizuka.jun@po.ntts.co.jp>
Re: Online base backup from the hot-standby Simon Riggs <simon@2ndQuadrant.com>
Re: Online base backup from the hot-standby Jun Ishiduka <ishizuka.jun@po.ntts.co.jp>
Re: Online base backup from the hot-standby Jun Ishiduka <ishizuka.jun@po.ntts.co.jp>
Re: Online base backup from the hot-standby Steve Singer <ssinger_pg@sympatico.ca>
Re: Online base backup from the hot-standby Jun Ishiduka <ishizuka.jun@po.ntts.co.jp>
Re: Online base backup from the hot-standby Jun Ishiduka <ishizuka.jun@po.ntts.co.jp>
Re: Online base backup from the hot-standby Fujii Masao <masao.fujii@gmail.com>
Re: Online base backup from the hot-standby Jun Ishiduka <ishizuka.jun@po.ntts.co.jp>
Re: Online base backup from the hot-standby Jun Ishiduka <ishizuka.jun@po.ntts.co.jp>
Re: Online base backup from the hot-standby Jun Ishiduka <ishizuka.jun@po.ntts.co.jp>
Re: Online base backup from the hot-standby Fujii Masao <masao.fujii@gmail.com>
Re: Online base backup from the hot-standby Jun Ishiduka <ishizuka.jun@po.ntts.co.jp>
Re: Online base backup from the hot-standby Jun Ishiduka <ishizuka.jun@po.ntts.co.jp>
Re: Online base backup from the hot-standby Fujii Masao <masao.fujii@gmail.com>
Re: Online base backup from the hot-standby Jun Ishiduka <ishizuka.jun@po.ntts.co.jp>
Re: Online base backup from the hot-standby Jun Ishiduka <ishizuka.jun@po.ntts.co.jp>
Re: Online base backup from the hot-standby Jun Ishiduka <ishizuka.jun@po.ntts.co.jp>
Re: Online base backup from the hot-standby Fujii Masao <masao.fujii@gmail.com>
Re: Online base backup from the hot-standby Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>
Re: Online base backup from the hot-standby Fujii Masao <masao.fujii@gmail.com>
Re: Online base backup from the hot-standby Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>
Re: Online base backup from the hot-standby Steve Singer <ssinger_pg@sympatico.ca>
Re: Online base backup from the hot-standby Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>
Re: Online base backup from the hot-standby Fujii Masao <masao.fujii@gmail.com>
Re: Online base backup from the hot-standby Magnus Hagander <magnus@hagander.net>
Re: Online base backup from the hot-standby Fujii Masao <masao.fujii@gmail.com>
Re: Online base backup from the hot-standby Magnus Hagander <magnus@hagander.net>
Re: Online base backup from the hot-standby Josh Berkus <josh@agliodbs.com>
Re: Online base backup from the hot-standby Fujii Masao <masao.fujii@gmail.com>
Re: Online base backup from the hot-standby Fujii Masao <masao.fujii@gmail.com>
Re: Online base backup from the hot-standby Jun Ishiduka <ishizuka.jun@po.ntts.co.jp>
Re: Online base backup from the hot-standby Steve Singer <ssinger_pg@sympatico.ca>
Re: Online base backup from the hot-standby Fujii Masao <masao.fujii@gmail.com>
Re: Online base backup from the hot-standby Fujii Masao <masao.fujii@gmail.com>
Re: Online base backup from the hot-standby Steve Singer <ssinger_pg@sympatico.ca>
Re: Online base backup from the hot-standby "Erik Rijkers" <er@xs4all.nl>
Re: Online base backup from the hot-standby Fujii Masao <masao.fujii@gmail.com>
Re: Online base backup from the hot-standby Simon Riggs <simon@2ndQuadrant.com>
Re: Online base backup from the hot-standby Fujii Masao <masao.fujii@gmail.com>
Re: Online base backup from the hot-standby Simon Riggs <simon@2ndquadrant.com>
Re: Online base backup from the hot-standby Fujii Masao <masao.fujii@gmail.com>
Re: Online base backup from the hot-standby Simon Riggs <simon@2ndQuadrant.com>
Re: Online base backup from the hot-standby Fujii Masao <masao.fujii@gmail.com>
Re: Online base backup from the hot-standby Robert Haas <robertmhaas@gmail.com>
Re: Online base backup from the hot-standby Robert Haas <robertmhaas@gmail.com>
Re: Online base backup from the hot-standby Simon Riggs <simon@2ndQuadrant.com>
Re: Online base backup from the hot-standby Fujii Masao <masao.fujii@gmail.com>
Re: Online base backup from the hot-standby Simon Riggs <simon@2ndQuadrant.com>
Re: Online base backup from the hot-standby Simon Riggs <simon@2ndQuadrant.com>
Re: Online base backup from the hot-standby Fujii Masao <masao.fujii@gmail.com>
Re: Online base backup from the hot-standby Simon Riggs <simon@2ndQuadrant.com>
Re: Online base backup from the hot-standby Simon Riggs <simon@2ndQuadrant.com>
Re: Online base backup from the hot-standby Fujii Masao <masao.fujii@gmail.com>
Re: Online base backup from the hot-standby Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>
Re: Online base backup from the hot-standby Robert Haas <robertmhaas@gmail.com>
Re: Online base backup from the hot-standby Fujii Masao <masao.fujii@gmail.com>
Re: Online base backup from the hot-standby Fujii Masao <masao.fujii@gmail.com>

> > + 		/*
> > + 		 * The backend writes WAL of FPW at checkpoint. However, The backend do
> > + 		 * not need to write WAL of FPW at checkpoint shutdown because it
> > + 		 * performs when startup finishes.
> > + 		 */
> > + 		XLogReportParameters(REPORT_ON_BACKEND);
> > 
> > I'm still unclear why that WAL doesn't need to be written at shutdown
> > checkpoint.
> > Anyway, the first sentence in the above comments is not right. Not a backend but
> > a bgwriter writes that WAL at checkpoint.
> > 
> > The second also seems not to be right. It implies that a shutdown checkpoint is
> > performed only at end of startup. But it may be done when smart or fast shutdown
> > is requested.
> 
> 
> Okay. 
> I change to the following messages.
> 
> /* 
>  * The bgwriter writes WAL of FPW at checkpoint. But does not at shutdown.
>  * Because XLogReportParameters() is always called at the end of startup
>  * process, it does not need to be called at shutdown.
>  */
> 
> 
> In addition, I change macro name.
> 
> REPORT_ON_BACKEND -> REPORT_ON_BGWRITER

I have updated as above-comment.
Please check this.

Regards.

--------------------------------------------
Jun Ishizuka
NTT Software Corporation
TEL:045-317-7018
E-Mail: ishizuka.jun@po.ntts.co.jp
--------------------------------------------
В списке pgsql-hackers по дате отправления
От: Robert Haas
Дата:
От: Tom Lane
Дата:
FAQ