Re: Online base backup from the hot-standby

On Jun 30, 2011 5:59 AM, "Fujii Masao" <masao(dot)fujii(at)gmail(dot)com> wrote:
>
> 2011/6/28 Jun Ishiduka <ishizuka(dot)jun(at)po(dot)ntts(dot)co(dot)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