[pgpool-general: 5052] Re: PGPool - failover issue

[Tatsuo Ishii]

> Hi I have setup PGPool with Load Balancing and Postgres streaming relication (using postgres not PGPool replication).
> 
> Everything is as expected, but on failover from Primary to Standby, it appears that existing connections to PGPool/Postgres are then terminated. ie: the web application loses its connection to PGPool. I have to refresh my browser to re-connect to PGPool. I would have thought that on failover the application would continue working 'seamlessly' to the end user - without having to refresh browser sessions. Does PGPool not handle this ie: re-create a new connection to the new Master? Can this be configured in PGPool?
> 
> New connections obviously connect fine but its existing connections have these issues.
> 
> I also notice the same behaviour with PG Admin. If I have an SQL session open, the perform failover, then the sessions get a connection error.
> 
> Can this be configured in PGPool? Example of error in our application logs is below:

No. Existing connections are terminated when fail over happens.
Upcoming Pgpool-II 3.6 will keep sessions in some cases.

Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese:http://www.sraoss.co.jp