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

[Tatsuo Ishii]

> Will the transactions be safely rolled back.

Yes.

> What is the possibility of transactions leaving database in a inconsistent
> state

Nothing I can think of.

> 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