Add GUC ignore_invalid_pages.
Fujii Masao <fujii@postgresql.org>
Add GUC ignore_invalid_pages. Detection of WAL records having references to invalid pages during recovery causes PostgreSQL to raise a PANIC-level error, aborting the recovery. Setting ignore_invalid_pages to on causes the system to ignore those WAL records (but still report a warning), and continue recovery. This behavior may cause crashes, data loss, propagate or hide corruption, or other serious problems. However, it may allow you to get past the PANIC-level error, to finish the recovery, and to cause the server to start up. Author: Fujii Masao Reviewed-by: Michael Paquier Discussion: https://www.postgresql.org/message-id/CAHGQGwHCK6f77yeZD4MHOnN+PaTf6XiJfEB+Ce7SksSHjeAWtg@mail.gmail.com
Files
| Path | Change | +/− |
|---|---|---|
| doc/src/sgml/config.sgml | modified | +25 −0 |
| src/backend/access/transam/xlogutils.c | modified | +7 −2 |
| src/backend/utils/misc/guc.c | modified | +20 −0 |
Documentation touched
Discussion
- PATCH: standby crashed when replay block which truncated in standby but failed to truncate in master node 27 messages · 2019-09-21 → 2020-02-03