Thanks!<br>Just from learning perspective I raised previous 2nd question. I think there should be 6 cases:<br><ol><li>pgpool-II+master server+ warm-standby server+ file-based log shipping method between master and standby</li>
<li>pgpool-II+master server+ warm-standby server+ stream replication method between master and standby</li><li>pgpool-II+master server+ warm-standby server+ synchonous replication method between master and standby</li><li>
pgpool-II+master server+ hot-standby server+ file-based log shipping method between master and standby</li><li>pgpool-II+master server+ hot-standby server+ stream replication method between master and standby</li><li>pgpool-II+master server+ hot-standby server+ synchonous replication method between master and standby</li>
</ol>I noticed the tutorial of <a href="http://www.pgpool.net/pgpool-web/pgpool-II/doc/pgpool-en.html" target="_blank">http://www.pgpool.net/pgpool-web/pgpool-II/doc/pgpool-en.html</a> falls into case 5. From that tutorial I assumed pgpool could be configured to support case 2,3,5,6 by using master-slave mode combined with load balancing mode. Is that right? Maybe I could have a try.<br>
I understand people using warm-standby for HA, and hot-standby for load balancing, or OLAP on standby to seperate work-load from master.<br><br><br><div class="gmail_quote">On Tue, Feb 28, 2012 at 9:01 AM, Tatsuo Ishii <span dir="ltr"><<a href="mailto:ishii@postgresql.org">ishii@postgresql.org</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0pt 0pt 0pt 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div class="im">> Hi, Friends,<br>
> I've two questions:<br>
> 1. What's the real meanings of "Replication mode"? I noticed there is no<br>
> much more explaination at pgpool-II manual (English)<br>
</div>> <<a href="http://www.pgpool.net/pgpool-web/pgpool-II/doc/pgpool-en.html" target="_blank">http://www.pgpool.net/pgpool-web/pgpool-II/doc/pgpool-en.html</a>>, what's the<br>
<div class="im">> difference between "Replication mode" and "Master-slave mode"? Should I<br>
> understand "Replication mode" as "pgpool-ii sends DML sentences just like<br>
> Inserts to two backends postgresql?"<br>
<br>
</div>Right.<br>
<div class="im"><br>
> 2. I know I could configure Postgresql9.1 warm-standby using file-based<br>
> log shiping, stream replication or Synchronous Replication. From this<br>
> tutorial For pgpool-II 3.1 and PostgreSQL<br>
</div>> 9.1<<a href="http://www.pgpool.net/pgpool-web/contrib_docs/simple_sr_setting_3.1/index.html" target="_blank">http://www.pgpool.net/pgpool-web/contrib_docs/simple_sr_setting_3.1/index.html</a>>,<br>
<div class="im">> I know how to configure pgpool supporting stream replication between master<br>
> and warm-standby. My question is it seems pgpool-ii doesn't support<br>
> file-based log shiping method between master and warm-standby, is that<br>
> right? Because I could not select Master-slave mode for it only support<br>
> slony or stream. And I also don't know whether should I use replication<br>
> mode in pgpool.conf.<br>
> Thanks!<br>
<br>
</div>I have never tried warm standby with pgpool but master-slave + slony<br>
should be able to work with it. BTW, why do you need warm standby<br>
anyway? Is tehre any reason not to use streaming replication?<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>
</blockquote></div><br>