Re: Online base backup from the hot-standby - Mailing list pgsql-hackers

From Steve Singer
Subject Re: Online base backup from the hot-standby
Date
Msg-id BLU0-SMTP540DC369919CCA08DD2D368E530@phx.gbl
Whole thread Raw
In response to Re: Online base backup from the hot-standby  (Jun Ishiduka <ishizuka.jun@po.ntts.co.jp>)
Responses Re: Online base backup from the hot-standby
List pgsql-hackers
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
> --------------------------------------------
>
>
>



pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: Table Partitioning
Next
From: "Kevin Grittner"
Date:
Subject: Re: Table Partitioning