SELECT * FROM tmp_t0;
WARNING: page verification failed, calculated checksum 23222 but expected 50884
ERROR: invalid page in block 0 of relation base/16386/24890
但是,如果无法从备份还原数据,我们该怎么办? 当然,ignore_checksum_failure参数使您能够尝试读取表,但有可能损坏数据。
SET ignore_checksum_failure = on;
SELECT * FROM tmp_t0;
WARNING: page verification failed, calculated checksum 23222 but expected 50884
n
---
1
(1 row)