[pgpool-general: 251] Re: Hi, Friends, what's the real meanings of "Replication mode"?

[Tatsuo Ishii]

> Hi, Friends,
>   I've two questions:
>   1. What's the real meanings of  "Replication mode"? I noticed there is no
> much more explaination at pgpool-II manual (English)
> <http://www.pgpool.net/pgpool-web/pgpool-II/doc/pgpool-en.html>, what's the
> difference between "Replication mode" and "Master-slave mode"? Should I
> understand "Replication mode" as "pgpool-ii sends DML sentences just like
> Inserts to two backends postgresql?"

Right.

>   2. I know I could configure Postgresql9.1 warm-standby using file-based
> log shiping, stream replication or Synchronous Replication. From this
> tutorial For pgpool-II 3.1 and PostgreSQL
> 9.1<http://www.pgpool.net/pgpool-web/contrib_docs/simple_sr_setting_3.1/index.html>,
> I know how to configure pgpool supporting stream replication between master
> and warm-standby. My question is it seems pgpool-ii doesn't support
> file-based log shiping method between master and warm-standby, is that
> right? Because I could not select Master-slave mode for it only support
> slony or stream. And I also don't know whether should I use replication
> mode in pgpool.conf.
>   Thanks!

I have never tried warm standby with pgpool but master-slave + slony
should be able to work with it. BTW, why do you need warm standby
anyway? Is tehre any reason not to use streaming replication?
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp