[pgpool-general: 5580] Re: Are the existing connections dropped if active pgPool-II fails over to standby pgPool-II

[Sumeet Shukla]

Will the transactions be safely rolled back.
What is the possibility of transactions leaving database in a inconsistent
state

On 19-Jun-2017 9:25 PM, "Tatsuo Ishii" <ishii at sraoss.co.jp> wrote:

>    1. What happens when the active pgPool-II fails over to standby
>    pgPool-II

Standby Pgpool-II promotes to active one.

>    2. Are the existing connections dropped or transferred over to standby
>    pgPool-II by any means.

The existing connections are dropped because all Pgpool-II process
restart.

Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese:http://www.sraoss.co.jp
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20170619/f8dbd1ee/attachment.html>