News for hackers. Stuff that matters.
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?
Re:PostgreSQL Schema Design by megous on Monday March 30, 2020 @10:58AM (#22728517)
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.