Steven Ridgway <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster