diff options
author | Michael Paquier <michael@paquier.xyz> | 2020-02-27 15:31:52 +0900 |
---|---|---|
committer | Michael Paquier <michael@paquier.xyz> | 2020-02-27 15:31:52 +0900 |
commit | 8f9aba1874eccae860d5a6ced9b2899b2f7895b4 (patch) | |
tree | 353881054c4e7baa5af1dacb81b998bea9c71471 /src/backend/access/gist/gistvacuum.c | |
parent | 83bd732eb2c83a26db9eefb4595615fa289620a8 (diff) | |
download | postgresql-8f9aba1874eccae860d5a6ced9b2899b2f7895b4.tar.gz postgresql-8f9aba1874eccae860d5a6ced9b2899b2f7895b4.zip |
Skip foreign tablespaces when running pg_checksums/pg_verify_checksums
Attempting to use pg_checksums (pg_verify_checksums in 11) on a data
folder which includes tablespace paths used across multiple major
versions would cause pg_checksums to scan all directories present in
pg_tblspc, and not only marked with TABLESPACE_VERSION_DIRECTORY. This
could lead to failures when for example running sanity checks on an
upgraded instance with --check. Even worse, it was possible to rewrite
on-disk pages with --enable for a cluster potentially online.
This commit makes pg_checksums skip any directories not named
TABLESPACE_VERSION_DIRECTORY, similarly to what is done for base
backups.
Reported-by: Michael Banck
Author: Michael Banck, Bernd Helmle
Discussion: https://postgr.es/m/62031974fd8e941dd8351fbc8c7eff60d59c5338.camel@credativ.de
backpatch-through: 11
Diffstat (limited to 'src/backend/access/gist/gistvacuum.c')
0 files changed, 0 insertions, 0 deletions