> "white_function_list > > ... In master slave mode, SELECTs are sent to master(primary) only. " > (Taken from pgpool-II web site) > > > > Is this true? What about when working with streaming replication where I > want the hot-standby to run read-only queries (SELECTs)?
Sorry for poor English. Actually pgpool-II allows the hot-standby to run read-only queries (SELECTs). Following is revised description. Please do not hesitate to enhance it! <dt>white_function_list <dd> <p> Specify comma separated function name list, those <strong>do not</strong> update database. SELECTs using functions not specified in this list are not load balanced, replicated if in replication mode. In master slave mode, such SELECTs are sent to master(primary) only. -- Tatsuo Ishii SRA OSS, Inc. Japan English: http://www.sraoss.co.jp/index_en.php Japanese: http://www.sraoss.co.jp _______________________________________________ Pgpool-general mailing list [email protected] http://pgfoundry.org/mailman/listinfo/pgpool-general
