Hello all,  I am attempting to replicate my first attempt at my 4GB db on Win XP, PG8.1.4 with a simple Master slave setup.  Slony version is from http://developer.pgadmin.org/~hiroshi/Slony-I following Robert Treat's Crib notes:http://people.planetpostgresql.org/xzilla/index.php?/archives/200-Alpha-testing-Slony-on-win32-Crib-Notes.html
I have a single large table (>3GB) that fails to replicate. If I omit the table the replication works fine.
the error occurs on the initial copy for that table (document). Here is the log output when the error occurs.
 
2006-06-15 15:05:12 ERROR:  COPY from stdin failed: Slony-I: copy set operation failed2006-06-15 15:05:12 CONTEXT:  COPY document, line 3184: ""2006-06-15 15:05:12 STATEMENT:  select "_testcluster".prepareTableForCopy(16); copy "public"."document" ("documentid","documentfolderid","documentname","documentfile","contenttype") from stdin; 2006-06-15 15:05:27 LOG:  autovacuum: processing database "slave"2006-06-15 15:05:48 NOTICE:  truncate of "public"."accesstype" succeeded2006-06-15 15:05:49 NOTICE:  truncate of "public"."company" succeeded2006-06-15 15:05:49 NOTICE:  truncate of "public"."area" succeeded2006-06-15 15:05:49 NOTICE:  truncate of "public"."rate" succeeded2006-06-15 15:05:49 NOTICE:  truncate of "public"."brand" succeeded2006-06-15 15:05:55 NOTICE:  truncate of "public"."cata" succeeded2006-06-15 15:05:55 NOTICE:  truncate of "public"."city" succeeded2006-06-15 15:05:56 NOTICE:  truncate of "public"."clm" succeeded2006-06-15 15:05:58 NOTICE:  truncate of "public"."itemclass" succeeded2006-06-15 15:05:58 NOTICE:  truncate of "public"."room" succeeded2006-06-15 15:05:59 NOTICE:  truncate of "public"."roomitemclass" succeeded2006-06-15 15:05:59 NOTICE:  truncate of "public"."type" succeeded2006-06-15 15:06:00 NOTICE:  truncate of "public"."content" succeeded2006-06-15 15:06:43 LOG:  autovacuum: processing database "postgres"2006-06-15 15:07:11 NOTICE:  truncate of "public"."contentlog" succeeded2006-06-15 15:07:43 LOG:  autovacuum: processing database "main"2006-06-15 15:08:30 NOTICE:  truncate of "public"."country" succeeded2006-06-15 15:08:31 NOTICE:  truncate of "public"."document" succeeded2006-06-15 15:08:38 LOG:  could not fsync segment 1 of relation 1663/59085/59885: Permission denied2006-06-15 15:08:38 ERROR:  storage sync failed on magnetic disk: Permission denied
 
Thanks for your help,Matt Beveridge
_________________________________________________________________
Express yourself instantly with MSN Messenger! Download today it's FREE!
http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://gborg.postgresql.org/pipermail/slony1-general/attachments/20060616/adfec403/attachment.html