Skip to content

Latest commit

 

History

History
68 lines (42 loc) · 2.95 KB

20230206_01.md

File metadata and controls

68 lines (42 loc) · 2.95 KB

PostgreSQL 16 preview - Add support for progress reporting to pg_verifybackup

作者

digoal

日期

2023-02-06

标签

PostgreSQL , PolarDB , 进度条 , pg_verifybackup , pg_rewind , pg_basebackup


背景

https://git.postgresql.org/gitweb/?p=postgresql.git;a=commit;h=d07c2948bfe577cfeaa4eb564c5e62bcb6cb1955

Add support for progress reporting to pg_verifybackup  
author	Michael Paquier <michael@paquier.xyz>	  
Mon, 6 Feb 2023 05:40:31 +0000 (14:40 +0900)  
committer	Michael Paquier <michael@paquier.xyz>	  
Mon, 6 Feb 2023 05:40:31 +0000 (14:40 +0900)  
commit	d07c2948bfe577cfeaa4eb564c5e62bcb6cb1955  
tree	4771a0cd44cff7fc894dcbfa6e113eba25595cf9	tree  
parent	71c37797d7bd78266146a5829ab62b3687c47295	commit | diff  
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  

digoal's wechat