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 failed
2006-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" succeeded
2006-06-15 15:05:49 NOTICE: truncate of "public"."company" succeeded
2006-06-15 15:05:49 NOTICE: truncate of "public"."area" succeeded
2006-06-15 15:05:49 NOTICE: truncate of "public"."rate" succeeded
2006-06-15 15:05:49 NOTICE: truncate of "public"."brand" succeeded
2006-06-15 15:05:55 NOTICE: truncate of "public"."cata" succeeded
2006-06-15 15:05:55 NOTICE: truncate of "public"."city" succeeded
2006-06-15 15:05:56 NOTICE: truncate of "public"."clm" succeeded
2006-06-15 15:05:58 NOTICE: truncate of "public"."itemclass" succeeded
2006-06-15 15:05:58 NOTICE: truncate of "public"."room" succeeded
2006-06-15 15:05:59 NOTICE: truncate of "public"."roomitemclass" succeeded
2006-06-15 15:05:59 NOTICE: truncate of "public"."type" succeeded
2006-06-15 15:06:00 NOTICE: truncate of "public"."content" succeeded
2006-06-15 15:06:43 LOG: autovacuum: processing database "postgres"
2006-06-15 15:07:11 NOTICE: truncate of "public"."contentlog" succeeded
2006-06-15 15:07:43 LOG: autovacuum: processing database "main"
2006-06-15 15:08:30 NOTICE: truncate of "public"."country" succeeded
2006-06-15 15:08:31 NOTICE: truncate of "public"."document" succeeded
2006-06-15 15:08:38 LOG: could not fsync segment 1 of relation 1663/59085/59885: Permission denied
2006-06-15 15:08:38 ERROR: storage sync failed on magnetic disk: Permission denied
2006-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" succeeded
2006-06-15 15:05:49 NOTICE: truncate of "public"."company" succeeded
2006-06-15 15:05:49 NOTICE: truncate of "public"."area" succeeded
2006-06-15 15:05:49 NOTICE: truncate of "public"."rate" succeeded
2006-06-15 15:05:49 NOTICE: truncate of "public"."brand" succeeded
2006-06-15 15:05:55 NOTICE: truncate of "public"."cata" succeeded
2006-06-15 15:05:55 NOTICE: truncate of "public"."city" succeeded
2006-06-15 15:05:56 NOTICE: truncate of "public"."clm" succeeded
2006-06-15 15:05:58 NOTICE: truncate of "public"."itemclass" succeeded
2006-06-15 15:05:58 NOTICE: truncate of "public"."room" succeeded
2006-06-15 15:05:59 NOTICE: truncate of "public"."roomitemclass" succeeded
2006-06-15 15:05:59 NOTICE: truncate of "public"."type" succeeded
2006-06-15 15:06:00 NOTICE: truncate of "public"."content" succeeded
2006-06-15 15:06:43 LOG: autovacuum: processing database "postgres"
2006-06-15 15:07:11 NOTICE: truncate of "public"."contentlog" succeeded
2006-06-15 15:07:43 LOG: autovacuum: processing database "main"
2006-06-15 15:08:30 NOTICE: truncate of "public"."country" succeeded
2006-06-15 15:08:31 NOTICE: truncate of "public"."document" succeeded
2006-06-15 15:08:38 LOG: could not fsync segment 1 of relation 1663/59085/59885: Permission denied
2006-06-15 15:08:38 ERROR: storage sync failed on magnetic disk: Permission denied
Thanks for your help,
Matt Beveridge
Matt Beveridge
Express yourself instantly with MSN Messenger! MSN Messenger
_______________________________________________ Slony1-general mailing list [email protected] http://gborg.postgresql.org/mailman/listinfo/slony1-general
