[pgpool-general: 6988] Re: Postgresql secondary shutdown causes Pgpool restart?

[Takuma Hoshiai]

On Tue, 14 Apr 2020 08:25:48 +0800
hostmaster <hostmaster at mylinuxsite.com> wrote:

> Hi all,
> 
> I have a 2-node setup (2 pgpool and 2 Postgresql9.6)  If I stopped the
> Primary, pgpool responds immediately on 'show pool nodes' even though
> there is a fallback script to be executed.  

I think, sometimes pgpool don't response immedialty when primary is
sttoped too. It depends on the timing.

> However, when I stopped the Secondary, pgpool will fail on the first
> query of 'show pool nodes' with error like not TCP connection.
> Succeeding queries will succeed.  
> 
> So it appears pgpool will restart itself when the Secondary
> disconnects.  Is this a normal behaviour? How to prevent this?

Does 'pgpool will restart itself' mean that pgpool main process
is restarted? Could you share your pgpool.conf and pgpool.log?

Best Regards,

-- 
Takuma Hoshiai <hoshiai at sraoss.co.jp>