Re: Online base backup from the hot-standby

On 11-06-23 02:41 AM, Jun Ishiduka wrote:
> I receive this mail, so I notice I do wrong recognition to what
> Heikki is proposing. 
>
> my recognition:
>   Before:
>     * I thought Heikki proposes, "Execute SQL(pg_start_backup('x'); copy 
>       the data directory and pg_stop_backup();) from the standby server 
>       to the primary server".
>       -> I disliked this. 
>   Now:
>     * Heikki is proposing both No using pg_basebackup and Not specify -x.
>       So,
>         * Use the output of pg_stop_backup().
>         * Don't use backup history file.
>       he thinks.
>
> Right?
>

What I think he is proposing would not require using pg_stop_backup()
but you could also modify pg_stop_back() to work as well.

What do you think of this idea?

Do you see how the patch can be reworked to accomplish this?



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