Could you add an extra server in the same location as your master to feed from?  Or perhaps you could make use of the log shipping feature: http://slony.info/documentation/logshipping.html

 
      From: Sebastien Marchand <smarchand at sgo.fr>
 To: 'Vick Khera' <vivek at khera.org> 
Cc: 'slony' <slony1-general at lists.slony.info> 
 Sent: Thursday, 8 January 2015, 8:31
 Subject: Re: [Slony1-general] too much work !
   
#yiv1516855320 #yiv1516855320 -- _filtered #yiv1516855320 {font-family:Calibri;panose-1:2 15 5 2 2 2 4 3 2 4;} _filtered #yiv1516855320 {font-family:Tahoma;panose-1:2 11 6 4 3 5 4 4 2 4;}#yiv1516855320 #yiv1516855320 p.yiv1516855320MsoNormal, #yiv1516855320 li.yiv1516855320MsoNormal, #yiv1516855320 div.yiv1516855320MsoNormal {margin:0cm;margin-bottom:.0001pt;font-size:12.0pt;}#yiv1516855320 a:link, #yiv1516855320 span.yiv1516855320MsoHyperlink {color:blue;text-decoration:underline;}#yiv1516855320 a:visited, #yiv1516855320 span.yiv1516855320MsoHyperlinkFollowed {color:purple;text-decoration:underline;}#yiv1516855320 span.yiv1516855320EmailStyle17 {color:#1F497D;}#yiv1516855320 .yiv1516855320MsoChpDefault {} _filtered #yiv1516855320 {margin:70.85pt 70.85pt 70.85pt 70.85pt;}#yiv1516855320 div.yiv1516855320WordSection1 {}#yiv1516855320 I can’t do this, only my master have a good bandwith (up and down), others server are in warehouse.   De : Vick Khera [mailto:vivek at khera.org] 
Envoyé : mercredi 7 janvier 2015 18:40
À : Sebastien Marchand
Cc : slony
Objet : Re: [Slony1-general] too much work !  

  On Wed, Jan 7, 2015 at 5:05 AM, Sebastien Marchand <smarchand at sgo.fr> wrote:Slony work well but i found slony work too on pg, too many access, too many process,…For information slony work in wan with 17 nodes, and 18 replications.
If you have 17 replicas for "A", do not have them all directly replicate from the master. set up a tree structure.  
_______________________________________________
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/20150108/0300401b/attachment.htm