Re:PostgreSQL Schema Design
by bzzzt on Monday March 30, 2020 @07:04AM
(#22726934)
A power surge caused by a lightning strike would kill your master as well as your backup. Besides that, do you also keep all your WAL logs so you can roll back an accidentally dropped database?
[ Parent
| on HN ]
A power surge here where I am may kill the power supply. It's low probability that it would kill everything.
Anyway, I don't fear the lightnings/storms/power surges where I am as much as I do the inevitable failures of the storage devices, or kernel bugs.
This is just a part of layered protection I have. Offline backups are nice, and I have them too, but they are out of sync all the time by definition. So unless absolutely needed, having a real-time synchronized replica is much more prefered.