Postgresql many processes in idle status

Question

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 · Answer

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