Horton

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: magnus@hagander.ne, masao.fujii@gmail.com, ssinger_pg@sympatico.ca
Cc: heikki.linnakangas@enterprisedb.com, pgsql-hackers@postgresql.org
Date: 2011-06-30T06:38:45Z
Lists: pgsql-hackers 
> > > Process of online base backup on standby server:
> > >  1. pg_start_backup('x');
> > >  2. copy the data directory
> > >  3. copy *pg_control*
> > 
> > Who deletes the backup_label file created by pg_start_backup()?
> > Isn't pg_stop_backup() required to do that?
>
> You need it to take the system out of backup mode as well, don't you?

Certainly so.

Add to the above process:
  4. pg_stop_backup();

But I do not consider a case such as to promote in backup mode yet.
I need to think a little, including it.

On this commitfest, the goal of the patch is to be able to be 
recovered using "Minimum recovery ending location" in the control file.

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