Hello,
I have a problem where occasionally an app does not close its connection to PostgreSQL. I am trying to track down where and why this is happening, but in the meantime it is messing with the operation of other apps since at times, the connection count can get quite high and therefore no new connections are available.
While tracking down the real problem, I wanted to see if the main part of the app can check for orphaned, this part I know how to do, and then closed any connections that should not be open.
I would prefer to use the application_name field but could use the PID if absolutely necessary.
I presume this would have to be a SQL command, or something else but I do not have any idea what it would be.
Any recommends on this please?
Tim