Hacker News new | ask | show | jobs
by coded 2469 days ago
What issue caused postgres to not be safe recently?
1 comments
alexnewman 2467 days ago
Fsync doesn't work the way you think it does

https://www.google.com/url?sa=t&source=web&rct=j&url=https:/...

PostgreSQL › wiki › Fsync_Errors Web results Fsync Errors - PostgreSQL wiki

LWN.net › Articles PostgreSQL's fsync() surprise [LWN.net]

link
anarazel 2467 days ago
Note that that only was an issue in cases the storage system itself was failing (i.e. IO errors were generated). In contrast to protection against power failures etc, which was/is working correctly.
link
alexnewman 2463 days ago
Uhm the first sentence is accurate. The second is not
link
anarazel 2463 days ago
I'm fairly sure I was accurate. What exactly are you referring to?
link