Postgres Pro
Downloads
Home   >   mailing lists

Thread: Doubt in pgbouncer

Doubt in pgbouncer

From
Rama Krishnan
Date:

Hi All,

What is the limit value for fixing connection timeout issues?

As i searched in google and verified pgbouncer document

client_login_timeout

If a client connects but does not manage to log in in this amount of time, it will be disconnected. Mainly needed to avoid dead connections stalling SUSPEND and thus online restart. [seconds]

Default: 60.0


Can you pls suggest the best value ? or how to decide this parameter value



Regards

A.Rama Krishnan

Re: Doubt in pgbouncer

From
Ninad Shah
Date:
There is no equation to determine the best value. It depends on your environment.


Regards,
Ninad Shah

On Wed, 3 Nov 2021 at 19:18, Rama Krishnan <raghuldrag@gmail.com> wrote:

Hi All,

What is the limit value for fixing connection timeout issues?

As i searched in google and verified pgbouncer document

client_login_timeout

If a client connects but does not manage to log in in this amount of time, it will be disconnected. Mainly needed to avoid dead connections stalling SUSPEND and thus online restart. [seconds]

Default: 60.0


Can you pls suggest the best value ? or how to decide this parameter value



Regards

A.Rama Krishnan