Re: Online base backup from the hot-standby

Jun Ishiduka <ishizuka.jun@po.ntts.co.jp>

View thread

From: Jun Ishiduka <ishizuka.jun@po.ntts.co.jp>

To: masao.fujii@gmail.com, ssinger_pg@sympatico.ca, magnus@hagander.net, robertmhaas@gmail.com

Cc: pgsql-hackers@postgresql.org, cedric.villemain.debian@gmail.com, heikki.linnakangas@enterprisedb.com

Date: 2011-10-09T18:04:25Z

Lists: pgsql-hackers

Attachments

standby_online_backup_09base_01fpw.patch (application/octet-stream) patch

I created a patch corresponding FPW.
Fujii's patch (ver 9) is based.

 Manage own FPW in shared-memory (on master)
   * startup and walwriter process update it. startup initializes it
     after REDO. walwriter updates it when started or received SIGHUP.

 Insert WAL including a value of current FPW (on master)
   * In the the same timing as update, they insert WAL (is named
     XLOG_FPW_CHANGE). XLOG_FPW_CHANGE has a value of the changed FPW.
   * When it creates CHECKPOINT, it adds a value of current FPW to the
     CHECKPOINT WAL.

 Manage master's FPW in local-memory in startup (on standby)
   * It takes a value of the master's FPW by reading XLOG_FPW_CHANGE at
     REDO.

 Check when pg_start_backup/pg_stop_backup (on standby)
   * It checks to use these two value.
       * master's FPW at latest CHECKPOINT
       * current master's FPW by XLOG_FPW_CHANGE

Regards.


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