Re: Online base backup from the hot-standby

From: Steve Singer <ssinger_pg(at)sympatico(dot)ca>
To: Jun Ishiduka <ishizuka(dot)jun(at)po(dot)ntts(dot)co(dot)jp>
Cc: Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Online base backup from the hot-standby
Date: 2011-06-23 14:21:48
Message-ID: BLU0-SMTP540DC369919CCA08DD2D368E530@phx.gbl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(dot)jun(at)po(dot)ntts(dot)co(dot)jp
> --------------------------------------------
>
>
>

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Kevin Grittner 2011-06-23 14:56:08 Re: Table Partitioning
Previous Message Robert Haas 2011-06-23 14:18:15 Re: Table Partitioning