The following bug has been logged online:

Bug reference: 2780
Logged by: Thomas H.
Email address: me (AT) alternize (DOT) com
PostgreSQL version: 8.2rc1
Operating system: windows 2003 standard
Description: could not fsync segment 0
Details:

still seeing lots of these errors on rc1 when doing bulk data load:

2006-11-26 04:34:30 [2124] LOG: could not fsync segment 0 of relation
1663/16692/2176087: Permission denied
2006-11-26 04:34:30 [2124] ERROR: storage sync failed on magnetic disk:
Permission denied

2006-11-26 04:36:41 [2124] LOG: could not fsync segment 0 of relation
1663/16692/2176107: Permission denied
2006-11-26 04:36:41 [2124] ERROR: storage sync failed on magnetic disk:
Permission denied

2006-11-26 04:38:47 [2124] LOG: could not fsync segment 0 of relation
1663/16692/2176119: Permission denied
2006-11-26 04:38:47 [2124] ERROR: storage sync failed on magnetic disk:
Permission denied

2006-11-26 04:43:43 [2124] LOG: could not fsync segment 0 of relation
1663/16692/2176158: Permission denied
2006-11-26 04:43:43 [2124] ERROR: storage sync failed on magnetic disk:
Permission denied

2006-11-26 04:59:39 [2124] LOG: could not fsync segment 0 of relation
1663/16692/2176296: Permission denied
2006-11-26 04:59:39 [2124] ERROR: storage sync failed on magnetic disk:
Permission denied
2006-11-26 04:59:40 [2124] LOG: could not fsync segment 0 of relation
1663/16692/2176296: Permission denied
2006-11-26 04:59:40 [2124] ERROR: storage sync failed on magnetic disk:
Permission denied
2006-11-26 04:59:41 [2124] LOG: could not fsync segment 0 of relation
1663/16692/2176296: Permission denied
2006-11-26 04:59:41 [2124] ERROR: storage sync failed on magnetic disk:
Permission denied
2006-11-26 04:59:42 [2124] LOG: could not fsync segment 0 of relation
1663/16692/2176296: Permission denied
2006-11-26 04:59:42 [2124] ERROR: storage sync failed on magnetic disk:
Permission denied
2006-11-26 04:59:43 [2124] LOG: could not fsync segment 0 of relation
1663/16692/2176296: Permission denied
2006-11-26 04:59:43 [2124] ERROR: storage sync failed on magnetic disk:
Permission denied
2006-11-26 04:59:44 [2124] LOG: could not fsync segment 0 of relation
1663/16692/2176296: Permission denied
2006-11-26 04:59:44 [2124] ERROR: storage sync failed on magnetic disk:
Permission denied
2006-11-26 04:59:45 [2124] LOG: could not fsync segment 0 of relation
1663/16692/2176296: Permission denied
2006-11-26 04:59:45 [2124] ERROR: storage sync failed on magnetic disk:
Permission denied
2006-11-26 04:59:46 [2124] LOG: could not fsync segment 0 of relation
1663/16692/2176296: Permission denied
2006-11-26 04:59:46 [2124] ERROR: storage sync failed on magnetic disk:
Permission denied
2006-11-26 04:59:47 [2124] LOG: could not fsync segment 0 of relation
1663/16692/2176296: Permission denied
2006-11-26 04:59:47 [2124] ERROR: storage sync failed on magnetic disk:
Permission denied
2006-11-26 04:59:48 [2124] LOG: could not fsync segment 0 of relation
1663/16692/2176296: Permission denied


all other problems i've been seeing in the earlier builds seem to be fixed.
thanks for the great work!

- thomas

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend