Re: pg_stat_progress_basebackup - progress reporting for pg_basebackup, in the server side
Fujii Masao <masao.fujii@oss.nttdata.com>
From: Fujii Masao <masao.fujii@oss.nttdata.com>
To: Amit Langote <amitlangote09@gmail.com>,
Kyotaro Horiguchi <horikyota.ntt@gmail.com>
Cc: Masahiko Sawada <masahiko.sawada@2ndquadrant.com>,
PostgreSQL-development <pgsql-hackers@postgresql.org>
Date: 2020-02-17T13:00:15Z
Lists: pgsql-hackers
Attachments
- pg_stat_progress_basebackup_v4.patch (text/plain) patch v4
On 2020/02/06 11:07, Amit Langote wrote: > On Thu, Feb 6, 2020 at 9:51 AM Kyotaro Horiguchi > <horikyota.ntt@gmail.com> wrote: >>> On Wed, Feb 5, 2020 at 18:25 Amit Langote <amitlangote09@gmail.com> wrote: >>>> So, maybe you're saying that "waiting for checkpoint" is ambiguous and >>>> most people will assume it means "...to start". As for me, I assume >>>> it ends with "...to finish". >> >> I'm not sure "most peple will assume" or not, so I said "I'm not >> sure". For example, I feel strangeness to use "I'm waiting for Amit" >> to express that I'm waiting Amit to leave there. That phrase gives me >> such kind of uneasiness. >> >> I thought of "establishing checkpoint" or "running a checkpoint" as >> other candidates. > > Okay, I understand. I am fine with "running checkpoint", although I > think "waiting for checkpoint" isn't totally wrong either. Yeah, but if "waiting for XXX" sounds a bit confusing to some people, I'm OK to back to "waiting for XXX to finish" that you originally proposed. Attached the updated version of the patch. This patch uses the following descriptions of the phases. waiting for checkpoint to finish estimating backup size streaming database files waiting for wal archiving to finish transferring wal files Regards, -- Fujii Masao NTT DATA CORPORATION Advanced Platform Technology Group Research and Development Headquarters
Commits
-
Report NULL as total backup size if it's not estimated.
- 67e0adfb3f98 13.0 landed
-
Make pg_basebackup ask the server to estimate the total backup size, by default.
- fab13dc50ba5 13.0 landed
-
Report progress of streaming base backup.
- e65497df8f85 13.0 landed