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

Tatsuo Ishii ishii at postgresql.org
Wed May 8 19:26:19 JST 2013

> Hi,
> I have already figured out how to do this (using -D ) option. Anyway, a related query. If I have load balancing set to off, it will send everything to the master alone, right?

Mostly correct. Exceptions are transactional command including BEGIN,
COMMIT and commands registered in "reset_query_list".
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp

> Regards,
> Jayadevan
>>-----Original Message-----
>>From: Tatsuo Ishii [mailto:ishii at postgresql.org]
>>Sent: Wednesday, May 08, 2013 1:40 PM
>>To: Jayadevan M
>>Cc: pgpool-general at pgpool.net
>>Subject: Re: [pgpool-general: 1681] pgpool and failover
>>> 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
> DISCLAIMER: "The information in this e-mail and any attachment is intended only for the person to whom it is addressed and may contain confidential and/or privileged material. If you have received this e-mail in error, kindly contact the sender and destroy all copies of the original communication. IBS makes no warranty, express or implied, nor guarantees the accuracy, adequacy or completeness of the information contained in this email or any attachment and is not liable for any errors, defects, omissions, viruses or for resultant loss or damage, if any, direct or indirect."

More information about the pgpool-general mailing list