Postgresql many processes in idle status

[socmss]

Hi support team, 

We´ve upgrade our confluence server to 7.20 and now when we tried to start the services we faced with too many postgresql processes in idle status.

Could you help us?

Thanks in advance.

Regards.

[Srinatha Tondihal]

Hi @socmss ,

Welcome to Atlassian community. 

In server.xml file while defining the resource connection you have an option to set MaxIdle time. What is this value set to ? The below KB has the info, you might want to check on the same. 

• Surviving-database-connection-closures 

Thanks,

Srinath T