[Pgpool-general] PGPOOL-II and FUNCTIONS

Luis Alberto Pérez Paz midriasis at gmail.com
Mon Mar 10 18:05:06 UTC 2008


Thanks for your answer Tatsou.

I think that there's a bug in the replicate_select function in pgpool-ii
v2.0.1

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??

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)
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://pgfoundry.org/pipermail/pgpool-general/attachments/20080310/190e9fe1/attachment.html 


More information about the Pgpool-general mailing list