作者
digoal
日期
2019-04-05
标签
PostgreSQL , pg_checksums , progress , pg_rewind , pg_basebackup
背景
与pg_rewind, pg_basebackup一样，pg_checksums也支持了进度展示的特性。在执行过程中，可以看到进度。
```
Add progress reporting to pg_checksums
author Michael Paquier michael@paquier.xyz
Tue, 2 Apr 2019 09:58:07 +0800 (10:58 +0900)
committer Michael Paquier michael@paquier.xyz
Tue, 2 Apr 2019 09:58:07 +0800 (10:58 +0900)
commit 280e5f14056bf34a0f52320f659fb93acfda0876
tree 4021ca3e09de36ac2c5b66bb86d3a96b4b1ccf91 tree | snapshot
parent 475861b2615dd63ae8431d811749a6f9a15bbfd6 commit | diff
Add progress reporting to pg_checksums
This adds a new option to pg_checksums called -P/--progress, showing
every second some information about the computation state of an
operation for --check and --enable (--disable only updates the control
file and is quick). This requires a pre-scan of the data folder so as
the total size of checksummable items can be calculated, and then it
gets compared to the amount processed.
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 to compute. This
could be extended later on.
Author: Michael Banck, Bernd Helmle
Reviewed-by: Fabien Coelho, Michael Paquier
Discussion: https://postgr.es/m/1535719851.1286.17.camel@credativ.de
```
参考
https://git.postgresql.org/gitweb/?p=postgresql.git;a=commit;h=280e5f14056bf34a0f52320f659fb93acfda0876
PostgreSQL 许愿链接
您的愿望将传达给PG kernel hacker、数据库厂商等, 帮助提高数据库产品质量和功能, 说不定下一个PG版本就有您提出的功能点. 针对非常好的提议，奖励限量版PG文化衫、纪念品、贴纸、PG热门书籍等，奖品丰富，快来许愿。开不开森.
9.9元购买3个月阿里云RDS PostgreSQL实例
PostgreSQL 解决方案集合
德哥 / digoal's github - 公益是一辈子的事.
