We have an Office application which have front end in java and using alfresco content management engine and are using postgresql database 9.6. The problem is that the application create a db connection with DB server when user access the application. The application and db server could not close the connection when user logoff the application. We have already set the max_connection= 1000 but when when connection reach to 950 application not respond and we have to restart both the tomcat and db server postges sql server 9.6