[Pgpool-general] Error with streaming/balancing / pgpool 3.0.4

[Toshihiro Kitagawa]

On Mon, 22 Aug 2011 12:41:13 +0200
Olivier NOEL <nolivfr at gmail.com> wrote:

> 2011/8/22 Toshihiro Kitagawa <kitagawa at sraoss.co.jp>:
> > On Mon, 22 Aug 2011 11:52:35 +0200
> > Olivier NOEL <nolivfr at gmail.com> wrote:
> >
> >> 2011/8/22 Olivier NOEL <nolivfr at gmail.com>:
> >> > 2011/8/22 Olivier NOEL <nolivfr at gmail.com>:
> >> >>> Yes, f and t are boolean values.
> >> >>> pgpool-II calls pgpool_walrecrunning() in postgres database.
> >> >>> Can you select pgpool_walrecrunning() in postgres database?
> >> >>
> >> >> I will try to import the sql to the postgres database.
> >> >
> >> > It works now
> >> >
> >> > 2011-08-22 11:38:12 LOG:   pid 10931: find_primary_node: primary node id is 0
> >> >
> >> > but Pgpool still sends DML and DDL queries to one slave, the second
> >> > one (node id 2) :
> >> >
> >
> > Did you execute user-defined function which contains DML or DDL?
> > If yes, you have to add the function name to black_function_list of pgpool.conf.
> 
> I have to put in the blacklist all the functions which contain DML/DDL
> ? I have 700+ functions...

There is white_function_list too, just in case.
In addition, pgpool-II 3.1 allows to use regular expressions in
black and white function list.

-- 
Toshihiro Kitagawa
SRA OSS, Inc. Japan