Re: BUG #2712: could not fsync segment: Permission

The same problem exists in 8.1 too.  See this thread

http://archives.postgresql.org/pgsql-bugs/2006-04/msg00177.php

Tom and Magnus tracked down a cause, but I don't think a fix was ever
implemented.

FWIW, we were bitten by the fsync problem which you noticed too.
Unfortunately we were never able to track down a cause (see the mailing
list archives).  They are separate problems though.

Pete

>>> "Thomas H." <me@alternize.com> 23.10.2006 18:21 >>>
there is defenitely something terribly wrong in the windows 8.2b1
regarding
file access/locking. 2nd total db lockup today due to file access locks
(all
hold by postmaster):

2006-10-23 17:48:10 LOCATION:  exec_simple_query, postgres.c:1007
2006-10-23 17:48:14 LOG:  00000: could not rename file
"pg_xlog/00000001000000040000002E" to
"pg_xlog/000000010000000400000037", continuing to try