Yes, I have set backend_weight0 = 0 and backend_weight1 = 1. So that all SELECT queries go to Standby. and even though the backend_weight0 (Master) is set to 0, the INSERT/DELETE/UPDATE queries will be handled by Master only.
I'll enable query log and confirm this. Thanks ________________________________ From: Guillaume Lelarge <[email protected]> To: Sandeep Thakkar <[email protected]> Cc: [email protected] Sent: Fri, January 14, 2011 3:05:07 PM Subject: Re: [Pgpool-general] Query regarding load balancing Le 14/01/2011 10:16, Sandeep Thakkar a écrit : > [...] > I'm using PG9.0 and pgpool-3.0.1 and I have setup a master and a standby > servers. Standby server is configured for Hot Standby and Stream replication. > I'm using pgpool in Master/Slave mode with Load balancing mode on. I would > like > > to execute few queries using pgpool port and I would like to see which server > has served that query. I think, the read only queries should go to Standby > and > Insert/Update and some others should go to the Master. But how do I confirm > this? I checked the server logs, but I did not find anything. In pgpool log, > I > could see information like "wait_for_query_response", but I did not > understand. > > The easier way is to enable queries log on both PostgreSQL nodes. BTW, read queries are executed by the master node or by the standby node, not only by the node unless you set the weight to 0 on the master node configuration. -- Guillaume http://www.postgresql.fr http://dalibo.com
_______________________________________________ Pgpool-general mailing list [email protected] http://pgfoundry.org/mailman/listinfo/pgpool-general
