[pgpool-general: 6988] Re: Postgresql secondary shutdown causes Pgpool restart?
hoshiai at sraoss.co.jp
Fri Apr 17 13:25:33 JST 2020
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?
Takuma Hoshiai <hoshiai at sraoss.co.jp>
More information about the pgpool-general