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) : 2011-08-22 11:38:47 DEBUG: pid 10963: wait_for_query_response: waiting for backend 2 completing the query 2011-08-22 11:38:47 LOG: pid 10963: pool_send_and_wait: Error or notice message from backend: : DB node id: 2 backend pid: 33857 statement: message: cannot execute UPDATE in a read-only transaction For the record, here is the backend part of my configuration file. backend_hostname0 = 'fpg01' backend_port0 = 5432 backend_weight0 = 1 backend_hostname1 = 'fpg02' backend_port1 = 5432 backend_weight1 = 2 backend_hostname2 = 'fpg03' backend_port2 = 5432 backend_weight2 = 2 >> -- >> Toshihiro Kitagawa >> SRA OSS, Inc. Japan >> >> > _______________________________________________ Pgpool-general mailing list [email protected] http://pgfoundry.org/mailman/listinfo/pgpool-general
