Re: pg_stat_progress_basebackup - progress reporting for pg_basebackup, in the server side
Amit Langote <amitlangote09@gmail.com>
From: Amit Langote <amitlangote09@gmail.com>
To: Fujii Masao <masao.fujii@oss.nttdata.com>
Cc: Masahiko Sawada <masahiko.sawada@2ndquadrant.com>, Kyotaro Horiguchi <horikyota.ntt@gmail.com>, PostgreSQL-development <pgsql-hackers@postgresql.org>
Date: 2020-02-04T06:59:46Z
Lists: pgsql-hackers
Attachments
- basebackup-always-set-tablespace-size.patch (text/plain) patch
On Tue, Feb 4, 2020 at 10:34 AM Amit Langote <amitlangote09@gmail.com> wrote: > Reading this: > > + <entry><structfield>backup_total</structfield></entry> > + <entry><type>bigint</type></entry> > + <entry> > + Total amount of data that will be streamed. If progress reporting > + is not enabled in <application>pg_basebackup</application> > + (i.e., <literal>--progress</literal> option is not specified), > + this is <literal>0</literal>. > > I wonder how hard would it be to change basebackup.c to always set > backup_total, irrespective of whether --progress is specified with > pg_basebackup or not? It seems quite misleading to leave it set to 0, > because one may panic that they have lost their data, that is, if they > haven't first read the documentation. For example, the attached patch changes basebackup.c to always set tablespaceinfo.size, irrespective of whether --progress was passed with BASE_BACKUP command. It passes make check-world, so maybe safe. Maybe it would be a good idea to add a couple of more comments around tablespaceinfo struct definition, such as how 'size' is to be interpreted. Thanks, Amit
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