Sure, The replicated_select in pgpool-ii v2.0.1 ( http://pgfoundry.org/frs/download.php/1521/pgpool-II-2.0.1.tar.gz) does not work. My configuration is: load_balance_mode = false replicate_select = true
Pgpool-ii v2.0.1 only sends the select to the first host. I trien with pgpool-ii v1.3 and replicated_select=true (with load_balance_mode = false) works great. I was looking on google and I think that it could has relation with: http://www.mail-archive.com/[email protected]/msg00085.html *That's because pgpool-i works as if replicate_select is always true.....*Maybe I'm confused with this. According to my tests in pgpool-i (v3.4.1) only if you set "replicated_select=true" it replicates the select. I tried with the CVS head version however I couldn't compile it: * make all-recursive make[1]: Entering directory `/home/luis/tmp/pgpool/pgpool-II' Making all in parser make[2]: Entering directory `/home/luis/tmp/pgpool/pgpool-II/parser' byacc -d gram.y byacc: e - line 142 of "gram.y", syntax error %name-prefix="base_yy" ^ make[2]: *** [gram.c] Error 1 make[2]: Leaving directory `/home/luis/tmp/pgpool/pgpool-II/parser' make[1]: *** [all-recursive] Error 1 make[1]: Leaving directory `/home/luis/tmp/pgpool/pgpool-II' make: *** [all] Error 2* Regards, On Mon, Mar 10, 2008 at 4:19 PM, Tatsuo Ishii <[EMAIL PROTECTED]> wrote: > > Thanks for your answer Tatsou. > > > > I think that there's a bug in the replicate_select function in pgpool-ii > > v2.0.1 > > Can you give more details? > > > I was trying with pgpool 3.4.1 (pgpool-i) and it works. However I think > that > > pgpool-ii is great! what version can you advice me try?? > > That's because pgpool-i works as if replicate_select is always true. > > Can you grab pgpool-II CVS Head and try it out? > -- > Tatsuo Ishii > SRA OSS, Inc. Japan > > > Best Regards, > > > > Luis Alberto Perez Paz > > > > > > > > On Sun, Mar 9, 2008 at 5:50 AM, Tatsuo Ishii <[EMAIL PROTECTED]> wrote: > > > > > > Hi everybody, > > > > > > > > Is possible with pgpool-ii (in replication mode) make replication of > > > called > > > > to functions?? > > > > > > > > I mean: > > > > > > > > ----> > psql1 > > > > > > > [select > > > > myfunction();] > > > > client --------> pgpool ----> psql2 > > > > [select myfunction();] [select > > > myfunction();] > > > > ----> > psql3 > > > > > > > [select > > > > myfunction();] > > > > > > Sure. > > > > > > load_balance_mode = false > > > replicate_select = true > > > > > > will do the trick. > > > -- > > > Tatsuo Ishii > > > SRA OSS, Inc. Japan > > > > > > > > > > > -- > > paz, amor y comprensión > > (1967-1994) > -- paz, amor y comprensión (1967-1994)
_______________________________________________ Pgpool-general mailing list [email protected] http://pgfoundry.org/mailman/listinfo/pgpool-general
