[pgpool-general: 1694] Re: pgpool and failover

Tatsuo Ishii ishii at postgresql.org
Wed May 8 17:09:52 JST 2013


> I am testing pgpool with streaming replication. There is one master and one slave. When I shut down the master, the requests were redirected to the slave. So far so good. I want to test a few more scenarios. Now that I have the primary master up, how do I make pgpool send connections to the master? It is still sending all requests to the slave.

I'm not sure what you want to test, but...

Pgpool-II always makes connections to master and slaves. If the query
is writing one(or any query which is not allowed to be sent to slave),
then it will be sent to the master. Such queries include DDLs(like
CREATE TABLE) and DML(like INSERT).
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp


More information about the pgpool-general mailing list