Avaya
3102 · Question #36
After a power failure or database crash, the Postgres database may become corrupted and the Postgres server may not restart. The recovery action is to clear the writer-Ahead Log (WAL) and optionally…
The correct answer is A. pg_resetxlog. See the full explanation below for the reasoning.
Question
After a power failure or database crash, the Postgres database may become corrupted and the Postgres server may not restart. The recovery action is to clear the writer-Ahead Log (WAL) and optionally reset other control data, using which command?
Options
- Apg_resetxlog
- Bpg_clearwal
- Cpg_dump
- Dservice postgresq1 restart
- Eservice wall restart
How the community answered
(34 responses)- A76% (26)
- B3% (1)
- C6% (2)
- E15% (5)
Community Discussion
No community discussion yet for this question.