Skip to content

Artificial Wisdom

  • Home
  • Contact

PSQL Running Tasks

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()

Source – StackOverflow

odhranhardy SQL Leave a comment August 1, 2018 1 Minute

The Journey Begins

Thanks for joining me!

Good company in a journey makes the way seem shorter. — Izaak Walton

post

odhranhardy Uncategorized Leave a comment August 1, 2018August 1, 2018 1 Minute
Website Powered by WordPress.com.
Privacy & Cookies: This site uses cookies. By continuing to use this website, you agree to their use.
To find out more, including how to control cookies, see here: Cookie Policy
  • Subscribe Subscribed
    • Artificial Wisdom
    • Already have a WordPress.com account? Log in now.
    • Artificial Wisdom
    • Subscribe Subscribed
    • Sign up
    • Log in
    • Report this content
    • View site in Reader
    • Manage subscriptions
    • Collapse this bar
 

Loading Comments...
 

    Design a site like this with WordPress.com
    Get started