Idle connections not closing

[Nebu Pulickal]

I am having a postgresql database server and the idle connections are not closing themselves. They are increasing to large numbers as time passes and the web page is not loading. The code developer says that the code for closing these idleconnections are included in the code itself. But it is also not working. We have tried to close by giving several values to maxactive and maxidle. But none are working. I want to know whether there is a workaround for this issue and how these connections can be closed safely without restarting the server.

[rski]

The code developer says that the code for closing these idleconnections are included in the code itself.

So it seems this code is not working and somebody should fix it. I don't think there is a postgres option which will make postgres to close idle connections. If you use unix/linx system you can look for process with 'idle' tag and kill it but I don't think it is a good solution.
It should be fixed in code.

[rski]

Use pgpool-II application. It has client_idle_limit config parameter.