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

[Olivier NOEL]

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

Ok I will give it a try and give you a feedback.

Thanks !!

> --
> Toshihiro Kitagawa
> SRA OSS, Inc. Japan
>
>