2011/8/22 Toshihiro Kitagawa <kitag...@sraoss.co.jp>: > On Mon, 22 Aug 2011 11:52:35 +0200 > Olivier NOEL <noli...@gmail.com> wrote: > >> 2011/8/22 Olivier NOEL <noli...@gmail.com>: >> > 2011/8/22 Olivier NOEL <noli...@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 > > _______________________________________________ Pgpool-general mailing list Pgpool-general@pgfoundry.org http://pgfoundry.org/mailman/listinfo/pgpool-general