>Again, mentioned it at very beginning. If I load whole 10M records all at
>once, records won't show even for 3 days. 


And again, as previously mentioned by myself and others. and your own finding in the error log, you do not have enough space for the postgresql wal file to handle 10 million inserts. 

 
Melvin Davidson 








________________________________
From: roctaiwan <nettreeinc at gmail.com>
To: slony1-general at lists.slony.info
Sent: Tuesday, September 29, 2009 11:00:17 PM
Subject: Re: [Slony1-general] copying large file won't get replicate


I found that if I broken the 10Million records into 4 pieces of files and
copy one at a time, then it will fix the problem. 

Again, mentioned it at very beginning. If I load whole 10M records all at
once, records won't show even for 3 days. 
-- 
View this message in context: http://www.nabble.com/copying-large-file-won%27t-get-replicate-tp25609853p25674659.html
Sent from the Slony-I -- General mailing list archive at Nabble.com.

_______________________________________________
Slony1-general mailing list
Slony1-general at lists.slony.info
http://lists.slony.info/mailman/listinfo/slony1-general



      
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.slony.info/pipermail/slony1-general/attachments/20090930/3e3dc553/attachment.htm