6 ms·

What issue caused postgres to not be safe recently?

• alexnewman 7y ago
  Fsync doesn't work the way you think it does https://www.google.com/url?sa=t&source=web&rct=j&url=https://www.percona.com/blog/2019/02/22/postgresql-fsync-failure-fixed-minor-versions-released-feb-14-2019/&ved=2ahUKEwiXsvXnneLkAhUOUt8KHZLeCr8QFjACegQIAhAB&usg=AOvVaw0oSQmeeR3e3YkGDJKnUFui 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]
  • anarazel 7y 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.
    • alexnewman 7y ago
      Uhm the first sentence is accurate. The second is not
      • anarazel 7y ago
        I'm fairly sure I was accurate. What exactly are you referring to?