Steven Ridgway <admin@heatsinksoftware.com> writes:
> 2) Occasionally (3 times in the last 2 months) the database locks up. When this happens the log file contains a
bunchof 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