<div dir="ltr">I suppose you could also use synchronous replication in postgresql for replication, and let pgpool do the load balance. Am I right?<div><br></div></div><div class="gmail_extra"><br><br><div class="gmail_quote">
On 30 May 2014 07:34, Sergey Arlashin <span dir="ltr"><<a href="mailto:sergeyarl.maillist@gmail.com" target="_blank">sergeyarl.maillist@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
Thank you!<br>
<div class="HOEnZb"><div class="h5"><br>
<br>
On May 30, 2014, at 9:28 AM, Tatsuo Ishii <<a href="mailto:ishii@postgresql.org">ishii@postgresql.org</a>> wrote:<br>
<br>
>> Ah, ok. Actually I cannot use native replication at the moment. We use streaming and it fully meets our requirements.<br>
>> So I suppose in case of streaming replication I need to load the dump directly to the master postgresql backend. And therefore another question - do I need to stop pgpool before loading dump to the master directly ?<br>
><br>
> No, you don't.<br>
><br>
> Best regards,<br>
> --<br>
> Tatsuo Ishii<br>
> SRA OSS, Inc. Japan<br>
> English: <a href="http://www.sraoss.co.jp/index_en.php" target="_blank">http://www.sraoss.co.jp/index_en.php</a><br>
> Japanese: <a href="http://www.sraoss.co.jp" target="_blank">http://www.sraoss.co.jp</a><br>
<br>
_______________________________________________<br>
pgpool-general mailing list<br>
<a href="mailto:pgpool-general@pgpool.net">pgpool-general@pgpool.net</a><br>
<a href="http://www.pgpool.net/mailman/listinfo/pgpool-general" target="_blank">http://www.pgpool.net/mailman/listinfo/pgpool-general</a><br>
</div></div></blockquote></div><br><br clear="all"><div><br></div>-- <br><div dir="ltr"><span style="font-family:Arial,sans-serif;line-height:13px;font-weight:bold;color:rgb(68,68,68);text-transform:uppercase;font-size:8pt;margin-left:60px">JOSE MARIA ALVAREZ</span><br style="color:rgb(0,0,0);font-family:Arial,sans-serif;font-size:medium;line-height:13px">
<span style="font-family:Arial,sans-serif;line-height:13px;font-size:8pt;color:rgb(78,78,86);text-transform:uppercase;margin-left:60px">SYSTEMS ARCHITECT</span><br style="color:rgb(0,0,0);font-family:Arial,sans-serif;font-size:medium;line-height:13px">
<br style="color:rgb(0,0,0);font-family:Arial,sans-serif;font-size:medium;line-height:13px"><span style="font-family:Arial,sans-serif;line-height:13px;font-size:8pt;color:rgb(78,78,86);margin-left:60px">Tel: +34 91 103 21 60 (Ext. 316)</span><br style="color:rgb(0,0,0);font-family:Arial,sans-serif;font-size:medium;line-height:13px">
<span style="font-family:Arial,sans-serif;line-height:13px;font-size:8pt;color:rgb(78,78,86);margin-left:60px">Móvil: +34 +34 637 792 144 </span><br style="color:rgb(0,0,0);font-family:Arial,sans-serif;font-size:medium;line-height:13px">
<span style="font-family:Arial,sans-serif;line-height:13px;font-size:8pt;color:rgb(78,78,86);margin-left:60px">C/ Arroyo de los Prados, 5 - P.I. Las Arenas </span><br style="color:rgb(0,0,0);font-family:Arial,sans-serif;font-size:medium;line-height:13px">
<span style="font-family:Arial,sans-serif;line-height:13px;font-size:8pt;color:rgb(78,78,86);margin-left:60px">28320 Pinto - Madrid. Spain </span><br style="color:rgb(0,0,0);font-family:Arial,sans-serif;font-size:medium;line-height:13px">
<br style="color:rgb(0,0,0);font-family:Arial,sans-serif;font-size:medium;line-height:13px"><span style="color:rgb(0,0,0);font-family:Arial,sans-serif;line-height:13px;font-size:8pt;margin-left:60px"><a href="http://www.brightstar-2020.es/" style="text-decoration:none;color:rgb(37,88,126)" target="_blank">www.brightstar-2020.es</a></span><br style="color:rgb(0,0,0);font-family:Arial,sans-serif;font-size:medium;line-height:13px">
<br style="color:rgb(0,0,0);font-family:Arial,sans-serif;font-size:medium;line-height:13px"><img src="http://www.brightstar-2020.es/logo-email.jpg" style="color:rgb(0,0,0);font-family:Arial,sans-serif;font-size:medium;line-height:13px"><br>
</div>
</div>
<br>
<p style="color:rgb(34,34,34);font-family:arial,sans-serif;background-color:rgb(255,255,255)"><span style="font-family:Verdana,sans-serif;color:rgb(153,153,153);font-size:8pt"><font face="Times New Roman">Brightstar 20:20 mobile<font face="Times New Roman"></font><br>C/ Arroyo de los Prados. 5. P.I. Las Arenas. 28320 (MADRID) Spain</font></span></p><span style="background-color:rgb(255,255,255);font-family:Verdana,sans-serif;color:rgb(153,153,153);font-size:8pt"><p></p><hr><p style="margin:0cm 0cm 0pt"><span style="font-size:8pt"><font color="#999999" face="Times New Roman">This e-mail has been sent by Brightstar 20:20 mobile.</font></span></p><p style="margin:0cm 0cm 0pt"><span style="font-family:'Times New Roman';font-size:8pt">Telephone number:</span><span style="font-family:'Times New Roman';font-size:8pt"> </span><a value="+441270412020" style="font-family:'Times New Roman';font-size:8pt;color:rgb(17,85,204)">+34 911 032 160</a><span style="font-family:'Times New Roman';font-size:8pt">.</span></p><p style="margin:0cm 0cm 0pt"><span style="font-size:8pt"><font face="Times New Roman"><font color="#999999">Please see our website for further information,</font> <a href="http://www.2020mobile.com/confidentiality-notice/" style="color:rgb(17,85,204)" target="_blank">www.brightstar-<WBR>2020.es/</a></font></span></p><p><font face="Times New Roman"></font></p><font size="+0"></font><p></p><p></p><p></p><p></p><p></p><p></p><p></p><p></p><p></p></span><font size="+0" style="color:rgb(34,34,34);font-family:arial,sans-serif;background-color:rgb(255,255,255)"></font><span style="color:rgb(34,34,34);font-family:arial,sans-serif;background-color:rgb(255,255,255)"></span><p style="color:rgb(34,34,34);font-family:arial,sans-serif;background-color:rgb(255,255,255)"></p><p style="color:rgb(34,34,34);font-family:arial,sans-serif;background-color:rgb(255,255,255)"></p><p style="color:rgb(34,34,34);font-family:arial,sans-serif;background-color:rgb(255,255,255)"><font size="1"><font color="#c0c0c0"><font face="Times New Roman"><font color="#c0c0c0"></font><span style="color:blue"></span></font></font></font></p><p style="color:rgb(34,34,34);font-family:arial,sans-serif;background-color:rgb(255,255,255)"><strong><font face="Times New Roman"><font size="1"><span style="font-family:Webdings;color:green">P</span><span style="color:green"> please consider the environment and only print this if required</span></font></font></strong></p><p style="color:rgb(34,34,34);font-family:arial,sans-serif;background-color:rgb(255,255,255)"></p><p style="color:rgb(34,34,34);font-family:arial,sans-serif;background-color:rgb(255,255,255)"></p><p style="color:rgb(34,34,34);font-family:arial,sans-serif;background-color:rgb(255,255,255)"></p><p style="color:rgb(34,34,34);font-family:arial,sans-serif;background-color:rgb(255,255,255)"></p><span style="color:rgb(34,34,34);font-family:arial,sans-serif;background-color:rgb(255,255,255)"></span><font size="+0" style="color:rgb(34,34,34);font-family:arial,sans-serif;background-color:rgb(255,255,255)"></font><span style="color:rgb(34,34,34);font-family:arial,sans-serif;background-color:rgb(255,255,255)"></span><font size="+0" style="color:rgb(34,34,34);font-family:arial,sans-serif;background-color:rgb(255,255,255)"></font><span style="color:rgb(34,34,34);font-family:arial,sans-serif;background-color:rgb(255,255,255)"></span><p style="color:rgb(34,34,34);font-family:arial,sans-serif;background-color:rgb(255,255,255)"></p><p style="color:rgb(34,34,34);font-family:arial,sans-serif;background-color:rgb(255,255,255)"></p><span style="color:rgb(34,34,34);font-family:arial,sans-serif;background-color:rgb(255,255,255)"></span><span style="color:rgb(34,34,34);font-family:arial,sans-serif;background-color:rgb(255,255,255)"></span><p style="color:rgb(34,34,34);font-family:arial,sans-serif;background-color:rgb(255,255,255)"></p><p style="color:rgb(34,34,34);font-family:arial,sans-serif;background-color:rgb(255,255,255)"></p><span style="color:rgb(34,34,34);font-family:arial,sans-serif;background-color:rgb(255,255,255)"></span><span style="color:rgb(34,34,34);font-family:arial,sans-serif;background-color:rgb(255,255,255)"></span><p style="color:rgb(34,34,34);font-family:arial,sans-serif;background-color:rgb(255,255,255);margin:0cm 0cm 0pt"><span style="font-family:Verdana,sans-serif;color:rgb(153,153,153);font-size:8pt"></span></p><p style="color:rgb(34,34,34);font-family:arial,sans-serif;background-color:rgb(255,255,255)"><strong><font face="Times New Roman"><font size="3"><span style="color:green"></span></font></font></strong></p><font face="Times New Roman" style="color:rgb(34,34,34);background-color:rgb(255,255,255)"></font><span style="color:rgb(34,34,34);font-family:arial,sans-serif;background-color:rgb(255,255,255)"></span><hr style="color:rgb(34,34,34);font-family:arial,sans-serif;background-color:rgb(255,255,255)"><p style="color:rgb(34,34,34);font-family:arial,sans-serif;background-color:rgb(255,255,255)"><br></p>