In looking over pg_verify_checksums I found a few small things that I think would improve on it: * pg_verify_checksums was placed in the Client Utils section in the docs. Since it requries physical access to the cluster datafiles it seems to belong in the Server Utils section. * The -D option and supported environment variable wasn’t documented. * Only -D is supported for specifying the data directory, but most all other utilities also support --pgdata on top of -D. To present a consistent user interface we should probably support --pgdata in pg_verify_checksums as well. The latter is I assume too invasive as we are past the freeze, but the first two docs patches would make sense in 11 IMO as they document whats in the tree. The attached patches fixes the above mentioned things (I don’t have a docs toolchain working right now so the docs patches are best effort). cheers ./daniel
In looking over pg_verify_checksums I found a few small things that I think
would improve on it:
* pg_verify_checksums was placed in the Client Utils section in the docs.
Since it requries physical access to the cluster datafiles it seems to belong
in the Server Utils section.
* The -D option and supported environment variable wasn’t documented.
* Only -D is supported for specifying the data directory, but most all other
utilities also support --pgdata on top of -D. To present a consistent user
interface we should probably support --pgdata in pg_verify_checksums as well.
The latter is I assume too invasive as we are past the freeze, but the first
two docs patches would make sense in 11 IMO as they document whats in the tree.
The attached patches fixes the above mentioned things (I don’t have a docs
toolchain working right now so the docs patches are best effort).
Hello, There is a similar utility that I wrote that does offline checksum verification as well. https://github.com/google/pg_page_verification This utility includes a verbose option as well as scanning multiple subsequent segment files. Alexis -- Sent from: http://www.postgresql-archive.org/PostgreSQL-hackers-f1928748.html
Сайт использует файлы cookie для корректной работы и повышения удобства. Нажимая кнопку «Принять» или продолжая пользоваться сайтом, вы соглашаетесь на их использование в соответствии с Политикой в отношении обработки cookie ООО «ППГ», в том числе на передачу данных из файлов cookie сторонним статистическим и рекламным службам. Вы можете управлять настройками cookie через параметры вашего браузера