Postgres-9.1 having more Idle connections The connections were created 2 days before. Can I kill the process manually by using the below query?

select pg_terminate_backend(procpid)
from pg_stat_activity
where datname = 'mydb'
and procpid &lt;&gt; pg_backend_pid()
and current_query = '&lt;IDLE&gt;'
and query_start &lt; now() - INTERVAL '2880' MINUTE;
The answer is: "Yes, sure you can." But I doubt you wanted to ask that.

Obviously, you need to make sure you only kill processes that need killing.
If possible, it's best done with the same role as the targeted processes to avoid collateral damage - only superusers can terminate processes of other roles.

Related:


How do I detach all other users from a postgres database?