First check what are the running processes by
SELECT * FROM pg_stat_activity WHERE state = 'active';
Find the process you want to kill, then type:
SELECT pg_cancel_backend()
If the process cannot be killed, try:
SELECT pg_terminate_backend()
First check what are the running processes by
SELECT * FROM pg_stat_activity WHERE state = 'active';
Find the process you want to kill, then type:
SELECT pg_cancel_backend()
If the process cannot be killed, try:
SELECT pg_terminate_backend()
Thanks for joining me!
Good company in a journey makes the way seem shorter. — Izaak Walton
