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) : > > 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
I forgot the query on the second slave : postgres=> select pgpool_walrecrunning(); pgpool_walrecrunning ---------------------- t (1 ligne) Slave 1 : postgres=> select pgpool_walrecrunning(); pgpool_walrecrunning ---------------------- t (1 ligne) Master : postgres=# select pgpool_walrecrunning(); pgpool_walrecrunning ---------------------- f (1 ligne) _______________________________________________ Pgpool-general mailing list Pgpool-general@pgfoundry.org http://pgfoundry.org/mailman/listinfo/pgpool-general