Re: Online base backup from the hot-standby

On Jun 30, 2011 5:59 AM, "Fujii Masao" <masao.fujii@gmail.com> wrote:
>
> 2011/6/28 Jun Ishiduka <ishizuka.jun@po.ntts.co.jp>:
> >
> >> Considering everything that has been discussed on this thread so far.
> >>
> >> Do you still think your patch is the best way to accomplish base
backups
> >> from standby servers?
> >> If not what changes do you think should be made?
> >
> > I reconsider the way to not use pg_stop_backup().
> >
> > 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?

/Magnus