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