0

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 <> pg_backend_pid()
and current_query = '<IDLE>'
and query_start < now() - INTERVAL '2880' MINUTE;
1

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:

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.