[pgpool-general: 7891] Re: Recovery without disconnect

[Tatsuo Ishii]

> When I have a postgresql node fail pgpool switches the primary node as it should. However I have found that any existing database connections get reset. I can see how this may be required given that the socket from pgpool to the backend needs to be recreated. Is this expected or is there a way to configure pgpool to keep database connections open across failures?

Yes, it's an expected behavior and there's no way to avoid it.

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