title: Postgresql: Max connections: set application name eating connections
body: <p>many connections in PostgreSQL that eating connections limit, many of them named: PostgreSQL JDBC Driver, with a query: SET application_name = 'PostgreSQL JDBC Driver', please find attached image.</p>
  
  <p>causing: FATAL: sorry, too many clients already.
  max connections were 100, and I have increased to 150, but not solved!</p>
  
  <p>note that I am using ThingWorx platform which connects to PostgreSQL.</p>
  
  <p><img src="https://i.stack.imgur.com/uvFha.jpg" alt="postgresql sessions"></p>