Steven Ridgway <admin@xxxxxxxxxxxxxxxxxxxx> writes: > 2) Occasionally (3 times in the last 2 months) the database locks up. When this happens the log file contains a bunch of errors along the lines of : > 2006-06-26 14:53:40 LOG: could not fsync segment 0 of relation 1663/16672/50807554: Permission denied > 2006-06-26 14:53:40 ERROR: storage sync failed on magnetic disk: Permission denied We've seen reports of this sort of symptom due to anti-virus software deciding that the postmaster is a virus :-(. What add-on AV code do you have on that machine? regards, tom lane
