OK - after uninstalling the virus scanner (McAfee), I still get the same disk access errors.
Here's a few seconds of the log output (this has been going on for 10 mins as of this e-mail being sent): 2006-11-28 16:16:10 LOG: could not fsync segment 0 of relation 1663/16404/30267: Permission denied 2006-11-28 16:16:10 ERROR: storage sync failed on magnetic disk: Permission denied 2006-11-28 16:16:11 LOG: could not fsync segment 0 of relation 1663/16404/30267: Permission denied 2006-11-28 16:16:11 ERROR: storage sync failed on magnetic disk: Permission denied 2006-11-28 16:16:12 LOG: could not fsync segment 0 of relation 1663/16404/30267: Permission denied 2006-11-28 16:16:12 ERROR: storage sync failed on magnetic disk: Permission denied 2006-11-28 16:16:13 LOG: could not fsync segment 0 of relation 1663/16404/30267: Permission denied 2006-11-28 16:16:13 ERROR: storage sync failed on magnetic disk: Permission denied Here's the FileMon output from the same seconds: 4:16:10 PM postgres.exe:3168 OPEN C:\Program Files\PostgreSQL\8.1\data\base\16404\30267 DELETE PEND Options: Open Access: 0012019F 4:16:11 PM postgres.exe:3168 OPEN C:\Program Files\PostgreSQL\8.1\data\base\16404\30267 DELETE PEND Options: Open Access: 0012019F 4:16:12 PM postgres.exe:3168 OPEN C:\Program Files\PostgreSQL\8.1\data\base\16404\30267 DELETE PEND Options: Open Access: 0012019F 4:16:13 PM postgres.exe:3168 OPEN C:\Program Files\PostgreSQL\8.1\data\base\16404\30267 DELETE PEND Options: Open Access: 0012019F This is an incredibly bad problem for me. I'd really appreciate any help! Jeremy On Mon, 27 Nov 2006 12:14:00 -0500, "Jeremy Haile" <[EMAIL PROTECTED]> said: > Thanks for the feedback. If you don't mind, what version of PostgreSQL > are you running? > > I'm trying to bring PostgreSQL into this company - they are primarily a > Windows/SQL Server shop (although Java software development) I've > already gotten comments similar to "Why don't you just switch to SQL > Server?" - so I'm hoping to find a workaround before I get forced to > switch DB platforms. As it is, my application seems unreliable because > I haven't been able to resolve the PostgreSQL hanging problems in > Windows. If I had my way, I'd switch the server to Linux - but alas, > that hasn't been an option so far. > > I know this may be the wrong list to ask this question on - but as I'm > an outspoken PostgreSQL advocate, I'd like your opinions. If I am > unable to resolve these PostgreSQL issues given my constraints, will I > likely have less problems running MySQL/InnoDB on Windows? (since it has > had a native Windows build for much longer) > > > On Mon, 27 Nov 2006 16:40:57 +0000, "Dave Page" <[EMAIL PROTECTED]> > said: > > Jeremy Haile wrote: > > > I've gotten pushback from my organization on removing antivirus from the > > > servers completely. Are there any antiviruses that are known to be > > > compatible with PostgreSQL/win32? > > > > All my boxes (2 build farm members, 1 production server, and the laptop > > on which the official releases are built and tested) run Sophos Anti > > Virus (http://www.sophos.com/products/es/endpoint/sav.html), with no > > problems. > > > > Regards, Dave > > > > ---------------------------(end of broadcast)--------------------------- > > TIP 6: explain analyze is your friend > > ---------------------------(end of broadcast)--------------------------- > TIP 5: don't forget to increase your free space map settings ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
