PostgreSQL Question posted in
The official documentation can be found here.

Can Windows "Compress contents to save disk space" folder option yield PostgreSQL erratic behavior?

I’m maintaining an old PostgreSQL-based application (PostgreSQL 9.1.22) on a Windows 2012 Server and we have noticed some data integrity inconsistencies. No errors have been spotted in logs nor in the event viewer, but we have noticed that somebody (or Windows itself) has automatically set the "Compress contents to save disk space" option to the cluster directory (and its subdirectories). I understand that this option works at OS level so it shouldn’t affect PostgreSQL (beyond some performance issues), but maybe I’m wrong. Does anybody know if this option might lead to data integrity issues?

Thank you.

Tags:

2

Answers


  1. Chosen as BEST ANSWER
    0

    After a week with "Compress contents to save disk space" option disabled, I can confirm that this option causes data integrity problems with PostgreSQL engine 9.1.22 on Windows 2012 Server. So my advice is disabling it from the entire cluster directory and subdirectories.


  2. 0

    Old, outdated software on (probably) old, outdated hardware is a great recipe for data corruption of all kinds. I wouldn’t necessarily blame Windows, although it could of course be the source of the problem.

    Login or Signup to reply.
Please signup or login to give your own answer.

Back To Top
Search