May 2018
Intermediate to advanced
576 pages
30h 25m
English
It's possible for a problem to be caused by replaying the transaction log, so that the database server will fail to start.
Some people's response to this is to use a utility named pg_resetwal, which removes the current transaction log files and tidies up after that operation has taken place.
The pg_resetwal utility destroys data changes, and that means data loss. If you do decide to run that utility, make sure you take a backup of the pg_wal directory first. Our advice is to seek immediate assistance rather than do this. You don't know for certain that doing this will fix a problem, though once you've done it, you will have difficulty going back.