Skip to content

Instantly share code, notes, and snippets.

@ray-odoo

ray-odoo/gist:b0b474d2246d662c9207ac2294f63833

Created December 7, 2018 18:54
Show Gist options
  • Save ray-odoo/b0b474d2246d662c9207ac2294f63833 to your computer and use it in GitHub Desktop.
Save ray-odoo/b0b474d2246d662c9207ac2294f63833 to your computer and use it in GitHub Desktop.
Download ZIP
KILL PostgreSQL connections preventing an Odoo database from being deleted (without restarting PostgreSQL)
Raw
gistfile1.txt
SELECT pg_terminate_backend(pid) FROM pg_stat_activity WHERE pid <> pg_backend_pid() AND datname = 'database_name';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment