pgsql: Add support for progress reporting to pg_verifybackup

From: Michael Paquier <michael(at)paquier(dot)xyz>
To: pgsql-committers(at)lists(dot)postgresql(dot)org
Subject: pgsql: Add support for progress reporting to pg_verifybackup
Date: 2023-02-06 05:42:08
Message-ID: E1pOuGV-001ooV-7K@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Add support for progress reporting to pg_verifybackup

This adds a new option to pg_verifybackup called -P/--progress, showing
every second some information about the progress of the checksum
verification based on the data of a backup manifest.

Similarly to what is done for pg_rewind and pg_basebackup, the
information printed in the progress report consists of the current
amount of data computed and the total amount of data that will be
computed. Note that files found with an incorrect size do not have
their checksum verified, hence their size is not appended to the total
amount of data estimated during the first scan of the manifest data
(such incorrect sizes could be overly high, for one, falsifying the
progress report).

Author: Masahiko Sawada
Discussion: https://postgr.es/m/CAD21AoC5+JOgMd4o3z_oxw0f8JDSsCYY7zSbhe-O9x7f33rw_A@mail.gmail.com

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/d07c2948bfe577cfeaa4eb564c5e62bcb6cb1955

Modified Files
--------------
doc/src/sgml/ref/pg_verifybackup.sgml | 15 ++++++
src/bin/pg_verifybackup/pg_verifybackup.c | 86 +++++++++++++++++++++++++++++--
src/bin/pg_verifybackup/t/004_options.pl | 17 ++++--
3 files changed, 111 insertions(+), 7 deletions(-)

Browse pgsql-committers by date

  From Date Subject
Next Message Michael Paquier 2023-02-06 06:25:04 pgsql: Extend check_GUC_init() with checks on flag combinations when lo
Previous Message Robins Tharakan 2023-02-06 03:43:08 Re: pgsql: Do assorted mop-up in the planner.