[pgpool-general: 1881] pgpool, failover with streaming replication

Jayadevan M jayadevan.maymala at ibsplc.com
Tue Jul 9 13:08:52 JST 2013


Hello all,

I am testing pgpool failover for PostgreSQL with streaming replication. When I shut down the master server, pgpool executed the failover script and promoted the slave - i.e. it created the trigger file and slave restarted. But I had to restart pgpool so that it would redirect new requests to the slave. What parameters would impact this behavior - i.e. when a new request comes in, redirect it to the slave (now master)?

Regards,
Jayadevan



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."
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20130709/76c40e04/attachment.html>


More information about the pgpool-general mailing list