[Pgpool-general] PGPOOL-II and FUNCTIONS

[Luis Alberto Pérez Paz]

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/pgpool-general@pgfoundry.org/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 <ishii at sraoss.co.jp> 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 <ishii at sraoss.co.jp> 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)
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://pgfoundry.org/pipermail/pgpool-general/attachments/20080310/94872ddc/attachment-0001.html