One possibility is client_idle_limit. -- Tatsuo Ishii SRA OSS, Inc. Japan English: http://www.sraoss.co.jp/index_en.php Japanese: http://www.sraoss.co.jp
> I have found that sometimes the client connections get disconnected and the > new ones are established. What I do is I get the PIDs using "pcp_proc_count" > before running "pcp_attach_node" and then run "pcp_proc_count" to check if > the PIDs remain same. I found that the behaviour is random. When can this > happen? > > > ________________________________ > From: Tatsuo Ishii <is...@sraoss.co.jp> > To: singh.gurj...@gmail.com > Cc: pgpool-general@pgfoundry.org; pgpool-hack...@pgfoundry.org > Sent: Thursday, August 11, 2011 6:11 AM > Subject: Re: [Pgpool-general] pgpool limitations > >>> > > Is there something in the works to enable this, or is this feature >>> still in >>> > > design phase? If it is already being/been developed, I wish to know if >>> this >>> > > can be back-patched to a point release of pgpool 3.0.x. >>> > >>> > It has been already in pgpool-II 3.1 alpha version. >>> > Currently there's no plan to back-patching to 3.0.x. >>> >>> I certainly hope we won't backpatch a new feature. That would be insane. >>> >> >> I don't consider this a new feature. I'd say this is unexpected side-effect >> (a.k.a bug) of pcp_attach_node, since nowhere in the docs does is say that >> invoking pcp_attach_node would drop all client connections. > > This behavior has not been changed since pcp_attach_node was born in > 2006. Moreover, the enhancement in 3.1 is only for steaming > replication mode. Other modes including replication mode does not take > advantage of this. > -- > Tatsuo Ishii > SRA OSS, Inc. Japan > English: http://www.sraoss.co.jp/index_en.php > Japanese: http://www.sraoss.co.jp > _______________________________________________ > Pgpool-general mailing list > Pgpool-general@pgfoundry.org > http://pgfoundry.org/mailman/listinfo/pgpool-general _______________________________________________ Pgpool-general mailing list Pgpool-general@pgfoundry.org http://pgfoundry.org/mailman/listinfo/pgpool-general