On Mon, 22 Aug 2011 12:41:13 +0200 Olivier NOEL <[email protected]> wrote:
> 2011/8/22 Toshihiro Kitagawa <[email protected]>: > > On Mon, 22 Aug 2011 11:52:35 +0200 > > Olivier NOEL <[email protected]> wrote: > > > >> 2011/8/22 Olivier NOEL <[email protected]>: > >> > 2011/8/22 Olivier NOEL <[email protected]>: > >> >>> 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 _______________________________________________ Pgpool-general mailing list [email protected] http://pgfoundry.org/mailman/listinfo/pgpool-general
